[GENERAL] PQputCopyData buffer limit

2012-02-29 Thread sujayr06
Hello All, My CPP Application uses PQputCopyData to push the read buffer from a file into PostGreSql. According to dummy tests conducted, PQputCopyData has been able to upload Approx 9-10MB of data to PostGreSql at one shot. Can someone throw light as to the maxi

Re: [GENERAL] Unable to execute \copy from Client Application

2012-02-16 Thread sujayr06
Hello, Please find the usage of \copy and the corresponding API. strPgSqlQuerybuf<<"\\copy hnb_registration FROM '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; pPostGresQueryResult = PQexecParams(pPgConnection, strPgSqlQuerybuf.str().c_s

Re: [GENERAL] Unable to execute \copy from Client Application

2012-02-16 Thread sujayr06
Hello Guillaume, Please find the usage of \copy and the corresponding API. strPgSqlQuerybuf<<"'\'copy hnb_registration FROM '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; pPostGresQueryResult = PQexecParams(pPgConnection, strPgSqlQuerybu

[GENERAL] Unable to execute \copy from Client Application

2012-02-16 Thread sujayr06
Hello All, My application is a C++ APP. I'm executing \copy command from the CPP and its as follows strPgSqlQuerybuf<<"\\copy hnb_registration FROM '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; Second \ is to keep the compiler happy. When this comm