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 < ach...@matrix.gatewaynet.com> wrote: > On Πεμ 15 Ποε 2012 20:31:05 Xiaobo Gu wrote: > > Hi, > > > > How can I list all schema names inside a PostgreSQL database through > > SQL, especially thoese without any objects created inside it. > > > > > > 1st solution : > > 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 >
