> --would you happen to have any examples
> --of this in perl? i'm trying to find a way
> --of inserting a row into a table without having
> --to parse out the many columns (i'd rather
> --use some array and pop / push with each
> --variable).
I've only recently (January) started working with pgsql. So far most
of these programs have been to extract data from another database,
such as Oracle or MySQL, and insert it into pgsql.
I've generally written a short program to do this, as I have usually
wanted to massage the data somewhat while transferring it.
Also, I'm a 53 year old programming dinosaur more familiar with COBOL
and PL/SQL techniques than with C, so I have never gotten completely
familiar with some advanced programming techniques, so I'm far more
comfortable with providing a list of variable names than with
using -> notation.
It should be possible to write a generalized perl DBI program that can
transfer data from any arbitrarily defined table to another pgsql
instance, perhaps even handle the CREATE TABLE DDL, but I don't know that
I have the patience to write it.
When I had a large table (10 million rows) to transfer from one pgsql
instance to another, I used the dump/restore process.
--
Mike Nolan