This is a follow up to my previous question about this
subject.
I found out there are existing tables that hold all of
the info about a database. All of them begin with
'pg_'
(ie 'pg_tables'). You can use all of these tables in
combination to get the data you need about your
database. I have come up with some basic queries to
start getting some info. When I get done with all of
the queries to get the info equivilant to typing '\d
*' in psql I will publish them to this mailing list.
In the meantime, here is a simple query that shows how
to get all the table names and owners:
SELECT * FROM pg_tables WHERE tablename !~ '^pg_';
Hope it helps,
Jeff Davis
PS: you can get some help also by looking at the psql
source code, that is how I found out.
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com