> 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_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
