pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: System´s database table
7+ messages / 5 participants
[nested] [flat]
* System´s database table
@ 2002-11-13 20:53 Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 7+ messages in thread
From: Pedro Igor Craveiro e Silva @ 2002-11-13 20:53 UTC (permalink / raw)
To: pgsql-sql
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 ....
Tanks ...
Pedro Igor
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
@ 2002-11-13 20:06 ` Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Re: System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
0 siblings, 1 reply; 7+ messages in thread
From: Josh Berkus @ 2002-11-13 20:06 UTC (permalink / raw)
To: Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>; pgsql-sql
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
@ 2002-11-13 20:37 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-13 20:43 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
2002-11-13 20:44 ` RE: [SQL] System´s database table Paul Ogden <pogden@claresco.com>
0 siblings, 2 replies; 7+ messages in thread
From: Jean-Luc Lachance @ 2002-11-13 20:37 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Re: System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-11-13 20:43 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 7+ messages in thread
From: Josh Berkus @ 2002-11-13 20:43 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pgsql-sql
Jean-Luc,
> While we are on the subject,
> is there any ERD of the system's table somewhere?
Don't know ... but the system tables are about to change in 7.3.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: [SQL] System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Re: System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-11-13 20:44 ` Paul Ogden <pogden@claresco.com>
2002-11-13 21:28 ` Re: RE: [SQL] System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
1 sibling, 1 reply; 7+ messages in thread
From: Paul Ogden @ 2002-11-13 20:44 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: RE: [SQL] System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Re: System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-13 20:44 ` RE: [SQL] System´s database table Paul Ogden <pogden@claresco.com>
@ 2002-11-13 21:28 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-14 23:04 ` Re: RE: [SQL] System´s database table Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 7+ messages in thread
From: Jean-Luc Lachance @ 2002-11-13 21:28 UTC (permalink / raw)
To: pogden@claresco.com; +Cc: 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)
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: RE: [SQL] System´s database table
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Re: System´s database table Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Re: System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-13 20:44 ` RE: [SQL] System´s database table Paul Ogden <pogden@claresco.com>
2002-11-13 21:28 ` Re: RE: [SQL] System´s database table Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-11-14 23:04 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 7+ messages in thread
From: Robert Treat @ 2002-11-14 23:04 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pogden@claresco.com; pgsql-sql
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)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2002-11-14 23:04 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-13 20:53 System´s database table Pedro Igor Craveiro e Silva <pedroigor@aip.com.br>
2002-11-13 20:06 ` Josh Berkus <josh@agliodbs.com>
2002-11-13 20:37 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-13 20:43 ` Josh Berkus <josh@agliodbs.com>
2002-11-13 20:44 ` Paul Ogden <pogden@claresco.com>
2002-11-13 21:28 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-11-14 23:04 ` Robert Treat <xzilla@users.sourceforge.net>
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