Find clusters containing a schema? - Mailing list pgsql-general

From Josh Trutwin
Subject Find clusters containing a schema?
Date
Msg-id 20071001121436.0a6e9ef5@sinkhole.intrcomm.net
Whole thread Raw
Responses Re: Find clusters containing a schema?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: more problems with count(*) on large table
Next
From: "Gauthier, Dave"
Date:
Subject: Upgrading PG