Re: COPY with PostgreSQL

On Fri, 22 Oct 2004 14:34:39 -0400, Robert Fitzpatrick <robert@webtent.com> wrote: > I am using COPY for PostgreSQL and having problems now that the incoming > file contains more than approx 1500 lines. Is this an issue anyone is > aware of? Lot's of files over 1000 lines have worked fine, but after > getting a file over 1800 I began having problems. I have broke the file > down to a approx. 1500 line that works sometimes and not others. Here is > a snippet of what I'm trying to do: > > $result = pg_exec($dbh, "COPY tblxrf FROM stdin USING DELIMITERS > ','"); You might try COPY BINARY here in case you have some stray non-escaped characters. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/