pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC: how to change search_path in DSN?
3+ messages / 2 participants
[nested] [flat]
* ODBC: how to change search_path in DSN?
@ 2006-12-19 18:06 Carlo Stonebanks <stonec.register@sympatico.ca>
0 siblings, 1 reply; 3+ messages in thread
From: Carlo Stonebanks @ 2006-12-19 18:06 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ODBC: how to change search_path in DSN?
@ 2007-01-15 03:07 Jim Nasby <decibel@decibel.org>
parent: Carlo Stonebanks <stonec.register@sympatico.ca>
0 siblings, 1 reply; 3+ messages in thread
From: Jim Nasby @ 2007-01-15 03:07 UTC (permalink / raw)
To: Carlo Stonebanks <stonec.register@sympatico.ca>; +Cc: pgsql-interfaces@postgresql.org, PGSQL Hackers <pgsql-hackers@postgresql.org>
On Dec 19, 2006, at 12:06 PM, Carlo Stonebanks wrote:
> 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.
I think your only option is to change the default for the user. IT
would be handy if there was a way to set search_path via
pg_service.conf, though...
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ODBC: how to change search_path in DSN?
@ 2007-01-15 15:14 Carlo Stonebanks <stonec.register@sympatico.ca>
parent: Jim Nasby <decibel@decibel.org>
0 siblings, 0 replies; 3+ messages in thread
From: Carlo Stonebanks @ 2007-01-15 15:14 UTC (permalink / raw)
To: 'Jim Nasby' <decibel@decibel.org>; +Cc: pgsql-interfaces; 'PGSQL Hackers' <pgsql-hackers@postgresql.org>
Hi Jim,
The solution was to put " set search_path=new_path" in Connection Settings
in the ODBC configuration (on Page 2 of the dialog).
Carlo
-----Original Message-----
From: Jim Nasby [mailto:decibel@decibel.org]
Sent: January 14, 2007 10:07 PM
To: Carlo Stonebanks
Cc: pgsql-interfaces@postgresql.org; PGSQL Hackers
Subject: Re: [INTERFACES] ODBC: how to change search_path in DSN?
On Dec 19, 2006, at 12:06 PM, Carlo Stonebanks wrote:
> 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.
I think your only option is to change the default for the user. IT
would be handy if there was a way to set search_path via
pg_service.conf, though...
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-01-15 15:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-19 18:06 ODBC: how to change search_path in DSN? Carlo Stonebanks <stonec.register@sympatico.ca>
2007-01-15 03:07 ` Jim Nasby <decibel@decibel.org>
2007-01-15 15:14 ` Carlo Stonebanks <stonec.register@sympatico.ca>
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