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:1st solution :
> Hi,
>
> How can I list all schema names inside a PostgreSQL database through
> SQL, especially thoese without any objects created inside it.
>
>
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 по дате отправления: