Thread: Re: query multiple databases

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.

> 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?

Are you sure you are not confusing databases and tables?  They are not the
same thing although M$ does try and corrupt the meaning of common terms.  I
routinely pull data from multiple tables in the SAME database and can see no
reason why a well designed/normalized system requires more than one
database.  I use different databases for different customers but each
database contains many tables/indexes/sequences etc.

len morgan