Hi, in a stored procedure, if I do
COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable, i.e.
COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get
ERROR: syntax error at or near "$1"
SQL state: 42601
Context: SQL statement in PL/PgSQL function "parseinsert" near line 15
Thank's
Charles
COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable, i.e.
COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get
ERROR: syntax error at or near "$1"
SQL state: 42601
Context: SQL statement in PL/PgSQL function "parseinsert" near line 15
Thank's
Charles
Get news, entertainment and everything you care about at Live.com. Check it out!