please let me know procedure of intracting b/w two databases with in cluster even though i give grant permission on schema to other database it is not working.
On Tue, 2009-10-27 at 17:04 +0530, sateesh kumar wrote:
> Hello sir/madam
>
>
> please let me know procedure of intracting b/w two databases with in
> cluster even though i give grant permission on schema to other
> database it is not working.
>
You can't do it directly. Have a look at dblink
http://www.postgresql.org/docs/current/static/dblink.html
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.