Re: Unable to execute \copy from Client Application

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,
strPgSqlQuerybuf.str().c_str(),
0, // one param
NULL, // let the
backend deduce param type
NULL,
NULL, // don't need
param lengths since text
NULL, // default to
all text params
0);
ePostGresCmdExecStatus =
PQresultStatus(pPostGresQueryResult) ;

Let me know if the usage has to be corrected.
Regards,
Sujay

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Unable-to-execute-copy-from-Client-Application-tp5488816p5488935.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.