pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: Cross-database references are not implemented
3+ messages / 2 participants
[nested] [flat]
* ERROR: Cross-database references are not implemented
@ 2004-08-11 02:23 Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: Theo Galanakis @ 2004-08-11 02:23 UTC (permalink / raw)
To: pgsql-sql
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.
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ERROR: Cross-database references are not implemented
@ 2004-08-11 03:35 Joe Conway <mail@joeconway.com>
parent: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
0 siblings, 0 replies; 3+ messages in thread
From: Joe Conway @ 2004-08-11 03:35 UTC (permalink / raw)
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ERROR: Cross-database references are not implemented -
@ 2004-08-11 04:04 Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
0 siblings, 0 replies; 3+ messages in thread
From: Theo Galanakis @ 2004-08-11 04:04 UTC (permalink / raw)
To: pgsql-sql
Thanks Joe. After I posted this message, I googled around until I realized
when you mentioned below.
Theo
-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Wednesday, 11 August 2004 1:35 PM
To: Theo Galanakis
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] ERROR: Cross-database references are not implemented
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
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-08-11 04:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-11 02:23 ERROR: Cross-database references are not implemented Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
2004-08-11 03:35 ` Joe Conway <mail@joeconway.com>
2004-08-11 04:04 Re: ERROR: Cross-database references are not implemented - Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
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