pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Finding filenames for tables
3+ messages / 3 participants
[nested] [flat]
* Finding filenames for tables
@ 2003-05-13 22:30 Jamie Lawrence <pgsql@jal.org>
2003-05-13 21:52 ` Re: Finding filenames for tables Andreas Pflug <Andreas.Pflug@web.de>
0 siblings, 1 reply; 3+ messages in thread
From: Jamie Lawrence @ 2003-05-13 22:30 UTC (permalink / raw)
To: pgsql-performance
I must be having a bad search-engine day.
How do I join pg_class and pg_database to determine OID/tablename
pairs for a given database? I can't find anything to join on in those
tables. I'm just grepping output right now, but I'd like to do more
complicated things in the future, thus my question.
-j
--
Jamie Lawrence jal@jal.org
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Finding filenames for tables
2003-05-13 22:30 Finding filenames for tables Jamie Lawrence <pgsql@jal.org>
@ 2003-05-13 21:52 ` Andreas Pflug <Andreas.Pflug@web.de>
2003-05-14 00:11 ` Re: Finding filenames for tables Jamie Lawrence <postgres@jal.org>
0 siblings, 1 reply; 3+ messages in thread
From: Andreas Pflug @ 2003-05-13 21:52 UTC (permalink / raw)
To: Jamie Lawrence <pgsql@jal.org>; pgsql-performance
Jamie Lawrence wrote:
>How do I join pg_class and pg_database to determine OID/tablename
>pairs for a given database? I can't find anything to join on in those
>tables. I'm just grepping output right now, but I'd like to do more
>complicated things in the future, thus my question.
>
>
Jamie,
you don't need to join since pg_class is specific for a database. You
cannot see any classes from a different database in pg_class. In
contrast, pg_database is server-wide mirrored.
Regards,
Andreas
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Finding filenames for tables
2003-05-13 22:30 Finding filenames for tables Jamie Lawrence <pgsql@jal.org>
2003-05-13 21:52 ` Re: Finding filenames for tables Andreas Pflug <Andreas.Pflug@web.de>
@ 2003-05-14 00:11 ` Jamie Lawrence <postgres@jal.org>
0 siblings, 0 replies; 3+ messages in thread
From: Jamie Lawrence @ 2003-05-14 00:11 UTC (permalink / raw)
To: pgsql-performance
On Tue, 13 May 2003, Andreas Pflug wrote:
> you don't need to join since pg_class is specific for a database. You
> cannot see any classes from a different database in pg_class. In
> contrast, pg_database is server-wide mirrored.
Thank you! I had sufficiently confused myself that I didn't even think
to wonder if this was the case or not.
Thanks again.
-j
--
Jamie Lawrence jal@jal.org
"It only takes 20 years for a liberal to become a conservative
without changing a single idea."
- Robert Anton Wilson
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-05-14 00:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-13 22:30 Finding filenames for tables Jamie Lawrence <pgsql@jal.org>
2003-05-13 21:52 ` Andreas Pflug <Andreas.Pflug@web.de>
2003-05-14 00:11 ` Jamie Lawrence <postgres@jal.org>
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