execute a query in an other db

From: "LR" <lr-NOSPAM-(at)sib(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: execute a query in an other db
Date: 2002-11-09 16:51:40
Message-ID: 3dcd3c60_4@news.bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Zhidian Du 2002-11-10 06:01:41 table protein does not have an attribute oid? why?
Previous Message Bruno Wolff III 2002-11-09 15:52:32 Re: Time difference without intervals