Re: SELECT database meta-info?

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To: Rene Veerman <rene(at)outerheaven(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SELECT database meta-info?
Date: 2003-05-18 11:59:39
Message-ID: 3EC775AB.4080206@ecologic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dani Oderbolz 2003-05-18 12:04:43 Re: Problems with join (no such attribute, but it exists)
Previous Message Octavio Alvarez 2003-05-18 10:09:22 Re: MSAccess-like Last() with sorting before grouping