On Fri, 27 Jul 2001, [iso-8859-1] María Elena Hernández wrote: > Is it possible to get thecoluns names of an a table in the database with a sql > query?? "psql -E" will show the SQL commands that psql internally uses to display tables, database, etc. Once in psql, use "\d table_name" to see fields in a table and the SQL behind that. -- Joel Burton <[EMAIL PROTECTED]> Director of Information Systems, Support Center of Washington ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])