Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values - Mailing list pgsql-bugs

On Tue, Apr 05, 2005 at 21:11:12 +0100,
  Eric McGough <emcgough@yahoo.com> wrote:
>
> COPY my_table FROM STDIN WITH DELIMITER AS '|';
> \N|\N|\N
> \.

COPY doesn't provide a way to use default values for just some rows.
You can get the default for a column by leaving it out of an explicit
column list. But that will apply for all rows.