Skip site navigation (1) Skip section navigation (2)

Re: Default schema in DSN

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Kenneth Porter <shiva(at)sewingwitch(dot)com>
Cc: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Default schema in DSN
Date: 2008-03-31 04:10:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Kenneth Porter wrote:
> Is there some way to specify a schema in a DSN so that individual table 
> references in an app don't need to specify it, and so that the app 
> doesn't need to know what DB is on the back end? (The latter constraint 
> means I can't set the schema search path in the app.) I tried using 
> "mydb.public" as the DB name but the Data Source editor doesn't like that.)
> I'm trying to migrate an old Paradox app to a client/server paradigm. I 
> installed psqlodbc_08_03_0100 on XP SP2 and have an 8.1.11 server on 
> Linux. The app uses the Borland Database Engine (BDE) to access the 
> database.
> I don't see a place in the Data Source configuration tool to set the 
> schema or a search path for a DSN.

Please use the Connect Settings option.
You can set the command like 'set search_path to ....' for the option.

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2008-03-31 07:31:29
Subject: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Previous:From: Hiroshi InoueDate: 2008-03-31 03:36:08
Subject: Re: Can't create DSN using SSPI authentication WinXP to WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group