Re: SELECT database meta-info? - Mailing list pgsql-novice

From Dani Oderbolz
Subject Re: SELECT database meta-info?
Date
Msg-id 3EC775AB.4080206@ecologic.de
Whole thread Raw
In response to SELECT database meta-info?  (Rene Veerman <rene@outerheaven.net>)
List pgsql-novice
Rene Veerman wrote:

>Hi. I can't find the manual entry on how to get meta-information out of a
>postgresql db. I'm particularly interested in which tables exist in a db, and
>what the field-types are for their fields.
>
>Greets,
> RV
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
Hi,
check for "system catalogs" in the documentation. You will find that all
the
Metadata tabbles have a name starting with pg_.

Cheers, Dani



pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: 7.2.1 => 7.3.2
Next
From: Dani Oderbolz
Date:
Subject: Re: Problems with join (no such attribute, but it exists)