Re: table synonyms - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: table synonyms
Date
Msg-id 20050523155217.GC12731@svana.org
Whole thread Raw
In response to Re: table synonyms  (<jjeffman@cpovo.net>)
List pgsql-general
On Mon, May 23, 2005 at 09:07:08AM -0300, jjeffman@cpovo.net wrote:
> Thank you very much for your answer.
>
> What happens if there are more than one table with the same name in the
> "search_path" ?

It takes the first one.

There is no explicit relationship between users and schemas, however
many installations have the search_path default to "$user, public"
which is magically substituted on connection. You are ofcourse free to
alter search_path whenever you want. Any table can always be referred
to by its full name...

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: C++-Language Function/Process List
Next
From: Tom Lane
Date:
Subject: Re: Exception Handling in C-Language Functions?