Hi, On 15 November 2012 23:31, Xiaobo Gu <[email protected]> wrote: > How can I list all schema names inside a PostgreSQL database through > SQL, especially thoese without any objects created inside it.
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) -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
