[SQL] execute a query in an other db

[LR]

Hi,

When I'm connected to a postgreSQL db ( e.g. myDB ), how could I execute
"select * from myTable;" in an other db (e.g. myOtherDB).

In other words, what is the postgreSQL equivalent of the MS SQL Server
statement "USE myOtherDB SELECT * FROM myTable" ?

Thanks
Lilian



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [SQL] execute a query in an other db

[LR]

> > Hi,
> >
> > When I'm connected to a postgreSQL db ( e.g. myDB ), how could I execute
> > "select * from myTable;" in an other db (e.g. myOtherDB).
> >
> > In other words, what is the postgreSQL equivalent of the MS SQL Server
> > statement "USE myOtherDB SELECT * FROM myTable" ?
>
> Stock postgresql doesn't support cross database queries.
> There is a contrib package which does.
>
> In the example you gave, you were combining information from two
databases.
> If it is the case that your application will be combining data from the
> two databases, then you can open a separate connection to each database
> and use the appropiate connection for your queries.

Thank you for your answer.
Do you know the name of this package ?
Thx
Lilian



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])