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

Поиск
Список
Период
Сортировка
От David Gagnon
Тема Improvement for COPY command .. unless it already exists (If yes please tell me!)
Дата
Msg-id 4255257C.9020004@siunik.com
обсуждение исходный текст
Ответ на Re: COPY command use UTF-8 encoding and NOT  (Tino Wildenhain <tino@wildenhain.de>)
Ответы Re: Improvement for COPY command .. unless it already exists (If yes please tell me!)
Список pgsql-general
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 1500000 rows of
the file.  If it was possible to default their value instead of putting
it in the file, it would have been great!

COPY vd (VDNUM=DEFAULT, VDVSSRC=2, VDVSNUM=1, VDKEY, VDDATA)
FROM '/cygdrive/f/projects/web-catalog/var/vdOk.backup';


Thanks anyway .. your doing a wonderfull job with postgresql!
/David


В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: using limit with delete
Следующее
От: Mage
Дата:
Сообщение: Re: lower function