From: Bill Cunningham <billc@ballydev.com>
To: pgsql-hackers <pgsql-hackers@postgreSQL.org>
To: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: Schemas: status report, call for developers
Date: Tue, 30 Apr 2002 13:46:34 -0700
Message-ID: <3CCF02AA.2000209@ballydev.com> (raw)
References: <21020.1020187890@sss.pgh.pa.us>
<3CCED849.5040400@ballydev.com>
<21260.1020191025@sss.pgh.pa.us>
Tom Lane wrote:
>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
>
So we now have a default schema name of the current user? For example:
foobar@somewhere> psql testme
testme=# select * from mytab
Table "foobar.mytab"
Column | Type | Modifiers
--------+---------+-----------
f2 | text |
f3 | integer |
like that? This is exactly how DB2 operates, implict schemas for each user.
- Bill Cunningham
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: billc@ballydev.com, pgsql-hackers@postgreSQL.org
Subject: Re: Schemas: status report, call for developers
In-Reply-To: <3CCF02AA.2000209@ballydev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox