schemas in 7.3b1

From: Chris <pggeneral(at)designmagick(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: schemas in 7.3b1
Date: 2002-10-03 13:44:52
Message-ID: 3d9c49c7_1@news.iprimus.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Just a quick question.

Is there an easy way to get a list of schemas in a database?

serverlogs=# SELECT version();
version
---------------------------------------------------------------
PostgreSQL 7.3b1 on i586-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

serverlogs=# CREATE SCHEMA dwarf;
CREATE SCHEMA
serverlogs=# SELECT current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row)

I found the pg_namespace table, but that doesn't tell me what database
has a particular schema..

I checked the developer docs but I couldn't find anything there.

Thanks,
Chris.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-03 13:55:08 Re: Oracle SGA like feature???
Previous Message Joe Lester 2002-10-03 13:44:50 Inquiry From Form [pgsql]