I guess pg_class, pg_database and pg_proc can help hereThanks,--Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/13/06,
Marko Rihtar <[EMAIL PROTECTED]> wrote:
Hi,is there a system table in which postgres stores all data about newlycreated database?together with database objects, tables,
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
---(end of bro
Robert Korteweg writes:
> I made a list of all the system tables and there columns in an ascii
> file. the only thing i am still missing is the meening of the columns :(
>
> Q: does anyone already have such a file with explanations to each
> column?
> Q: does anyone know if there is a more accura
Descriptions of the system tables can be found here:
http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm
Also, if you want to muddle through some PHP code, you can get phpPgAdmin
and checkout how the database and table structures are retrieved. It's all
done with standard queries.
Colin Taylor writes:
> Hi,
> Anyone know where I can get a decent description of the system tables and
> their contents?
> Thanks in advance,
> Colin
http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
