Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 0B29F475FAB for ; Tue, 2 Jul 2002 17:18:46 -0400 (EDT) Mailbox-Line: From lmpimentel@yahoo.com Tue Jul 2 17:18:46 2002 Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 36048475484 for ; Tue, 2 Jul 2002 17:18:45 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 91967381D36; Tue, 2 Jul 2002 17:17:48 -0400 (EDT) From: "Ligia Pimentel" X-Newsgroups: comp.databases.postgresql.sql Subject: Selecting data from a table created in another database... Date: Tue, 2 Jul 2002 15:13:59 -0500 Organization: . Lines: 19 Message-ID: Reply-To: "Ligia Pimentel" X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=1.5 required=5.0 tests=FORGED_YAHOO_RCVD version=2.30 X-Spam-Level: * X-Archive-Number: 200207/29 X-Sequence-Number: 8408 I don't know if this can be done... In MSSQL Server I can access a table created in another database (on the same server, of course) by using the following syntaxis... select * from databasename..tablename where condition; Can I do this in postgres? I'm using version 7.2 on a redhat server... Thank you for your help... Ligia