[ 常見問題 ] How do I list all schemas in PostgreSQL?

Source From Here 
Question 
When using PostgreSQL v9.1, how do I list all of the schemas using SQL? 

How-To 
To lists all schemas, use the (ANSI) standard INFORMATION_SCHEMA: 

view plaincopy to clipboardprint?

1. select schema_name  
2. from information_schema.schemata  

More details in the manual: http://www.postgresql.org/docs/current/static/information-schema.html 

alternatively: 

view plaincopy to clipboardprint?

1. select nspname  
2. from pg_catalog.pg_namespace;  

More details about pg_catalog in the manual: http://www.postgresql.org/docs/current/static/catalogs.html 

Supplement 
* PostgreSQL Doc - Schemas 
* FAQ - How to select a schema in postgres when using psql? 

view plaincopy to clipboardprint?

1. # SET search_path TO myschema;  
2. # SET search_path TO myschema, public;  // want multiple schemas: