Re: [SQL] importing in sql

2000-07-12 Thread jmr
karim> The file has the following format karim> karim> field2|field3|field4|field5| karim> karim> Each field is separated by a | (pipe), How do I insert the sequence karim> number before field2? I have like 30 files in this format and I need to karim> import them in one table with each line havi

Re: [SQL] importing in sql

2000-07-12 Thread Ross J. Reedstrom
On Mon, Jul 10, 2000 at 05:03:08PM -0500, Abdul Karim wrote: > Hi, I am trying to import loads of data into postgres, I am having > trouble with a field which is a sequence. I know how to import data > using a delimiter with the copy command. But I need to know how I > increase the sequence on ea