X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 481A314B2824 for ; Wed, 11 Aug 2004 00:35:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96548-04 for ; Wed, 11 Aug 2004 03:35:27 +0000 (GMT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id EA33E14B2800 for ; Wed, 11 Aug 2004 00:35:11 -0300 (ADT) Received: from [192.168.4.3] (account jconway [192.168.4.3] verified) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 2103305; Tue, 10 Aug 2004 20:27:38 -0700 Message-ID: <411993E5.4020509@joeconway.com> Date: Tue, 10 Aug 2004 20:35:01 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Theo Galanakis Cc: pgsql-sql@postgresql.org Subject: Re: ERROR: Cross-database references are not implemented References: <82E30406384FFB44AFD1012BAB230B55037D04F8@shiva.au.lpint.net> In-Reply-To: <82E30406384FFB44AFD1012BAB230B55037D04F8@shiva.au.lpint.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/76 X-Sequence-Number: 18573 Theo Galanakis wrote: > How do I explicidly create a cross-database reference? > > Mind you these databases are on the same server. > > In MSSQL you could do that through enterprise manager. > > Any help would be appreciated. You cannot do cross database references per se, but you can use schemas, which roughly behave like individual databases do in MSSQL. See: http://www.postgresql.org/docs/7.4/static/ddl-schemas.html If you really need cross-database queries, see contrib/dblink (which would also work across servers), but it isn't as flexible as using schemas. HTH, Joe