On Fri, Oct 22, 2010 at 9:14 AM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > Is there something like a pg_xxx view that I can use to get the column names > and data types of a table, similar to what I see with \d ? I need to run > this is a script, so \d isn't viable. I did a \df and looked around, but > nothing popped out. psql -E -d dbname Will give you the internal queries that are executed by things like \d etc -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
