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

Switching Between Databases

From: "Michael Peters" <mike101a(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Switching Between Databases
Date: 2007-07-21 06:25:42
Message-ID: BAY115-F19E8733E464AFCA9E81C1A94F50@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
I was not entirely sure how to frame my search of ODBC mailing database on 
this topic so my apologies if it has been previously discussed at length.

When using the MySQL ODBC driver it is possible to frame an SQL query to 
select a chosen database on the fly.within a single DSN Connection Instance

For example

    Select * from weather.cities

Would select everything from the Cities Table within the Weather DB.


   Use Weather
   Select * from cities

Would do the same thing but require two SQL statements similar to psql which 
would be

   \c weather
   Select * from cities


Is it possible when using the PostgreSQL ODBC driver to switch back and 
forth between different Databases within a single connection instance?


Advertisement: Make shopping exciting. Find what you want at


pgsql-odbc by date

Next:From: Tom LaneDate: 2007-07-21 16:15:21
Subject: Re: Switching Between Databases
Previous:From: Garo HussenjianDate: 2007-07-20 22:16:01
Subject: Re: Dynaset support

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