Osvaldo Rosario Kussama <[EMAIL PROTECTED]> writes:
>> |Does this mean the "filename" in COPY command can not be a variable?|
Got it in one.
You can use EXECUTE to put together commands that require a variable
in places where PG doesn't allow one.
regards, tom lane
-
hongliu zou escreveu:
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 FRO
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;
