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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
