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 ','"; > > 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.
Once again, you cannot use the \copy metacommand. Use the COPY API from libpq (http://www.postgresql.org/docs/9.1/interactive/libpq-copy.html). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
