Please set in odbc.ini.
ConnSettings = set search_path = Others,public;
Regards,
Hiroshi Saito
----- Original Message -----
From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, November 05, 2008 11:24 PM
Subject: [ODBC] Setting search_path in ODBC connection string
> How to set default search_path in connection string ?
>
> I have tables in non-public schema and need to set this to allow ODBC
> application to find tables without using schema prefix.
>
> Andrus.
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc