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: [EMAIL PROTECTED] > [mailto:pgsql-sql-owner@;postgresql.org]On Behalf Of Jean-Luc Lachance > Sent: Wednesday, November 13, 2002 12:37 > Cc: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED])