Syntax Error in COPY when “create function”

From: "hongliu zou" <zouhongliu(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Syntax Error in COPY when “create function”
Date: 2007-02-27 03:04:11
Message-ID: 35201a90702261904o44c18d99oa9fdbeb0dca4c9c0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Am I forgetting some limitation?

I get " ERROR: syntax error at or near "$1"

SQL state: 42601 "with this

CREATE FUNCTION Import1() RETURNS text AS $$

DECLARE

path Char(100);

BEGIN

path = 'C:/zhl/hjs/anc_area.att';

COPY anc_areaAtt FROM path CVS;

RETURN path;

END;

$$ LANGUAGE plpgsql;

SELECT Import1() ;

But COPY can work well when I just put the string in the command:

CREATE FUNCTION Import2() RETURNS text AS $$

DECLARE

path Char(100);

BEGIN

COPY anc_areaAtt FROM 'C:/zhl/hjs/anc_area.att' CSV;

return path;

END;

$$ LANGUAGE plpgsql;

SELECT Import2() ;

Does this mean the "filename" in COPY command can not be a variable?

By the way, my OS is windowXP.

Thanks and Regards,
Hongliu

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-02-27 11:51:27 Position of a field
Previous Message Rommel the iCeMAn 2007-02-26 22:13:54 Re: Change Default Database