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.