Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2864C9FBF32 for ; Fri, 18 May 2007 14:28:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07960-01 for ; Fri, 18 May 2007 14:28:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web56405.mail.re3.yahoo.com (web56405.mail.re3.yahoo.com [216.252.111.84]) by postgresql.org (Postfix) with SMTP id 5DBB79FBC79 for ; Fri, 18 May 2007 14:28:30 -0300 (ADT) Received: (qmail 26177 invoked by uid 60001); 18 May 2007 17:28:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=mPfIRpfm64R9HDSM29ffLt0VOV5Qxa4uJEZjbzGn65MPpiK4tlofUSv04X3s0SRBU5hC38Qq9BPwEPMdfsd2acgYpFywYbQt5LJ+TJDUfeQcT5MpWsfqYk+QykmEZ3ogsh7apWbxY8jJeSI3FZ6xlOYDda/LmPCsC9+KcDucAzs=; X-YMail-OSG: FKHwnmIVM1l2EeGDnBG_Y.Oy4MEzl2yN0NOfPKAsc8oLLX8GwcPuWnYZMlgnKMTV9b5wZaiHPoJmGem_SeUfuczlj0lGenET1np3 Received: from [198.119.134.32] by web56405.mail.re3.yahoo.com via HTTP; Fri, 18 May 2007 10:28:29 PDT Date: Fri, 18 May 2007 10:28:29 -0700 (PDT) From: Jessica Richard Subject: Re: cross database references... To: Scott Marlowe Cc: pgsql-admin@postgresql.org In-Reply-To: <464DCD4B.6030904@g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1150601320-1179509309=:25851" Content-Transfer-Encoding: 8bit Message-ID: <510196.25851.qm@web56405.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.346 tagged_above=0 required=5 tests=AWL=0.215, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200705/199 X-Sequence-Number: 25519 --0-1150601320-1179509309=:25851 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit scheams work fine in ONE db, I need to have two databass and they need to able to talk to eacher, dblink funciton is working fine for me now, I am just wondering if there is any other better way than dblink... Thanks, Jessica Scott Marlowe wrote: Jessica Richard wrote: > Other than dblink, is there any other way to let me joint select two > tables in two different databases? Would schemas work for you? You can have multiple schemas in one database (like oracle) so that you references tables as schemaname.tablename etc... Works well for most places you need to do this. --------------------------------- Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. --0-1150601320-1179509309=:25851 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit scheams work fine in ONE db, I need to have two databass and they need to able to talk to eacher, dblink funciton is working fine for me now, I am just wondering if there is any other better way than dblink...

Thanks,
Jessica

Scott Marlowe <smarlowe@g2switchworks.com> wrote:
Jessica Richard wrote:
> Other than dblink, is there any other way to let me joint select two
> tables in two different databases?

Would schemas work for you? You can have multiple schemas in one
database (like oracle) so that you references tables as
schemaname.tablename etc... Works well for most places you need to do this.


Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games. --0-1150601320-1179509309=:25851--