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
take a look at dblink in contrib module
With Regards
Ashish...
- Original Message -
From: Phoenix Kiula [EMAIL PROTECTED]
To: Postgres General pgsql-general@postgresql.org
Sent: Thursday, August 16, 2007 6:18 PM
Subject: [GENERAL] Accessing tables in other databases, through functions
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 [EMAIL PROTECTED]:
Probably an optimistic question - can a user with access to two
databases create a function in one
On 8/16/07, Phoenix Kiula [EMAIL PROTECTED] 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: