Stored Procedure: COPY table FROM (where path is a text variable)

Started by Charles Parealmost 19 years ago1 messagesgeneral
Jump to latest
#1Charles Pare
debile_trash@hotmail.com

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: 42601Context: SQL statement in PL/PgSQL function "parseinsert" near line 15Thank'sCharles
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx