Thanks a lot. On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič <ondrej.ivanic@xxxxxxxxx> wrote: > Hi, > > On 15 November 2012 23:31, Xiaobo Gu <guxiaobo1982@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
