Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 27B9D9FB1CF; Mon, 15 Jan 2007 11:14:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 65259-07; Mon, 15 Jan 2007 11:14:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from tomts22-srv.bellnexxia.net (bc.sympatico.ca [209.226.175.184]) by postgresql.org (Postfix) with ESMTP id 353239FB254; Mon, 15 Jan 2007 11:14:25 -0400 (AST) Received: from Mars ([70.52.74.190]) by tomts22-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20070115151423.MBFB8030.tomts22-srv.bellnexxia.net@Mars>; Mon, 15 Jan 2007 10:14:23 -0500 From: "Carlo Stonebanks" To: "'Jim Nasby'" Cc: , "'PGSQL Hackers'" References: Subject: Re: ODBC: how to change search_path in DSN? Date: Mon, 15 Jan 2007 10:14:18 -0500 Message-ID: <011d01c738b7$d4092c10$6f05a8c0@Mars> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acc4YSBnhJ48mJebSkm+OUX2MEEJcgAVoB0w X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/21 X-Sequence-Number: 6399 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)