Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 443179FC338 for ; Fri, 18 May 2007 10:26:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 50804-04 for ; Fri, 18 May 2007 10:26:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56405.mail.re3.yahoo.com (web56405.mail.re3.yahoo.com [216.252.111.84]) by postgresql.org (Postfix) with SMTP id AA0589FC31D for ; Fri, 18 May 2007 10:26:19 -0300 (ADT) Received: (qmail 35660 invoked by uid 60001); 18 May 2007 13:26:17 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=lnv1GOg5AbRJaBzbCRgsA/Xxy2gm8CIBjzTkaI0M8AdrgwnPxblyR/EFLqL5/aQyG7Ptif52PWZOVkSFFZbgl//0SpcRwq2N5vToFjTbiQ4RsiFfBdXmZbjmj9c08HtG2Z36o9xNH6SkRKqRUuye7icOYjeFKH2KNi5MuyirlYM=; X-YMail-OSG: GqN0OSgVM1mNiJaVH0YYpHwBIIf_lqfErp5k7Mk9aLg_ig8jHqgV7W5Ce_c_hJLkHQ-- Received: from [198.119.134.32] by web56405.mail.re3.yahoo.com via HTTP; Fri, 18 May 2007 06:26:17 PDT Date: Fri, 18 May 2007 06:26:17 -0700 (PDT) From: Jessica Richard Subject: cross database references... To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-399639301-1179494777=:35507" Content-Transfer-Encoding: 8bit Message-ID: <920543.35507.qm@web56405.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.078 tagged_above=0 required=5 tests=AWL=-1.034, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: ** X-Archive-Number: 200705/185 X-Sequence-Number: 25505 --0-399639301-1179494777=:35507 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Other than dblink, is there any other way to let me joint select two tables in two different databases? Thanks, Jessica --------------------------------- Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. --0-399639301-1179494777=:35507 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Other than dblink, is there any other way to let me joint select two tables in two different databases?

Thanks,
Jessica


Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center. --0-399639301-1179494777=:35507--