Thread: SELECT database meta-info?

SELECT database meta-info?

From
Rene Veerman
Date:
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


Re: SELECT database meta-info?

From
Dani Oderbolz
Date:
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