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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
