From: Carlo Stonebanks <stonec.register@sympatico.ca>
To: pgsql-interfaces@postgresql.org
Subject: ODBC: how to change search_path in DSN?
Date: Tue, 19 Dec 2006 13:06:48 -0500
Message-ID: <em99mi$1buj$1@news.hub.org> (raw)
I would like to create an ODBC DSN for a user to export files rom Acccess to
a safe area. Right now, all tables are being dumped to public by default.
In order to use the one-click export option for Access, I would like to have
the connection for the ODBC DSN file change the default search_path to
my_schema (and my_schema only).
After seeing a post on this on another resource, I tried putting
schema=my_schema in the connection settings text box, but the tables
appeared in public anyway.
Thanks!
Carlo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: stonec.register@sympatico.ca
Subject: Re: ODBC: how to change search_path in DSN?
In-Reply-To: <em99mi$1buj$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox