Re: Unable to execute \copy from Client Application

Поиск
Список
Период
Сортировка
От sujayr06
Тема Re: Unable to execute \copy from Client Application
Дата
Msg-id 1329382979228-5488935.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Unable to execute \copy from Client Application  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Drop big index
Следующее
От: sujayr06
Дата:
Сообщение: Re: Unable to execute \copy from Client Application