pg view of table columns needed for scripting - Mailing list pgsql-general

From Gauthier, Dave
Subject pg view of table columns needed for scripting
Date
Msg-id 482E80323A35A54498B8B70FF2B87980047B2B26C2@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: pg view of table columns needed for scripting  (bricklen <bricklen@gmail.com>)
Re: pg view of table columns needed for scripting  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
List 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 !

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Advice needed on application/database authentication/authorization/auditing model
Next
From: Peter Bex
Date:
Subject: Re: Advice needed on application/database authentication/authorization/auditing model