Find clusters containing a schema?

Поиск
Список
Период
Сортировка
От Josh Trutwin
Тема Find clusters containing a schema?
Дата
Msg-id 20071001121436.0a6e9ef5@sinkhole.intrcomm.net
обсуждение исходный текст
Ответы Re: Find clusters containing a schema?
Список 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 по дате отправления: