X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id D67DECCA20 for ; Thu, 17 Jul 2003 14:07:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 05787-08 for ; Thu, 17 Jul 2003 14:07:29 +0000 (GMT) Received: from mail1.dr.myx.net (mail1.dr.myx.net [217.10.193.161]) by svr1.postgresql.org (Postfix) with ESMTP id 4EC26CC8D8 for ; Thu, 17 Jul 2003 11:07:03 -0300 (ADT) Received: from workstation24 (unknown [81.12.137.146]) by mail1.dr.myx.net (mydomain.myx.net) with ESMTP id CCB93300682; Thu, 17 Jul 2003 17:07:05 +0300 (EEST) Message-ID: <01c201c34c6c$a76726c0$0600a8c0@fix.ro> From: "Viorel Dragomir" To: "BenLaKnet" , References: <3F16ACBB.3080502@icqmail.com> Subject: Re: Is it possible to connect to another database Date: Thu, 17 Jul 2003 17:06:43 +0300 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.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/217 X-Sequence-Number: 14331 $db_conn1 = pg_connect("dbname=db1"); $db_conn2 = pg_connect("dbname=db2"); ..... You can't join two tables from different databases(, as far as i know :). ----- Original Message ----- From: "BenLaKnet" To: Sent: Thursday, July 17, 2003 5:03 PM Subject: [SQL] Is it possible to connect to another database > Hi, > > I try to find how is it possible to connect 2 databases, with a symbolic > link. > > I have to use tables in another database to test user or other information. > > > Ben > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html