From: Joe Conway <mail@joeconway.com>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: ERROR: Cross-database references are not implemented
Date: Tue, 10 Aug 2004 20:35:01 -0700
Message-ID: <411993E5.4020509@joeconway.com> (raw)
In-Reply-To: <82E30406384FFB44AFD1012BAB230B55037D04F8@shiva.au.lpint.net>
References: <82E30406384FFB44AFD1012BAB230B55037D04F8@shiva.au.lpint.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, Theo.Galanakis@lonelyplanet.com.au
Subject: Re: ERROR: Cross-database references are not implemented
In-Reply-To: <411993E5.4020509@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox