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

From sujayr06
Subject Re: Unable to execute \copy from Client Application
Date
Msg-id 1329382979228-5488935.post@n5.nabble.com
Whole thread Raw
In response to Re: Unable to execute \copy from Client Application  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Drop big index
Next
From: sujayr06
Date:
Subject: Re: Unable to execute \copy from Client Application