[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

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

2012-02-16 Thread Guillaume Lelarge
On Thu, 2012-02-16 at 00:07 -0800, sujayr06 wrote: > 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 ','";

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

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 Guillaume Lelarge
On Thu, 2012-02-16 at 01:05 -0800, sujayr06 wrote: > Hello, > >Please find the usage of \copy and the corresponding API. > >strPgSqlQuerybuf<<"\\copy hnb_registration FROM > '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; > >pPostGresQ

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

2012-02-16 Thread John R Pierce
On 02/16/12 1:05 AM, sujayr06 wrote: Please find the usage of \copy and the corresponding API. strPgSqlQuerybuf<<"\\copy hnb_registration FROM '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; The \ commands are all metacommands for the PSQL utility, none