[PostgreSQL] How to list all schema names inside a PostgreSQL database through SQL

[PostgreSQL] How to list all schema names inside a PostgreSQL database through SQL

	Xiaobo Gu
	Nov 15, 2012 at 12:31 pm

Hi,

How can I list all schema names inside a PostgreSQL database through
SQL, especially thoese without any objects created inside it.

Regards,

Xiaobo Gu

Search Discussions

Discussion Posts

Follow ups

Виктор Егоров: Something like this: select n.nspname, count(o.oid) from pg_namespace n left join pg_class o on n.oid=o.relnamespace group by 1 order by count(o.oid)>0, 1; I prefer to query PostgreSQL catalogs. You can obtain the same information using information_schema queries. -- Victor Y. Yegorov
Achilleas Mantzios: 1st solution : select catalog_name,schema_name from information_schema.schemata ; 2nd solution : select * from pg_namespace ; - Achilleas Mantzios IT DEPT
Sk baji: 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.

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 1 of 7 \| next ›

Discussion Overview

group	pgsql-general @
categories	postgresql
posted	Nov 15, '12 at 12:31p
active	Nov 19, '12 at 5:05a
posts	7
users	5
website	postgresql.org
irc	#postgresql

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[PostgreSQL] How to list all schema names inside a PostgreSQL database through SQL

Search Discussions

Discussion Posts

Related Discussions

5 users in discussion