Re: [GENERAL] Opening two databases at the same time?

On Tue, 13 Apr 1999, Oleg Broytmann wrote:

> On Tue, 13 Apr 1999, De Leersnijder Frederic wrote:

> > Is there a way, or is it possible to open two databases at the same time
> > to retrieve information from one database and store it in the other?
>
>    I did it one of my programs - I open a database that stores WWW log,
> process some data, open another DB, put some data in, and close both DBs.
>    I am using Python as the programming language, and PyGres
> (Postgres=>Python driver) uses libpq, so any libpq-based program will do.
>
> Oleg.

Oleg - I have done it in perl (using DBI:DBD) without much effort.
If you don't localize variables (using my or local) it is particularly
painless.

Frederic - if you want I'd be pleased to send some syntax...tot straks!

Tom
----
         North Richmond Community Mental Health Center

         Thomas Good   Information Systems Coordinator
         E-Mail:       tomg@ { admin | q8 } .nrnet.org
         Phone:        718-354-5528
         Fax:          718-354-5056

                 Empowered by PostgreSQL 6.3.2