Find clusters containing a schema?

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Find clusters containing a schema?
Date: 2007-10-01 17:14:36
Message-ID: 20071001121436.0a6e9ef5@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nurlan Mukhanov 2007-10-01 17:19:15 Strange behavior of TRIGGER
Previous Message Alan Hodgson 2007-10-01 17:12:05 Re: more problems with count(*) on large table