schemas

#1

How can I see all the schemas in a Postgres database? There is, of course,
"select distinct schema from pg_tables" but what if the schema contains
no tables? There is no pg_schemas table.

--
http://mgogala.byethost5.com

#2

Mladen Gogala wrote on 06.08.2010 00:40:

Quote:

How can I see all the schemas in a Postgres database? There is, of course,
"select distinct schema from pg_tables" but what if the schema contains
no tables? There is no pg_schemas table.

http://www.postgresql.org/docs/curre...-schemata.html
http://www.postgresql.org/docs/curre...namespace.html

#3

On Fri, 06 Aug 2010 00:53:25 +0200, Thomas Kellerer wrote:

Quote:

Mladen Gogala wrote on 06.08.2010 00:40:
How can I see all the schemas in a Postgres database? There is, of
course, "select distinct schema from pg_tables" but what if the schema
contains no tables? There is no pg_schemas table.

http://www.postgresql.org/docs/curre...-schemata.html
http://www.postgresql.org/docs/curre...namespace.html

Thanks, Thomas.

--
http://mgogala.byethost5.com

#4

From psql:

\dn

Il 06/08/2010 0.40, Mladen Gogala ha scritto:

Quote:

How can I see all the schemas in a Postgres database? There is, of course,
"select distinct schema from pg_tables" but what if the schema contains
no tables? There is no pg_schemas table.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

schemas

comp.databases.postgresql comp.databases.postgresql

schemas - 08-05-2010 , 05:40 PM

Re: schemas - 08-05-2010 , 05:53 PM

Re: schemas - 08-05-2010 , 08:14 PM

Re: schemas - 08-06-2010 , 03:36 AM