| Lists: | pgsql-odbc |
|---|
| From: | Jon Farb <sawzall710(at)gmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Can I specify a SCHEMA in the ODBC string? |
| Date: | 2005-06-13 18:53:33 |
| Message-ID: | d1ac72b705061311531949df20@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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
| From: | Ludek Finstrle <ludek(dot)finstrle(at)pzkagis(dot)cz> |
|---|---|
| To: | Jon Farb <sawzall710(at)gmail(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Can I specify a SCHEMA in the ODBC string? |
| Date: | 2005-06-16 09:28:49 |
| Message-ID: | 20050616092849.GA3957@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
> 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.
| From: | vladimir <bouncer(at)nowhere(dot)org> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Can I specify a SCHEMA in the ODBC string? |
| Date: | 2005-06-17 12:47:35 |
| Message-ID: | d8ugku$al8$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
> 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).
| From: | Noel <nobody(at)nowhere(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Can I specify a SCHEMA in the ODBC string? |
| Date: | 2005-06-17 19:45:10 |
| Message-ID: | av96b1h37cb5a5osaud95amdmoob6bc89t@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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.