On Tue, 16 Mar 2004 12:33:57 -0000 (GMT) [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
