On Fri, 17 Jun 2005 13:47:35 +0100, vladimir <bouncer(at)nowhere(dot)org>
>> Is this possible? If so, what's the syntax? Is the syntax for ODBC
>> connection strings documented anywhere? I've googled for this info,
>> but unsuccessfully.
>I think that you have to specify the schema in the select query:
>SELECT FROM myschema.mytable;
Or you can set the schema search path in Page 2 of the Datasource
Configuration window for the ODBC datasource. Simply put
SET SEARCH_PATH to myschema, public in the Connect Settings box.
In response to
pgsql-odbc by date
|Next:||From: Amir Zicherman||Date: 2005-06-20 05:39:44|
|Subject: can't open more than 128 connections|
|Previous:||From: vladimir||Date: 2005-06-17 12:47:35|
|Subject: Re: Can I specify a SCHEMA in the ODBC string?|