COPY FROM wish list

Hello,

Looking at the TODO List, I feel that only some aspects of the COPY FROM
command are adressed.
Could a discussion trigger some activity on this topic :o) ?

Best regards,

Marc Mamin

Here my wish list:

COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]

[ CHECKONLY (DATA_TYPES,CONSTRAINTS) ] # do not import, just
check the content

[ SKIPLINES (n) ]

[ HEADERLINE (n) ] # line conlaining the column names, must be
within the line to skip.
# must match the column list when both are
given
[ DEFERCONSTRAINTS ]

[ SKIPINVALID [FILE file ] SKIPLIMIT (n)] # when set,
invalid lines are skipped and possibly stored in file
# an exception is
triggered when more than SKIPLIMIT lines are found


[ NULLREPLACEMENT (column =value[, ...] ) ] # allow a per column
handling of null values.
# cannot be set
allong with NULL [ AS ]
# not usable for
columns that are missing in the input file ?

[ FEEDBACK (n) ] # display progress every n rows .# for
ORACLE users...

[ COMMIT (n) ] # just an idea: commit each n rows....

[
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE NOT NULL column [, ...] ]
]