Re: ERROR: Cross-database references are not implemented -

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C47F58.442BB060
Content-Type: text/plain

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 [at] joeconway.com]
Sent: Wednesday, 11 August 2004 1:35 PM
To: Theo Galanakis
Cc: pgsql-sql [at] 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.
------_=_NextPart_001_01C47F58.442BB060
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [SQL] ERROR: Cross-database references are not implemented - RES=
OLVED</TITLE>
</HEAD>
<BODY>

Thanks Joe. After I posted this message, I googled around=
until I realized when you mentioned below.


Theo


-----Original Message-----
 From: Joe Conway [<A HREF=3D"mailto:mail [at] joeconway.com">=
mailto:mail [at] joeconway.com</A>] 
 Sent: Wednesday, 11 August 2004 1:35 PM
 To: Theo Galanakis
 Cc: pgsql-sql [at] postgresql.org
 Subject: Re: [SQL] ERROR: Cross-database references are =
not implemented

 

Theo Galanakis wrote:
 > How do I explicidly create a cross-database referen=
ce?
 > 
 > Mind you these databases are on the same server.</F=
ONT>
 > 
 > In MSSQL you could do that through enterprise manag=
er.
 > 
 > Any help would be appreciated.


You cannot do cross database references per se, but you c=
an use schemas, 
 which roughly behave like individual databases do in MSS=
QL. See:
 <A HREF=3D"http://www.postgresql.org/docs/7=
..4/static/ddl-schemas.html" TARGET=3D"_blank">http://www.postgresql.org/doc=
s/7.4/static/ddl-schemas.html</A>


If you really need cross-database queries, see contrib/db=
link (which 
 would also work across servers), but it isn't as flexibl=
e as using schemas.


HTH,


Joe


</BODY>
</HTML>
<table><tr><td bgcolor=3D#ffffff>____________________=
__________________________________________________ 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 in=
tended recipient of this email, you must not use, copy or disclose its c=
ontent to anyone. You must not copy or communicate to others content t=
hat is confidential or subject to copyright, unless you have the consen=
t of the content owner. </td></tr></table>
------_=_NextPart_001_01C47F58.442BB060--