Re: DBI connection to multiple database

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: DBI connection to multiple database
Date: 2003-05-21 15:46:46
Message-ID: 20030521174646.K562@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there a way to connect to one database, extract data,
> (say, some select query) and then export that data
> into another database without having to table the
> data into a file of some sort?
You might want to start learning about the concept of data
types and variables in programming languages (this includes
shells). Also, reading up on how to pipe things from stdout
of one program to stdin of another might help.

If you want to make one database pipe stuff into another
database directly you'd need to learn about the various
approaches summed up under "dblink". One implementation is
found in contrib/. Search the list archive for more on this.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2003-05-21 15:53:57 Re: TIMESTAMP SUBTRACTION
Previous Message greg 2003-05-21 15:37:59 Re: TIMESTAMP SUBTRACTION (retry, list is bouncing emails)