X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 569DBD1BB89 for ; Thu, 22 Apr 2004 04:04:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12191-10 for ; Thu, 22 Apr 2004 04:04:06 -0300 (ADT) Received: from mail.netspace.net.au (cumulus.netspace.net.au [203.10.110.72]) by svr1.postgresql.org (Postfix) with ESMTP id 4F676D1B560 for ; Thu, 22 Apr 2004 04:04:04 -0300 (ADT) Received: from baeckea (dsl-210-15-236-166.VIC.netspace.net.au [210.15.236.166]) by mail.netspace.net.au (Postfix) with SMTP id E7ABB6A089 for ; Thu, 22 Apr 2004 17:04:01 +1000 (EST) Message-ID: <007601c42837$8d675bd0$140010ac@baeckea> From: "Becky Alcorn" To: Subject: Select from two databases Date: Thu, 22 Apr 2004 17:00:52 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/220 X-Sequence-Number: 17595 Hi, I was wondering if there has been any further development on running SQL statements involving more than one database? We are porting a database from SQLServer to Postgres and some queries in related applications use joins on tables that are in different databases. We know we can modify the code to use dblink to accomplish much the same thing in Postgres. Does anyone know of a more elegant solution for Postgres than dblink? Regards Becky Becky Alcorn Unisolve Pty Ltd - Melbourne, Australia +61 3 9568 2005 This line intentionally left blank.