Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help accessing TABLES, COLUMNS, DESCRIPTIONS - Mailing list pgsql-general

From Craig Ringer
Subject Re: Need help accessing TABLES, COLUMNS, DESCRIPTIONS
Date
Msg-id 4D3A119E.4050408@postnewspapers.com.au
Whole thread Raw
In response to Need help accessing TABLES, COLUMNS, DESCRIPTIONS  ("Robert Paresi" <firstname@lastname.net>)
List pgsql-general
Tree view 
On 01/21/2011 10:45 PM, Robert Paresi wrote:
> Hello,
>
> I can't figure this out, and need help.
>
> I need access (VIA SQL Statements) to retreive a list of all PUBLIC
> tables, columns and their descriptions.

Look at the INFORMATION_SCHEMA schema.

--
Craig Ringer

pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: pg_dumpall backup script w. ftp ; pgpass file ; after upgrade to Ubuntu 10.4 (lucid) and Postgresql 9.0.2
Next
From: Daniele Varrazzo
Date:
Subject: Re: Constraint exclusion with box and integer