Postgres Pro
Downloads
Home   >   mailing lists

execute a query in an other db - Mailing list pgsql-sql

From LR
Subject execute a query in an other db
Date
Msg-id 3dcd3c60_4@news.bluewin.ch
Whole thread Raw
Responses Re: execute a query in an other db  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Emmanuel Engelhart
Date:
Subject: CREATE VIEW (dynamically)
Next
From: karthickv@hclp.com (karthick v)
Date:
Subject: Output of function into a file