In psql, do
\d table_name
It will tell you about all columns, indexes, and constraints.
On Thu, 18 Dec 2003, Terry Hampton wrote:
>
> 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
>
>
>
>
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University