From: Bruno Wolff III <bruno@wolff.to>
To: LR <lr-NOSPAM-@sib.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: execute a query in an other db
Date: Tue, 12 Nov 2002 08:18:43 -0600
Message-ID: <20021112141843.GA27903@wolff.to> (raw)
In-Reply-To: <3dcd3c60_4@news.bluewin.ch>
References: <3dcd3c60_4@news.bluewin.ch>
On Sat, Nov 09, 2002 at 17:51:40 +0100,
LR <lr-NOSPAM-@sib.org> wrote:
> Hi,
>
> When I'm connected to a postgreSQL db ( e.g. myDB ), how could I execute
> "select * from myTable;" in an other db (e.g. myOtherDB).
>
> In other words, what is the postgreSQL equivalent of the MS SQL Server
> statement "USE myOtherDB SELECT * FROM myTable" ?
Stock postgresql doesn't support cross database queries.
There is a contrib package which does.
In the example you gave, you were combining information from two databases.
If it is the case that your application will be combining data from the
two databases, then you can open a separate connection to each database
and use the appropiate connection for your queries.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, lr-NOSPAM-@sib.org
Subject: Re: execute a query in an other db
In-Reply-To: <20021112141843.GA27903@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox