Postgres Pro
Downloads
Home   >   mailing lists

Re: Function with COPY command? - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Function with COPY command?
Date
Msg-id bf54be870706141306g3b739f47l374f7e8d53f56da2@mail.gmail.com
Whole thread Raw
In response to Re: Function with COPY command?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Something like this will help:

CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$
DECLARE
    filename  ALIAS FOR $1;
    fin varchar;
BEGIN
    fin := 'COPY table from ' || filename;   
    execute fin;
END;
$$ LANGUAGE plpgsql;

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 6/14/07, Tom Lane <tgl@sss.pgh.pa.us > wrote:
Warren <warren@clarksnutrition.com > writes:
> 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;

Use EXECUTE.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: COPY Command and a non superuser user?
Next
From: "Mason Hale"
Date:
Subject: Hash Aggregate plan picked for very large table == out of memory