To: Bill Cunningham <billc@ballydev.com>
Cc: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org
Subject: Re: Schemas: status report, call for developers 
In-reply-to: <3CCED849.5040400@ballydev.com> 
References: <21020.1020187890@sss.pgh.pa.us> <3CCED849.5040400@ballydev.com>
Comments: In-reply-to Bill Cunningham <billc@ballydev.com>
	message dated "Tue, 30 Apr 2002 10:45:45 -0700"
Date: Tue, 30 Apr 2002 14:23:45 -0400
Message-ID: <21260.1020191025@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Bill Cunningham <billc@ballydev.com> writes:
> I would think this should produce the following:

> test=# \d mytab
>         Table "bar.mytab"
>  Column |  Type   | Modifiers
> --------+---------+-----------
>  f1     | text    |
>  f1     | integer |

>         Table "foo.mytab"
>  Column |  Type   | Modifiers
> --------+---------+-----------
>  f2     | text    |
>  f3     | integer |

Even when schemas bar and foo are not in your search path?  (And,
perhaps, not even accessible to you?)

My gut feeling is that "\d mytab" should tell you about the same
table that "select * from mytab" would find.  Anything else is
probably noise to you --- if you wanted to know about foo.mytab,
you could say "\d foo.mytab".

However, \d is not a wildcardable operation AFAIR.  For the commands
that do take wildcard patterns (like \z), I'm not as sure what should
happen.

			regards, tom lane