On Mon, May 23, 2005 at 09:07:08AM -0300, [EMAIL PROTECTED] 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.
pgptQ9WCJqbTi.pgp
Description: PGP signature
