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

Default schema in DSN

From: Kenneth Porter <shiva(at)sewingwitch(dot)com>
To: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Default schema in DSN
Date: 2008-03-26 02:07:23
Message-ID: EB58939BEA68519D522E432B@[10.169.6.155] (view raw or whole thread)
Thread:
Lists: pgsql-odbc
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.

Responses

pgsql-odbc by date

Next:From: Peter EisentrautDate: 2008-03-26 08:15:23
Subject: Re: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Previous:From: Richard BroersmaDate: 2008-03-25 19:56:03
Subject: Re: Access complains : Update or CancelUpdate without AddNew or Edit

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