Thread: Connecting to a specific Schema via ODBC.

Connecting to a specific Schema via ODBC.

From

Michael Weaver

Date:

18 February 2003, 04:41:10

I've got to insert data into a specific schema via windows based ODBC.
The program that will be inserting the data does not know about schemas, so I need to get the ODBC connection to point directly to the desired schema.

Is this possible?

TIA
Mike Weaver
Software Developer

5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832

P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0403 385 181
W: http://www.corpusglobe.com/
E: mweaver@corpusglobe.com

This email is intended only for the use of the individual or entity named above and may contain information that is confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. When addressed to our clients, any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing Corpus Globe client engagement letter. If you have received this Email in error, please notify us immediately by return email or telephone +61 8 9331 2700 and destroy the original message. Thank You.

Re: Connecting to a specific Schema via ODBC.

From

"Dave Page"

Date:

18 February 2003, 06:44:28

-----Original Message-----
From: Michael Weaver [mailto:mweaver@corpusglobe.com]
Sent: 18 February 2003 06:56
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Connecting to a specific Schema via ODBC.

I've got to insert data into a specific schema via windows based ODBC.
The program that will be inserting the data does not know about schemas, so I need to get the ODBC connection to point directly to the desired schema.
Is this possible?

Hi Mike,

In the Connect Settings textbox on the Advanced Setup dialogue for the datasource, add a statement such as:

SET search_path = my_schema, pg_catalog;

Regards, Dave.