| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ODBC: how to change search_path in DSN? |
| Date: | 2007-01-15 03:07:23 |
| Message-ID: | A9335FA4-4A99-40E1-96B9-B4E0B36455DC@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ITAGAKI Takahiro | 2007-01-15 08:36:09 | O_DIRECT support for Windows |
| Previous Message | Tom Lane | 2007-01-14 23:57:46 | Re: xml type and encodings |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CN | 2007-01-15 12:01:56 | Re: BCC55 and libpq 8.2 |
| Previous Message | Jim Nasby | 2007-01-15 03:00:42 | Re: Oracle Streams to pgsql |