Thread: System´s database table
I´m looking for the name of the table that contains all databases in my system. I already see this in the postgre manual, but i´m forgot where ....
Tanks ...
Pedro Igor
Pedro, > I´m looking for the name of the table that contains all databases in my system. I already see this in the postgre manual, but i´m forgot where .... pg_database -- -Josh Berkus Aglio Database Solutions San Francisco
While we are on the subject, is there any ERD of the system's table somewhere? JLL Josh Berkus wrote: > > Pedro, > > > I´m looking for the name of the table that contains all databases in my > system. I already see this in the postgre manual, but i´m forgot where .... > > pg_database > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
Jean-Luc, > While we are on the subject, > is there any ERD of the system's table somewhere? Don't know ... but the system tables are about to change in 7.3. -- -Josh Berkus Aglio Database Solutions San Francisco
It's not ERD but I've found the information in the Developer's Guide regarding system catalogs to be useful in the past. This http://www.postgresql.org/idocs/index.php?catalogs.html will get you started. Thanks, Paul Ogden Claresco Corporation > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Jean-Luc Lachance > Sent: Wednesday, November 13, 2002 12:37 > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] System´s database table > > > While we are on the subject, > is there any ERD of the system's table somewhere? > > JLL > > > Josh Berkus wrote: > > > > Pedro, > > > > > I´m looking for the name of the table that contains all > databases in my > > system. I already see this in the postgre manual, but i´m > forgot where .... > > > > pg_database > > > > -- > > -Josh Berkus > > Aglio Database Solutions > > San Francisco > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
Thanks, I know about that. I was just hoping for a nice diagram. I guess I will have to wait for 7.3 anyhow if I do not want to waste my time doing one for 7.2 JLL Paul Ogden wrote: > > It's not ERD but I've found the information in the Developer's Guide > regarding system catalogs to be useful in the past. > > This http://www.postgresql.org/idocs/index.php?catalogs.html will > get you started. > > Thanks, > > Paul Ogden > Claresco Corporation > > > -----Original Message----- > > From: pgsql-sql-owner@postgresql.org > > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Jean-Luc Lachance > > Sent: Wednesday, November 13, 2002 12:37 > > Cc: pgsql-sql@postgresql.org > > Subject: Re: [SQL] System´s database table > > > > > > While we are on the subject, > > is there any ERD of the system's table somewhere? > > > > JLL > > > > > > Josh Berkus wrote: > > > > > > Pedro, > > > > > > > I´m looking for the name of the table that contains all > > databases in my > > > system. I already see this in the postgre manual, but i´m > > forgot where .... > > > > > > pg_database > > > > > > -- > > > -Josh Berkus > > > Aglio Database Solutions > > > San Francisco > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
There's no sense waiting as 7.3 is about to go RC1, and only the most improbable circumstances would lead to a system catalog change at this point. (If you do make a diagram, please post it to the group ) Robert Treat On Wed, 2002-11-13 at 16:28, Jean-Luc Lachance wrote: > Thanks, I know about that. > > I was just hoping for a nice diagram. > I guess I will have to wait for 7.3 anyhow if I do not want to waste my > time doing one for 7.2 > > JLL > > Paul Ogden wrote: > > > > It's not ERD but I've found the information in the Developer's Guide > > regarding system catalogs to be useful in the past. > > > > This http://www.postgresql.org/idocs/index.php?catalogs.html will > > get you started. > > > > Thanks, > > > > Paul Ogden > > Claresco Corporation > > > > > -----Original Message----- > > > From: pgsql-sql-owner@postgresql.org > > > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Jean-Luc Lachance > > > Sent: Wednesday, November 13, 2002 12:37 > > > Cc: pgsql-sql@postgresql.org > > > Subject: Re: [SQL] System´s database table > > > > > > > > > While we are on the subject, > > > is there any ERD of the system's table somewhere? > > > > > > JLL > > > > > > > > > Josh Berkus wrote: > > > > > > > > Pedro, > > > > > > > > > I´m looking for the name of the table that contains all > > > databases in my > > > > system. I already see this in the postgre manual, but i´m > > > forgot where .... > > > > > > > > pg_database > > > > > > > > -- > > > > -Josh Berkus > > > > Aglio Database Solutions > > > > San Francisco > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)