Обсуждение: 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