[PostgreSQL] How to list all schema names inside a PostgreSQL database through SQL

On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič wrote:
Hi,
Use -E psql's option:
-E, --echo-hidden display queries that internal commands generate

then you get SQL query for each internal command.

The second option is to use information_schema.schemata view (this is
works across databases)


--
Ondrej Ivanic
(http://www.linkedin.com/in/ondrejivanic)