Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 245D2475B84 for ; Thu, 14 Nov 2002 18:04:05 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id 8C8BD475AA1 for ; Thu, 14 Nov 2002 18:04:04 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.5/8.12.5) with ESMTP id gAEN8F6P026786; Thu, 14 Nov 2002 18:08:15 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id gAEN44j01550; Thu, 14 Nov 2002 18:04:04 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id W7RLWLR2; Thu, 14 Nov 2002 18:04:03 -0500 Subject: Re: RE: [SQL] =?ISO-8859-1?Q?System=B4s?= database table From: Robert Treat To: Jean-Luc Lachance Cc: pogden@claresco.com, pgsql-sql@postgresql.org In-Reply-To: <3DD2C418.5D28C637@nsd.ca> References: <3DD2C418.5D28C637@nsd.ca> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Mailer: Ximian Evolution 1.0.8 Date: 14 Nov 2002 18:04:04 -0500 Message-Id: <1037315044.4722.107.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/221 X-Sequence-Number: 10363 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.=20=20 >=20 > 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 >=20 > JLL >=20 > Paul Ogden wrote: > >=20 > > It's not ERD but I've found the information in the Developer's Guide > > regarding system catalogs to be useful in the past. > >=20 > > This http://www.postgresql.org/idocs/index.php?catalogs.html will > > get you started. > >=20 > > Thanks, > >=20 > > Paul Ogden > > Claresco Corporation > >=20 > > > -----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=B4s database table > > > > > > > > > While we are on the subject, > > > is there any ERD of the system's table somewhere? > > > > > > JLL > > > > > > > > > Josh Berkus wrote: > > > > > > > > Pedro, > > > > > > > > > I=B4m looking for the name of the table that contains all > > > databases in my > > > > system. I already see this in the postgre manual, but i=B4m > > > 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 > >=20 > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)