From: Paul Ogden <pogden@claresco.com>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: pgsql-sql@postgresql.org
Subject: RE: [SQL] System´s database table
Date: Wed, 13 Nov 2002 12:44:19 -0800
Message-ID: <NAEOJBHEEOEHNNICGFADOEDNDFAA.pogden@claresco.com> (raw)
In-Reply-To: <3DD2B7FD.FD0D3858@nsd.ca>
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
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: pogden@claresco.com, jllachan@nsd.ca
Subject: RE: [SQL] System´s database table
In-Reply-To: <NAEOJBHEEOEHNNICGFADOEDNDFAA.pogden@claresco.com>
* 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