Re: Multiple databases

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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql