Re: RE: [SQL] System´s database table - Mailing list pgsql-sql

From Jean-Luc Lachance
Subject Re: RE: [SQL] System´s database table
Date
Msg-id 3DD2C418.5D28C637@nsd.ca
Whole thread Raw
In response to RE: [SQL] System´s database table  ("Paul Ogden" <pogden@claresco.com>)
Responses Re: RE: [SQL] System´s database table  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-sql
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)


pgsql-sql by date:

Previous
From: "Paul Ogden"
Date:
Subject: RE: [SQL] System´s database table
Next
From: Tim Perdue
Date:
Subject: Old "Feature" - Copy table ignores column defaults