From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <neilc(at)samurai(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: psql and schemas |
Date: | 2004-11-28 04:11:06 |
Message-ID: | 200411280411.iAS4B6u08153@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Is there a TODO here? Or a few?
---------------------------------------------------------------------------
Neil Conway wrote:
> On Sun, 2004-10-31 at 05:32, Tom Lane wrote:
> > The behaviors you mention were written at different times by different
> > people, and mostly have nothing to do with schemas per se. I agree that
> > some more consistency would probably be good. Do you have a specific
> > proposal?
>
> Sure, I just thought I'd check if there was method to psql's madness
> before suggesting changes. Proposed new behavior:
>
> \dn non_existent_schema
> ===> "No such schema ..."
> (previously: empty list of schemas)
>
> \d non_existent_schema.*
> ===> "No such schema ..."
> (previously: Did not find any relation named "non_existent_schema.*".)
>
> I'm not sure how we should handle "\dn schema_name." (notice the period;
> assuming a schema with that name exists). The current behavior of
> listing all schemas is obviously wrong, but I'm not sure what the right
> behavior is. Perhaps we should reject the command?
>
> I think there needs to be a way to list all the objects in a schema.
> What do people think about making "\dn schema" behave like "\dn+ schema"
> currently does, and changing "\dn+ schema" to list the objects in the
> specified schema, like "\d" currently does for the objects in the search
> path?
>
> (BTW, I think a useful way to assess the usability of psql's schema
> slash commands is trying to use them to explore the information_schema.
> Perhaps I'm missing something, but with the current psql it seems almost
> impossible to do that effectively without adding information_schema to
> the search path.)
>
> -Neil
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-11-28 04:52:56 | Non-C locale and LIKE |
Previous Message | Bruce Momjian | 2004-11-28 03:55:31 | Re: Suggestion: additional system views |