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

2012/11/15 Xiaobo Gu <guxiaobo1982(at)gmail(dot)com>:
> How can I list all schema names inside a PostgreSQL database through
> SQL, especially thoese without any objects created inside it.

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