Re: [GENERAL] text file import

2005-10-06 Thread Guy Fraser
On Thu, 2005-06-10 at 16:14 +0100, Richard Huxton wrote: > Bart van den Eijnden wrote: > > Hi list, > > > > I am trying to transfer the following from MySQL to PostgreSQL: > > > > load data local > > infile 'D:/tmp/InterAcces- MySQL/03102005/bedrijven.txt' > > into table bedrijven > > fields ter

Re: [GENERAL] text file import

2005-10-06 Thread Richard Huxton
Bart van den Eijnden wrote: Hi list, I am trying to transfer the following from MySQL to PostgreSQL: load data local infile 'D:/tmp/InterAcces- MySQL/03102005/bedrijven.txt' into table bedrijven fields terminated by ',' optionally enclosed by '^' lines terminated by ';\r\n'; Is there a way

[GENERAL] text file import

2005-10-06 Thread Bart van den Eijnden
Hi list, I am trying to transfer the following from MySQL to PostgreSQL: load data local infile 'D:/tmp/InterAcces- MySQL/03102005/bedrijven.txt' into table bedrijven fields terminated by ',' optionally enclosed by '^' lines terminated by ';\r\n'; Is there a way to do this without changing the