--- Tom Lane <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROTECTED]> 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?
Yep, but that won't work (foreign key id's, timestamps other than now(), ...) CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster