From: Robert Treat <xzilla@users.sourceforge.net>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: pogden@claresco.com
Cc: pgsql-sql@postgresql.org
Subject: Re: RE: [SQL] System´s database table
Date: 14 Nov 2002 18:04:04 -0500
Message-ID: <1037315044.4722.107.camel@camel> (raw)
In-Reply-To: <3DD2C418.5D28C637@nsd.ca>
References: <NAEOJBHEEOEHNNICGFADOEDNDFAA.pogden@claresco.com>
<3DD2C418.5D28C637@nsd.ca>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xzilla@users.sourceforge.net, jllachan@nsd.ca, pogden@claresco.com
Subject: Re: RE: [SQL] System´s database table
In-Reply-To: <1037315044.4722.107.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox