Stephen Frost <sfrost(at)snowman(dot)net> writes:
> No, I'm interested, as I discussed in my message, 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,
INSERT INTO mytable VALUES (mydatefunc('2001/01/03'), ... );
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Marc G. Fournier||Date: 2003-11-28 17:59:08|
|Subject: Re: about explain analyze |
|Previous:||From: Tom Lane||Date: 2003-11-28 17:31:08|
|Subject: Re: -fpic vs. -fPIC |