psql \copy

Поиск
Список
Период
Сортировка
От Steve Clark
Тема psql \copy
Дата
Msg-id b1ad085a-6fb0-979d-3d7a-01ce52e61e53@netwolves.com
обсуждение исходный текст
Ответы Re: psql \copy
Re: psql \copy
Re: psql \copy
Re: psql \copy
Список pgsql-general
Hello,

I am using psql to copy data extracted from an InfluxDB in csv format into postgresql.
I have a key field on the time field which I have defined as a bigint since the time I get
from InfluxDB is an epoch time.

My question is does psql abort the copy if it hits a duplicate key, or does it keep processing?


Thanks,
--
Stephen Clark
NetWolves Managed Services, LLC.
Sr. Applications Architect 
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
http://www.netwolves.com

Email Confidentiality Notice: The information contained in this transmission may contain privileged and confidential and/or protected health information (PHI) and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act of 1996, as amended (HIPAA). This transmission is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, dissemination, distribution, printing or copying of this transmission is strictly prohibited and may subject you to criminal or civil penalties. If you have received this transmission in error, please contact the sender immediately and delete this email and any attachments from any computer. Vaso Corporation and its subsidiary companies are not responsible for data leaks that result from email messages received that contain privileged and confidential and/or protected health information (PHI).

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

Предыдущее
От: Radoslav Nedyalkov
Дата:
Сообщение: create index insist on 2 workers only
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: psql \copy