> Well, you can't. Each database has it's own pg_class (and other)
> catalog table and tables in any given database are not visible from
> others.
Ah well of course, that's the answer to my question. Only the entries for
the tables in the database to which I am currently connected are visible, so
On Oct 18, 2009, at 5:02 PM, Scott Ribe wrote:
I've figured out how to use the catalogs to get from table name to
name of
file(s) on disk, and also the toast files. But what I don't see is
how to
handle the case where a cluster contains multiple databases with
tables of
the same name--I fa
I've figured out how to use the catalogs to get from table name to name of
file(s) on disk, and also the toast files. But what I don't see is how to
handle the case where a cluster contains multiple databases with tables of
the same name--I fail to follow the oid keys somewhere along the way.
I do