Re: How to list all schema names inside a PostgreSQL database through SQL

Поиск
Список
Период
Сортировка
От sk baji
Тема Re: How to list all schema names inside a PostgreSQL database through SQL
Дата
Msg-id CAAYGEJaJpoLVBJUKA28jMDBQHt_wuhNFOjRnLRyk8bx9bOPwmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to list all schema names inside a PostgreSQL database through SQL  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
Дерево обсуждения
If you are looking for list of empty schema's (No objects in schema), then you can use below query:

select nspname from pg_namespace where oid not in (select relnamespace from pg_class) and oid not in (select oid from pg_proc);


Regards,
Baji Shaik.

On Thu, Nov 15, 2012 at 6:13 PM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
On Πεμ 15 Ποε 2012 20:31:05 Xiaobo Gu wrote:
> Hi,
>
> How can I list  all schema names inside a PostgreSQL database through
> SQL, especially thoese without any objects created inside it.
>
>

1st solution :

select catalog_name,schema_name from information_schema.schemata ;

2nd solution :

select * from pg_namespace ;

> Regards,
>
> Xiaobo Gu
>
>
>
-
Achilleas Mantzios
IT DEPT


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: How to list all schema names inside a PostgreSQL database through SQL
Следующее
От: Igor Romanchenko
Дата:
Сообщение: Re: Strategies/Best Practises Handling Large Tables