On Tue, Apr 05, 2005 at 21:11:12 +0100, Eric McGough <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq