Re: how to intract between databases please let me know - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: how to intract between databases please let me know
Date
Msg-id 1256649643.9107.1.camel@bnicholson-desktop
Whole thread Raw
In response to how to intract between databases please let me know  (sateesh kumar <pandusateesh@gmail.com>)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: sateesh kumar
Date:
Subject: how to intract between databases please let me know
Next
From: "David F. Skoll"
Date:
Subject: Re: Warm standby problems: Followup