Thread: Accessing tables in other databases, through functions

Probably an optimistic question - can a user with access to two
databases create a function in one to access tables in the other? Or
triggers?

take a look at dblink in contrib module

With Regards
Ashish...
----- Original Message -----
From: "Phoenix Kiula" <phoenix.kiula@gmail.com>
To: "Postgres General" <pgsql-general@postgresql.org>
Sent: Thursday, August 16, 2007 6:18 PM
Subject: [GENERAL] Accessing tables in other databases, through functions


> Probably an optimistic question - can a user with access to two
> databases create a function in one to access tables in the other? Or
> triggers?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

Hello

look on
see http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/
 or http://pgfoundry.org/projects/dblink-tds/

Regards
Pavel Stehule

2007/8/16, Phoenix Kiula <phoenix.kiula@gmail.com>:
> Probably an optimistic question - can a user with access to two
> databases create a function in one to access tables in the other? Or
> triggers?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

On 8/16/07, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:

> Probably an optimistic question - can a user with access to two
> databases create a function in one to access tables in the other? Or
> triggers?

If this is related
 data that you just need logically separated, schemas might work for
you too: http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html