Re: [HACKERS] Bug or feature? COPY ignores column defaults - Mailing list pgsql-hackers

Oliver Elphick wrote:
> 
> At release 6.4.2, COPY does not respect column defaults:
> 
> INSERT works correctly, however.
> 
> Is this intentional, or a bug?

This is standard behaviour. DEFAULT value is sabstituted
only if column value (including NULL) is not specified in 
INSERT statement. 

Vadim