Thread: system tables...
Hi, is there a system table in which postgres stores all data about newly created database? together with database objects, tables, columns, functions etc. thanks _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
Marko Rihtar wrote: > Hi, > > is there a system table in which postgres stores all data about newly > created database? > together with database objects, tables, columns, functions etc. Try the manuals under "System Catalogs". -- Richard Huxton Archonet Ltd
I guess pg_class, pg_database and pg_proc can help here....
Thanks,
------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Thanks,
------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/13/06, Marko Rihtar <riki_fox@hotmail.com> wrote:
Hi,
is there a system table in which postgres stores all data about newly
created database?
together with database objects, tables, columns, functions etc.
thanks
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly