0

I have a stored procedure for copying details from csv file to database table. 

CREATE FUNCTION gis_portal.copycsv(IN path text) RETURNS void AS $$
COPY gis_portal.temp_excel FROM path WITH DELIMITER ','
$$ LANGUAGE sql VOLATILE LEAKPROOF;

But it is showing error as:

ERROR: syntax error at or near "path" SQL state: 42601 Character: 101

Here path is dynamic. Please help me.

Improve this question

1 Answer 1

Reset to default
0

COPY statement doesn't support variables - only statements with plan does it. And SQL language doesn't support dynamic SQL - so you should to use plpgsql language

see Dynamically-generated table-name in PostgreSQL COPY command

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments