How can I set the cross database reference?

Discussion:

(too old to reply)

Olivier Hubaut

2003-12-08 09:33:49 UTC

Hi,

I need to use the cross database reference form some select closes. I've
install PG 7.3.4 using the 'make all' option, but it seems that the
functionnality isn't set anyway.

Is there another package I need to install or some commands I need to do?

Thanks,

--
Ci-git une signature avortee.
** RIP **

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Gaetano Mendola

2003-12-09 00:58:01 UTC

Permalink

Post by Olivier Hubaut
Hi,
I need to use the cross database reference form some select closes. I've
install PG 7.3.4 using the 'make all' option, but it seems that the
functionnality isn't set anyway.
Is there another package I need to install or some commands I need to do?

You can do db cross select using dblink but I don't think that you
can enforce cross database reference. You can anyway use schemas.

Regards
Gaetano Mendola

Gaetano Mendola

2003-12-09 00:59:17 UTC

Permalink

Olivier Hubaut wrote:
| Hi,
|
| I need to use the cross database reference form some select closes. I've
| install PG 7.3.4 using the 'make all' option, but it seems that the
| functionnality isn't set anyway.
|
| Is there another package I need to install or some commands I need to do?

You can do db cross select using dblink but I don't think that you
can enforce cross database reference. You can anyway use schemas.

Regards
Gaetano Mendola