Re: [GENERAL] Improvement for COPY command .. unless it already exists

On Apr 7, 2005, at 10:33 AM, David Gagnon wrote: 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 though

Re: [GENERAL] Improvement for COPY command .. unless it already exists

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

Re: [GENERAL] Improvement for COPY command .. unless it already exists (If yes please tell me!)

David Gagnon <[EMAIL PROTECTED]> writes: > Is there a way to specify default values in the COPY command? There's always ALTER TABLE ... SET DEFAULT. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our exte

[GENERAL] Improvement for COPY command .. unless it already exists (If yes please tell me!)

Hi all, Thanks for your reply on my yesterday's question regarding UTF-8 as a UNICODE implementation in postgresql. Is there a way to specify default values in the COPY command? In my example example VDVSSRC and VDVSNUM are the same for the 150 rows of the file. If it was possible to def