>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 Emrys||Date: 2008-04-16 13:34:27|
|Subject: Data Comparison Single Table Question|
|Previous:||From: Florian Weimer||Date: 2008-04-16 08:49:59|
|Subject: Index on elements of an array|