Function with COPY command? - Mailing list pgsql-general

From Warren
Subject Function with COPY command?
Date
Msg-id 46719369.7050301@clarksnutrition.com
Whole thread Raw
Responses Re: Function with COPY command?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Is there any way to make this function work?

CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$
DECLARE
     filename ALIAS FOR $1;
BEGIN
     COPY table FROM filename;
END;
$$ LANGUAGE plpgsql;

The version below works fine, but I need something like the above version.

CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$
DECLARE
     filename ALIAS FOR $1;
BEGIN
     COPY table FROM 'C:\\somefile.txt';
END;
$$ LANGUAGE plpgsql;


--
Thanks,

Warren

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: explain analyze on a function
Next
From: Warren
Date:
Subject: COPY Command and a non superuser user?