On Fri, 17 Jun 2005 13:47:35 +0100, vladimir <bouncer(at)nowhere(dot)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.