Thread: Can I specify a SCHEMA in the ODBC string?

I'd like to export a table from MS Access to PostgreSQL. By default, it
puts it in the public schema, but I'd like to specify an alternate one.

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.

Any pointers welcome
Thanks
Rachel

Does anyone have a solution to the below archived message?  I'm
running into the same issue.

Thanks in advance

JF


Original Message
----------------------------------------
    * From: Rachel Willmer <rachel_lists ( at ) willmer ( dot ) org>
    * To: pgsql-odbc ( at ) postgresql ( dot ) org
    * Subject: Can I specify a SCHEMA in the ODBC string?
    * Date: Mon, 23 Feb 2004 10:39:39 +0000

I'd like to export a table from MS Access to PostgreSQL. By default,
it puts it in the public schema, but I'd like to specify an alternate
one.
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.

Any pointers welcome
Thanks
Rachel

> Does anyone have a solution to the below archived message?  I'm
> running into the same issue.

set search_path = ...

It's well described in postgresql doc.

Luf

> I'd like to export a table from MS Access to PostgreSQL. By default,
> it puts it in the public schema, but I'd like to specify an alternate
> one.
> 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.

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.

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

Vlad

PS: It should be a pass-through query (set in query options).