Re: COPY with PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 22 Oct 2004 14:34:39 -0400, Robert Fitzpatrick
<robert@xxxxxxxxxxx> 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/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux