Re: Can I specify a SCHEMA in the ODBC string? - Mailing list pgsql-odbc

On Fri, 17 Jun 2005 13:47:35 +0100, vladimir <bouncer@nowhere.org>
wrote:

>> 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.