2012/11/15 Xiaobo Gu <guxiaobo1...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general