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@designmagick.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@designmagick.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@candle.pha.pa.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@candle.pha.pa.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@candle.pha.pa.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@candle.pha.pa.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