Re: [SQL] copy from csv, variable filename within a function

2013-04-18 Thread bricklen
Note: "DELEMITER" should be "DELIMITER". On Thu, Apr 18, 2013 at 1:34 AM, basti wrote: > I have fixed it with dollar-quoting. > > Original-Nachricht ---- Betreff: [SQL] copy from csv, > variable filename within a function Datum: Thu, 18 Apr 2

Fwd: [SQL] copy from csv, variable filename within a function

2013-04-18 Thread basti
I have fixed it with dollar-quoting. Original-Nachricht Betreff:[SQL] copy from csv, variable filename within a function Datum: Thu, 18 Apr 2013 09:26:09 +0200 Von:basti An: pgsql-sql@postgresql.org Hello, i have try the following: -- Function

[SQL] copy from csv, variable filename within a function

2013-04-18 Thread basti
Hello, i have try the following: -- Function: wetter.copy_ignore_duplicate(character varying) -- DROP FUNCTION wetter.copy_ignore_duplicate(character varying); CREATE OR REPLACE FUNCTION wetter.copy_ignore_duplicate(_filename character varying) RETURNS void AS $BODY$ declare sql text; BEGI