Default not triggering - Mailing list pgsql-admin

From lbottorff@harveycounty.com
Subject Default not triggering
Date
Msg-id 862569FF.00613057.00@mail.harveycounty.com
Whole thread Raw
List pgsql-admin
I'd like to do a copy of a text file into a table. I follow the procedure and it
works fine, except default values for empty fields are never enacted. I have a
timestamp field which uses "DEFAULT CURRENT_TIMESTAMP". It never gets fired
during a "copy from...", although it works fine for "insert into..." Is there
any way to have copy respect/respond to my defaults?

LB



pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: not use pg_dump & pg_dumpall
Next
From: Michael Davis
Date:
Subject: RE: relation does not exist