Re: Unable to execute \copy from Client Application

On Thu, 2012-02-16 at 00:07 -0800, sujayr06 wrote:
> Hello All,
>
>            My application is a C++ APP.
>
>            I'm executing \copy command from the CPP and its as follows
>
>            strPgSqlQuerybuf<<"\\copy hnb_registration FROM
> '/root/Sujay/hnbfile.txt' USING DELIMITERS ','";
>
>            Second \ is to keep the compiler happy. When this command
> executes on PostGreSql,
>            gives a syntax error as
>
>            ERROR:  syntax error at or near "\" at character 1
>            STATEMENT:  \copy hnb_registration FROM '/root/Sujay/hnbfile.txt'
> USING DELIMITERS ','
>
>            Can some please help!
>

\copy is a psql metacommand, not a SQL command. You cannot use it in
your application. You need to use the libpq API.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com