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

LR wrote: Thank you for your answer. Do you know the name of this package ? Thx Lilian see contrib/dblink. I'd highly recommend using 7.3 (finishing beta, soon to be a release candidate) if you can. It is much better than the one in 7.2 and the syntax has changed some. Joe ---

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

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

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

On Sat, Nov 09, 2002 at 17:51:40 +0100, LR <[EMAIL PROTECTED]> wrote: > 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 > state

[SQL] execute a query in an other db

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