Re: any psql \copy tricks for default-value columns without source data? - Mailing list pgsql-general

On 5/6/2014 1:22 PM, David G Johnston wrote:
> I know that I can pre-process the input file and simply add the needed data
> but I am curious if maybe there is some trick to having defaults populate
> for missing columns WITHOUT explicitly specifying each and every column that
> is present?

if you didn't specify the columns in your file, how would you expect it
to know whats there and not there?



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast