Hi, On 15 November 2012 23:31, Xiaobo Gu <guxiaobo1...@gmail.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general