On Thu, Jan 05, 2006 at 11:04:16PM -0600, Angshu Kar wrote: > Thanks Jim. the statement is running without any error but nothing is > getting copied into the table! What client are you using and what's the exact command you ran? Does the command finish or does it never return? How much data is there? What version of PostgreSQL are you using and on what platform? > Also, my data file is showing some ^M chars like > > B1^M C1^M E1 > B2^M C2^M E2 The ^M sequence might represent a carriage return -- how are you viewing the file to see these characters? Are they between fields as shown or only at the ends of lines? > Is it creating any trouble for the COPY command? Possibly; you might need to massage the data if you can't get COPY to read it. That should be an easy job for a script (somebody here can probably help). > And can we use INSERT with COPY? To use INSERT you'd need to read the data and generate the appropriate INSERT commands; that's another scripting job. -- Michael Fuhr
