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

[Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general