Re: Functions with COPY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Functions with COPY
Date
Msg-id 29060.1070041669@sss.pgh.pa.us
Whole thread Raw
In response to Re: Functions with COPY  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Functions with COPY  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> No, I'm interested, as I discussed in my message[1], in the ability to
> use functions in a copy statement to allow me to specify the conversion
> from text to the appropriate data type.

COPY is not intended to be that flexible; it's intended to be fast.
You can do any amount of processing you want in an INSERT statement,
though.

INSERT INTO mytable VALUES (mydatefunc('2001/01/03'), ... );
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: -fpic vs. -fPIC
Next
From: "Marc G. Fournier"
Date:
Subject: Re: about explain analyze