Getting list of columns in a table
Sorry if this is a FAQ, but didn't see it in the web site FAQ or in the
docs I have.
I need a SQL statement which will return a list of the column names for
a (possibly empty) table. FWIW, I'm using Perl and DBI.
TiA,
Mike
mblackwell@wallace.com
The trick is to fire up psql with -E flag. That causes psql to spit
out the SQL it uses to query the system tables for things like:
\d tablename
I believe that the query you need is:
SELECT a.attname
FROM pg_class c, pg_attribute a
WHERE c.relname = 'schedule'
AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum;
Jason
Mike Blackwell <mblackwell@wallace.com> writes:
Show quoted text
Sorry if this is a FAQ, but didn't see it in the web site FAQ or in the
docs I have.I need a SQL statement which will return a list of the column names for
a (possibly empty) table. FWIW, I'm using Perl and DBI.TiA,
Mike
mblackwell@wallace.com---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster