Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B9A0F475EE2
	for <pgsql-sql@postgresql.org>; Wed, 13 Nov 2002 16:29:11 -0500 (EST)
Received: from beamish.nsd.ca (unknown [205.150.156.194])
	by postgresql.org (Postfix) with ESMTP id 1FBBB4762FE
	for <pgsql-sql@postgresql.org>; Wed, 13 Nov 2002 16:29:10 -0500 (EST)
Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id QAA05978;
	Wed, 13 Nov 2002 16:28:38 -0500
X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca>
	using -f
Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap
	(V2.1/2.1+anti-relay+anti-spam)
	id xma005972; Wed, 13 Nov 02 16:28:27 -0500
Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
	by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id QAA30703;
	Wed, 13 Nov 2002 16:27:33 -0500
Message-ID: <3DD2C418.5D28C637@nsd.ca>
Date: Wed, 13 Nov 2002 16:28:56 -0500
From: Jean-Luc Lachance <jllachan@nsd.ca>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pogden@claresco.com
Cc: pgsql-sql@postgresql.org
Subject: Re: RE: [SQL] =?iso-8859-1?Q?System=B4s?= database table
References: <NAEOJBHEEOEHNNICGFADOEDNDFAA.pogden@claresco.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by reddog.nsd.ca id
	QAA30703
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/216
X-Sequence-Number: 10358

Thanks,  I know about that.=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

JLL

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)