Skip site navigation (1) Skip section navigation (2)

Re: Schemas: status report, call for developers

From: Bill Cunningham <billc(at)ballydev(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>,pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: Schemas: status report, call for developers
Date: 2002-04-30 20:46:34
Message-ID: 3CCF02AA.2000209@ballydev.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Tom Lane wrote:

>Bill Cunningham <billc(at)ballydev(dot)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(at)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



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-04-30 21:16:33
Subject: Re: Schemas: status report, call for developers
Previous:From: Andrew SullivanDate: 2002-04-30 20:34:24
Subject: Re: [HACKERS] Re : Solaris Performance - 64 bit puzzle

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-04-30 21:16:33
Subject: Re: Schemas: status report, call for developers
Previous:From: Dave PageDate: 2002-04-30 18:54:07
Subject: Re: [INTERFACES] Schemas: status report, call for developers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group