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.

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:

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster