In psql: \d [table name]
Regards, Sergio Pili > -----Mensaje original----- > De: Terry Hampton [SMTP:[EMAIL PROTECTED] > Enviado el: Jueves 18 de Diciembre de 2003 17:31 > Para: [EMAIL PROTECTED] > Asunto: [ADMIN] Quick Question Please > > > All, > > Seem to be having a brain lock. > > What is the method or syntax to return > a list of column names for a given table name ? > > many thanks for your quick help, > Terry > > > > -- > Terry L. Hampton > Program Manager > LimaCorp, LLC. www.limacorp.com > 513.587.1874 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match