Re: [GENERAL] bulk insert using COPY and PHP code

2010-07-02 Thread Scott Marlowe
On Fri, Jul 2, 2010 at 1:28 PM, Babu R wrote: > > Hi Pavel, > > Thanks. > > The situation is, I have the DB class which will return the connection object > that is created using the PDO class. And am using that object to perform the > db operations. ie: $DB->prepare("") > > Further I have the da

Re: [GENERAL] bulk insert using COPY and PHP code

2010-07-02 Thread Pavel Stehule
use just copy ... pavel > > And this dosen't work, it throws an error "error near "\" char 1 along with > the command > > But the same command works fine on the psql prompt. > > Thanks again, > - Babu > > --- On Fri, 7/2/10, Pavel Stehule

Re: [GENERAL] bulk insert using COPY and PHP code

2010-07-02 Thread Babu R
the psql prompt. Thanks again, - Babu --- On Fri, 7/2/10, Pavel Stehule wrote: From: Pavel Stehule Subject: Re: [GENERAL] bulk insert using COPY and PHP code To: "Babu R" Cc: pgsql-general@postgresql.org Date: Friday, July 2, 2010, 4:22 PM 2010/7/2 Babu R > > Hello, > >

Re: [GENERAL] bulk insert using COPY and PHP code

2010-07-02 Thread Pavel Stehule
2010/7/2 Babu R > > Hello, > > Am exploring a way for bulk insert using \COPY with the CSV format data using > PHP code. Is there any way to achieve this? > > Thanks, > - Babu > hello look on http://php.net/manual/en/function.pg-put-line.php Regards Pavel Stehule -- Sent via pgsql-general

[GENERAL] bulk insert using COPY and PHP code

2010-07-02 Thread Babu R
Hello, Am exploring a way for bulk insert using \COPY with the CSV format data using PHP code. Is there any way to achieve this? Thanks, - Babu