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
>