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 C1025CC9FA for ; Thu, 17 Jul 2003 14:06:48 +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 31799-01 for ; Thu, 17 Jul 2003 14:07:03 +0000 (GMT) Received: from mailhub1.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2]) by svr1.postgresql.org (Postfix) with ESMTP id 04D3BCC8D7 for ; Thu, 17 Jul 2003 11:06:37 -0300 (ADT) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.12) id 19d9Pb-00026g-00; Thu, 17 Jul 2003 15:07:11 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.1 HotFix 0.7 (built May 7 2002)) with ESMTPA id <0HI600BKN9VH6M@imail.sghms.ac.uk>; Thu, 17 Jul 2003 15:06:53 +0100 (BST) Date: Thu, 17 Jul 2003 15:05:22 +0100 From: Adam Witney Subject: Re: Is it possible to connect to another database In-reply-to: <3F16ACBB.3080502@icqmail.com> To: BenLaKnet , pgsql-sql Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT User-Agent: Microsoft-Entourage/10.1.1.2418 X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH1: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-100.8, required 5, IN_REP_TO, QUOTED_EMAIL_TEXT, USER_AGENT_ENTOURAGE, USER_IN_WHITELIST) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/216 X-Sequence-Number: 14330 Take a look at dblink in the contrib directory... This may do what you need adam > 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.