On Tue, 16 Mar 2004 12:33:57 -0000 (GMT) noor(at)cs(dot)man(dot)ac(dot)uk sat down, thought long and then wrote:
>
> Hi
>
> Does anybody know how to export data from a flatfile (using perl) database
> to postgres?
>
> Thanks
If it is some kind of CSV (text with separators) you could use DBD::CSV for reading and DBD::Pg for
writing. Or you read the file with Perl´s standard functions, treat the data to be
PostgreSQL-insert-query-compatible (regarding apostrophes for example) and then use DBD::Pg (that´s
what I usually do). If you have some kind of DBase files, you can use DBD::XBase.
Regards, Frank.