pg view of table columns needed for scripting

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg view of table columns needed for scripting
Date: 2010-10-22 16:14:01
Message-ID: 482E80323A35A54498B8B70FF2B87980047B2B26C2@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

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.

Thanks in Advance !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-10-22 16:19:33 Re: Gripe: bytea_output default => data corruption
Previous Message Peter Bex 2010-10-22 16:13:31 Re: Advice needed on application/database authentication/authorization/auditing model