Find clusters containing a schema?

Started by Josh Trutwinover 18 years ago2 messagesgeneral
Jump to latest
#1Josh Trutwin
josh@trutwins.homeip.net

Is it possible to somehow query the system catalog to find out which
clusters/databases have a certain schema?

When running the query:

SELECT * FROM pg_catalog.pg_namespace WHERE nspname = 'myschema';

It always only finds data for the current session, not all clusters,
even when connected as postgres.

Thanks,

Josh

#2Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Josh Trutwin (#1)
Re: Find clusters containing a schema?

Josh Trutwin wrote:

Is it possible to somehow query the system catalog to find out which
clusters/databases have a certain schema?

No, unless you connect to each database in turn.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.