Re: Improvement for COPY command .. unless it already exists - Mailing list pgsql-general

Hi,

I want to default some columns for this COPY command only.  So DEFAULT
is not appropriate in this case.  In fact I think you suggested a
workaround right ?  Doing an alter table before and another one after
will work ... not fully clean thought since my user may not have the
write to modify the table.   Being able to specify default values
directly in the COPY command will be really nice :-)  I just wanted to
share my tought :-)

Being eable to read zipped file will be cool to .. but I'm not sure it's
Chrismas yet right so I didn't ask ;-)

Thanks for your help
/David

Tom Lane wrote:

>David Gagnon <dgagnon@siunik.com> writes:
>
>
>>Is there a way to specify default values in the COPY command?
>>
>>
>
>There's always ALTER TABLE ... SET DEFAULT.
>
>            regards, tom lane
>
>
>