> 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
there's no problem. (I didn't want to see other tables with the same name; I
wanted to avoid getting info on the wrong table.)

In hindsight, this should have been completely obvious. But I was looking at
the stuff regarding schemas and their ownership of tables, and got confused
thinking "yeah well, what about all the owning databases".

-- 
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to