Re: Finding filenames for tables

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