In psql:
\d [table name]
Regards,
Sergio Pili
> -----Mensaje original-----
> De: Terry Hampton [SMTP:thampton@limacorp.com]
> Enviado el: Jueves 18 de Diciembre de 2003 17:31
> Para: pgsql-admin@postgresql.org
> 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