Issue regarding execution of \COPY command of postgresql using pyodbc

39 views
Skip to first unread message

drea...@gmail.com

unread,
May 16, 2013, 12:41:00 AM5/16/13
to pyo...@googlegroups.com
Getting error when executing the following query using pyodbc:
 
 
Query:-       \COPY Table1(col1char) FROM '/home/sachin/final+joins/input/Table1.txt' DELIMITER AS '|' CSV HEADER
 
Error:-      pyodbc.Error: ('HY000', '[HY000] ERROR:  syntax error at or near "\\" at character 1;\nError while executing the query (7)           (SQLExecDirectW)')
 
Can anybody know these issue
Thank you,
Reply all
Reply to author
Forward
0 new messages