Re: Getting list of columns in a table

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(at)wallace(dot)com> writes:

> 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(at)wallace(dot)com
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster