Re: [ADMIN] list schema
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 \d[istvS] family. Maybe we should retire that thing? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] list schema
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 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 PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] list schema
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 -- 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 PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] list schema
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 thoughts? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] list schema
--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 already taken, and there was no good proposal for what to use instead. Any thoughts? \dn for NameSpace? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] list schema
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}() sp_disable_{that}() JLL 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, but \ds and \dS are already taken, and there was no good proposal for what to use instead. Any thoughts? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] list schema
I believe \dn is better. Jie Liang Software Engineer St. Bernard Software 16882 W. Bernardo Dr. San Diego, CA 92127 Tel: 858-524-2134 Fax:858-676-2228 [EMAIL PROTECTED] -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:36 PM 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, but \ds and \dS are already taken, and there was no good proposal for what to use instead. Any thoughts? I guess we have to go with the second letter, c, or use n for namespaces. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] list schema
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 PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] list schema
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 maybe we should go with full words. I think this sounds like a good idea. as they would be much easier to remember if its a full word. You can always leave the 1 leave the 1 letter abbrevations in anyway and have both! I also notice that on the todo list is a job to turn all these into views. It might be worth doing that (should not be too difficult I think) plus they could then be used from other client programs. Strictly I think this meta information should have its own access methods in the sql standard because currently sql is a broken standard with out this meta infomation. Peter Childs ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])