Stephen Frost <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster