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

<p><font size="2">Thanks Joe. After I posted this message, I googled around until I realized when you mentioned
below.</font><p><fontsize="2">Theo</font><p><font size="2">-----Original Message-----</font><br /><font size="2">From:
JoeConway [<a href="mailto:mail@joeconway.com">mailto:mail@joeconway.com</a>] </font><br /><font size="2">Sent:
Wednesday,11 August 2004 1:35 PM</font><br /><font size="2">To: Theo Galanakis</font><br /><font size="2">Cc:
pgsql-sql@postgresql.org</font><br/><font size="2">Subject: Re: [SQL] ERROR: Cross-database references are not
implemented</font><br/><p><font size="2">Theo Galanakis wrote:</font><br /><font size="2">> How do I explicidly
createa cross-database reference?</font><br /><font size="2">> </font><br /><font size="2">> Mind you these
databasesare on the same server.</font><br /><font size="2">> </font><br /><font size="2">> In MSSQL you could do
thatthrough enterprise manager.</font><br /><font size="2">> </font><br /><font size="2">> Any help would be
appreciated.</font><p><fontsize="2">You cannot do cross database references per se, but you can use schemas, </font><br
/><fontsize="2">which roughly behave like individual databases do in MSSQL. See:</font><br /><font size="2">   <a
href="http://www.postgresql.org/docs/7.4/static/ddl-schemas.html"
target="_blank">http://www.postgresql.org/docs/7.4/static/ddl-schemas.html</a></font><p><fontsize="2">If you really
needcross-database queries, see contrib/dblink (which </font><br /><font size="2">would also work across servers), but
itisn't as flexible as using schemas.</font><p><font size="2">HTH,</font><p><font size="2">Joe</font><table><tr><td
bgcolor="#ffffff"><fontcolor="#000000">______________________________________________________________________<br />This
email,including attachments, is intended only for the addressee<br />and may be confidential, privileged and subject to
copyright.If you<br />have received this email in error, please advise the sender and delete<br />it. If you are not
theintended recipient of this email, you must not<br />use, copy or disclose its content to anyone. You must not copy
or<br />communicate to others content that is confidential or subject to <br />copyright, unless you have the consent
ofthe content owner.<br /></font></td></tr></table>