[GENERAL] Accessing tables in other databases, through functions

2007-08-16 Thread Phoenix Kiula
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

Re: [GENERAL] Accessing tables in other databases, through functions

2007-08-16 Thread Ashish Karalkar
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

Re: [GENERAL] Accessing tables in other databases, through functions

2007-08-16 Thread Pavel Stehule
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

Re: [GENERAL] Accessing tables in other databases, through functions

2007-08-16 Thread Trevor Talbot
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: