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: (view raw or whole thread)
Lists: pgsql-sql
Sumaya wrote:

>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?
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.


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-2015 The PostgreSQL Global Development Group