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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
