Re: Unable to execute \copy from Client Application - Mailing list pgsql-general

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_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-tp5488816p5488941.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.