Thread: Meta data about object in postgres

Meta data about object in postgres

From
raghu_k_n@yahoo.com (Raghu)
Date:
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.

Re: Meta data about object in postgres

From
glenn
Date:
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
>