Обсуждение: Using libpq from within postgresql
Hi all,
Sorry if this question is a bit basic. I want to be able to have different PGSql db's talking to each other. So, one DB must act like a client, and be able to connect to another one. Do you guys know if this is done before, and examples of that?
I'm having problems linking the src/interfaces directory with my src/backend directory.
Any help is appreciated!
PGSql User wrote: > Hi all, > > Sorry if this question is a bit basic. I want to be able to have > different PGSql db's talking to each other. So, one DB must act like > a client, and be able to connect to another one. Do you guys know if > this is done before, and examples of that? > I'm having problems linking the src/interfaces directory with my > src/backend directory. > > Any help is appreciated! DB doesn't "act". DB doesn't do anything, DB is a well organized data store. Programs do things, they are the entities that "act". -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com
Ok, thanks.
What I meant was that I want to have one backed connect and execute queries on another backend.
On Tue, Jun 15, 2010 at 6:52 PM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
DB doesn't "act". DB doesn't do anything, DB is a well organized data store. Programs do things, they are the entities that "act".PGSql User wrote:Hi all,
Sorry if this question is a bit basic. I want to be able to have different PGSql db's talking to each other. So, one DB must act like a client, and be able to connect to another one. Do you guys know if this is done before, and examples of that?
I'm having problems linking the src/interfaces directory with my src/backend directory.
Any help is appreciated!
--
Mladen Gogala Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
PGSql User <pgsqluser@gmail.com> writes:
> Sorry if this question is a bit basic. I want to be able to have different
> PGSql db's talking to each other. So, one DB must act like a client, and be
> able to connect to another one. Do you guys know if this is done before,
> and examples of that?
> I'm having problems linking the src/interfaces directory with my src/backend
> directory.
Maybe contrib/dblink does what you want?
regards, tom lane