Re: query multiple databases - Mailing list pgsql-general

From Arne Weiner
Subject Re: query multiple databases
Date
Msg-id 3BB72A49.D69DEE70@gmx.de
Whole thread Raw
List pgsql-general
Adam Fisher wrote:
>
> Hi All,
> I am just starting out with postgreSQL. I have retail inventory system
> written in MS-SQL, but now I want to use Linux and, hence, postgreSQL.
>
> My existing app uses lots of SQL that query 2 or more seperate databases. I
> have just read that this can;t be done in postgreSQL. Is this true?

Yes.

> If so, are there any obvious work-arounds? Or must I simply combine all my
> databases into one? I really don't want to do that!

I don't know.

> If this limitation exists, can anybody recomend another database that
> doesn't cost a fortune but has similar strength-of-features to
> MS-SQL/postgreSQL?
>

Arne.

pgsql-general by date:

Previous
From: "Michael R. Fahey"
Date:
Subject: Can't add PL/PGSQL function even after running createlang.
Next
From: Tom Lane
Date:
Subject: Re: Can't add PL/PGSQL function even after running createlang.