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

2012/11/15 Xiaobo Gu <guxiaobo1982@gmail.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