On Tue, Oct 13, 2009 at 3:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> [ please keep the list cc'd on replies ]
Sorry, just realized 'reply to list' wasn't used here automatically.
> Hassan Schroeder <hassan.schroeder@gmail.com> writes:
>> So, if you're accessing via code, you have to establish a connection
>> to a specific PG database, and then explicitly set the search_path if
>> that db has more than one schema -- is that right?
>
> In general, yeah. If you like, you can preset the desired search_path
> value as a per-database or per-user setting, and then your code doesn't
> need to think about it. However, if you're accustomed to issuing
> USE explicitly, I don't see why you wouldn't just change that to SET
> search_path.
Well, apples and oranges; I use `USE databasename` to change DBs
frequently in my command-line client, but never in code -- that's just a
connection (pool) request.
Thanks for the extended explanation!
--
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
twitter: @hassan