Re: how to intract between databases please let me know

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: sateesh kumar <pandusateesh(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to intract between databases please let me know
Date: 2009-10-27 13:20:43
Message-ID: 1256649643.9107.1.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David F. Skoll 2009-10-27 18:33:23 Re: Warm standby problems: Followup
Previous Message sateesh kumar 2009-10-27 11:34:24 how to intract between databases please let me know