CSN <cool_screen_name90001@yahoo.com> writes:
> I guess this is a feature request since I can't figure
> out a way to do it directly in postgresql (plus
> COPY/\copy isn't in SQL specs).
You do know that COPY uses the column defaults for all columns not
listed in the input list?
regards, tom lane