Re: [ADMIN] list schema

2002-12-06 Thread Tom Lane
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

[ADMIN] list schema

2002-12-05 Thread Jie Liang
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

Re: [ADMIN] list schema

2002-12-05 Thread Bruce Momjian
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

Re: [ADMIN] list schema

2002-12-05 Thread Bruce Momjian
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 --

Re: [ADMIN] list schema

2002-12-05 Thread Tom Lane
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

Re: [ADMIN] list schema

2002-12-05 Thread Larry Rosenman
--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

Re: [ADMIN] list schema

2002-12-05 Thread Jean-Luc Lachance
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}()

Re: [ADMIN] list schema

2002-12-05 Thread Jie Liang
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

Re: [ADMIN] list schema

2002-12-05 Thread Peter Eisentraut
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

Re: [ADMIN] list schema

2002-12-05 Thread Peter Childs
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