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

Re: Can I specify a SCHEMA in the ODBC string?

From: Noel <nobody(at)nowhere(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Can I specify a SCHEMA in the ODBC string?
Date: 2005-06-17 19:45:10
Message-ID: av96b1h37cb5a5osaud95amdmoob6bc89t@4ax.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Fri, 17 Jun 2005 13:47:35 +0100, vladimir <bouncer(at)nowhere(dot)org>
wrote:

>> Is this possible? If so, what's the syntax? Is the syntax for ODBC
>> connection strings documented anywhere? I've googled for this info,
>> but unsuccessfully.
>I think that you have to specify the schema in the select query:
>
>SELECT FROM myschema.mytable;

Or you can set the schema search path in Page 2 of the Datasource
Configuration window for the ODBC datasource.  Simply put

SET SEARCH_PATH to myschema, public in the Connect Settings box.



In response to

pgsql-odbc by date

Next:From: Amir ZichermanDate: 2005-06-20 05:39:44
Subject: can't open more than 128 connections
Previous:From: vladimirDate: 2005-06-17 12:47:35
Subject: Re: Can I specify a SCHEMA in the ODBC string?

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