Re: Need help accessing TABLES, COLUMNS, DESCRIPTIONS

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Robert Paresi <firstname(at)lastname(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help accessing TABLES, COLUMNS, DESCRIPTIONS
Date: 2011-01-21 23:07:10
Message-ID: 4D3A119E.4050408@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniele Varrazzo 2011-01-21 23:34:08 Re: Constraint exclusion with box and integer
Previous Message MargaretGillon 2011-01-21 21:32:00 Re: pg_dumpall backup script w. ftp ; pgpass file ; after upgrade to Ubuntu 10.4 (lucid) and Postgresql 9.0.2