Thanks a lot.
On Fri, Nov 16, 2012 at 5:33 AM, Ondrej Ivanič wrote:
Hi,
On 15 November 2012 23:31, Xiaobo Gu 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)

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 7 of 7 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedNov 15, '12 at 12:31p
activeNov 19, '12 at 5:05a
posts7
users5
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase