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

Re: Multiple databases

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: Sumaya <sumaya(at)silvermoongroup(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Multiple databases
Date: 2008-04-16 12:01:02
Message-ID: 4805EA7E.4010009@fmed.uba.ar (view raw or flat)
Thread:
Lists: pgsql-sql
Sumaya wrote:

>Hi,
>
>I am converting sql code from sql server to postgresql.  Data is currently being retrieved from multiple databases, how do I do this using postgresql.  I have tried using eg. select * from datbasename.tablename but this does not work.  Any ideas?
>
>Thanks,
>Sumaya
>  
>
Are you saying that you want a particular function stored in say 
database A to be able to retrieve some data from dabatase X?
If that so, you may take a look to the dblink contrib package.

Gerardo

In response to

pgsql-sql by date

Next:From: Bryan EmrysDate: 2008-04-16 13:34:27
Subject: Data Comparison Single Table Question
Previous:From: Florian WeimerDate: 2008-04-16 08:49:59
Subject: Index on elements of an array

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