Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 00493475AF8 for ; Sat, 9 Nov 2002 11:48:31 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 8F0F4475956 for ; Sat, 9 Nov 2002 11:48:30 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 80B0738137E; Sat, 9 Nov 2002 11:48:31 -0500 (EST) From: "LR" X-Newsgroups: comp.databases.postgresql.sql Subject: execute a query in an other db Date: Sat, 9 Nov 2002 17:51:40 +0100 Lines: 12 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: <3dcd3c60_4@news.bluewin.ch> Organization: Bluewin AG X-Complaints-To: abuse@bluewin.ch To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/177 X-Sequence-Number: 10319 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