From: | glenn <gdavy(at)tpg(dot)com(dot)au> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Meta data about object in postgres |
Date: | 2004-01-19 14:02:11 |
Message-ID: | 1074520931.30390.6.camel@odin.valhalla |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi -
I've always wanted to know this - so now I've got an excuse to find out.
Ok. Check out chapter 44 of the doco called "system catalogs" - it looks
quite promising (though not overly friendly or straight forward),
especially tables pg_database, pg_class and pg_attribute.
Glenn
On Wed, 2004-01-14 at 20:00, Raghu wrote:
> Hi,
> I am relatively new to postgres. I want to know if there are tables
> (Meta data tables) that give me information abt all the tables that
> exist in my database etc. Some thing similar to all_tables in oracle.
>
> Also, is there a command to describe the columns in the table. Similar
> to desc table_name in oracle.
>
> Thanx in advance,
> Raghu.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | George Weaver | 2004-01-19 15:41:46 | Re: How can I select a comment on a column in a query? |
Previous Message | Tom Lane | 2004-01-19 07:50:44 | Re: Discarding UNIQUE temporarily? |