take a look at dblink in contrib module
With Regards
Ashish...
----- Original Message -----
From: "Phoenix Kiula" <phoenix.kiula@xxxxxxxxx>
To: "Postgres General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, August 16, 2007 6:18 PM
Subject: 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend