Sumaya wrote:
>Hi,
>
>I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases,
howdo I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work.
Anyideas?
>
>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