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 [, ...] ]
]