Re: COPY enhancements

Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>   
>> I don't see any reasonable way to sandwhich the FORCE NOT NULL syntax
>> into a keyword/value notation.
>>     
>
> Any number of ways, for example "force_not_null = true" or multiple
> occurrences of "force_not_null = column_name".  Andrew was on the verge
> of admitting we don't need that option anymore anyway ;-), so I don't
> think we should allow it to drive an exception to the simplified syntax.
>
>             
>   

We won't need it if we can use an expression on the source, like
   coalesce(t[4],"")

that gets applied on the way in. Until then it is useful, if ugly.

cheers

andrew