| From: | "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | ODBC: how to change search_path in DSN? |
| Date: | 2006-12-19 18:06:48 |
| Message-ID: | em99miem99mi$1buj$1@news.hub.orgbujem99mi$1buj$1@news.hub.org@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-12-19 18:37:21 | Re: Sync Scan update |
| Previous Message | Gregory Stark | 2006-12-19 18:05:43 | Re: Sync Scan update |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murray Cumming | 2006-12-20 08:47:57 | Re: Embedding postgresql in my application |
| Previous Message | Alvaro Herrera | 2006-12-19 15:46:54 | Re: Embedding postgresql in my application |