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