Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
I was going to add one for schemas, but \ds and \dS are already taken,
and there was no good proposal for what to use instead. Any thoughts?
\dschema
I would have done that, but it doesn't fit nicely beside the behavior
of the
Bruce,
I wonder which command can show all schemas in 7.3?
I mean:
\dt -- show all tables
\l -- show all databases
?? -- show all schemas
Thanks.
Jie Liang
Software Engineer
St. Bernard Software
16882 W. Bernardo Dr.
San Diego, CA 92127
Tel: 858-524-2134
Fax:858-676-2228
[EMAIL
We should have one, but the only solution now is:
test= select * from pg_namespace;
---
Jie Liang wrote:
Bruce,
I wonder which command can show all schemas in 7.3?
I mean:
\dt -- show all tables
\l -- show
Also, on TODO I see:
* Add schema, cast, and conversion backslash commands to psql
so we know we need them.
---
Jie Liang wrote:
Bruce,
I wonder which command can show all schemas in 7.3?
I mean:
\dt --
Bruce Momjian [EMAIL PROTECTED] writes:
Also, on TODO I see:
* Add schema, cast, and conversion backslash commands to psql
so we know we need them.
I was going to add one for schemas, but \ds and \dS are already taken,
and there was no good proposal for what to use instead. Any
--On Thursday, December 05, 2002 15:33:01 -0500 Tom Lane
[EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Also, on TODO I see:
* Add schema, cast, and conversion backslash commands to psql
so we know we need them.
I was going to add one for schemas, but \ds and \dS are
How about \D for Domains...
BTW, because many people ask how to do the equivalant in SQL of a \
command,
why not be done with the \ commands which are criptic anyway and instead
create global stored procedures like:
sp_list_databases()
sp_list_schemas()
sp_list_{whatever}()
sp_enable_{this}()
To: Tom Lane
Cc: Jie Liang; [EMAIL PROTECTED]
Subject: Re: [ADMIN] list schema
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Also, on TODO I see:
* Add schema, cast, and conversion backslash commands to psql
so we know we need them.
I was going to add one for schemas
Tom Lane writes:
I was going to add one for schemas, but \ds and \dS are already taken,
and there was no good proposal for what to use instead. Any thoughts?
\dschema
Pretty soon we'll have too many things for 'c' as well, so maybe we should
go with full words.
--
Peter Eisentraut [EMAIL
On Thursday 05 December 2002 23:21, Peter Eisentraut wrote:
Tom Lane writes:
I was going to add one for schemas, but \ds and \dS are already taken,
and there was no good proposal for what to use instead. Any thoughts?
\dschema
Pretty soon we'll have too many things for 'c' as well, so
10 matches
Mail list logo