Re: schemas in 7.3b1

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.

Chris <pggeneral(at)designmagick(dot)com> writes:
> Is there an easy way to get a list of schemas in a database?
> I found the pg_namespace table, but that doesn't tell me what database
> has a particular schema.

Yours. pg_namespace is local to a database, same as most other
system catalogs.

We had meant to add a \d command for listing schemas in psql, but
both \ds and \dS are taken already :-(. Any ideas out there for
a reasonable choice?

regards, tom lane

Tom Lane wrote:
> Chris <pggeneral(at)designmagick(dot)com> writes:
> > Is there an easy way to get a list of schemas in a database?
> > I found the pg_namespace table, but that doesn't tell me what database
> > has a particular schema.
>
> Yours. pg_namespace is local to a database, same as most other
> system catalogs.
>
> We had meant to add a \d command for listing schemas in psql, but
> both \ds and \dS are taken already :-(. Any ideas out there for
> a reasonable choice?

Is this a TODO item?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Tom Lane writes:
> We had meant to add a \d command for listing schemas in psql, but
> both \ds and \dS are taken already :-(. Any ideas out there for
> a reasonable choice?

Howabout '\dschema', or would non-single-character choices need
further parsing code?

For want of anything better... '\dz'.

L.

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> We had meant to add a \d command for listing schemas in psql, but
>> both \ds and \dS are taken already :-(. Any ideas out there for
>> a reasonable choice?

> Is this a TODO item?

Yeah, at this point I guess it is --- I had meant to get it done for
7.3, but I suppose it's too late now.

Now that I think about it, casts and conversions are two more new object
kinds that perhaps deserve \d support.

regards, tom lane

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Tom Lane wrote:
> >> We had meant to add a \d command for listing schemas in psql, but
> >> both \ds and \dS are taken already :-(. Any ideas out there for
> >> a reasonable choice?
>
> > Is this a TODO item?
>
> Yeah, at this point I guess it is --- I had meant to get it done for
> 7.3, but I suppose it's too late now.
>
> Now that I think about it, casts and conversions are two more new object
> kinds that perhaps deserve \d support.

Added to TODO:

* Add schema, cast, and conversion backslash commands to psql

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Lee Kindness a écrit:
> Tom Lane writes:
> > We had meant to add a \d command for listing schemas in psql, but
> > both \ds and \dS are taken already :-(. Any ideas out there for
> > a reasonable choice?
>
> Howabout '\dschema', or would non-single-character choices need
> further parsing code?
>
> For want of anything better... '\dz'.

or d$ :\

Tom Lane wrote:
> We had meant to add a \d command for listing schemas in psql, but
> both \ds and \dS are taken already :-(. Any ideas out there for
> a reasonable choice?

\l is currently used to list databases. How about \ls to list
schemas?

> > Is there an easy way to get a list of schemas in a database?
> > I found the pg_namespace table, but that doesn't tell me what database
> > has a particular schema.
>
> Yours. pg_namespace is local to a database, same as most other
> system catalogs.
>
> We had meant to add a \d command for listing schemas in psql, but
> both \ds and \dS are taken already :-(. Any ideas out there for
> a reasonable choice?

\dn [PATTERN] list schema names/name spaces

-sc

--
Sean Chittenden