Conditional query with copy command

Поиск
Список
Период
Сортировка
От Sachin Kumar
Тема Conditional query with copy command
Дата
Msg-id CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Conditional query with copy command
Список pgsql-admin
Hi Experts,

I am uploading 10 million data using CSV, but I want to put a condition on a column (Card_Status) inside the CSV that only where Card_Status = A data should be uploaded rest data are not uploaded.
Please guide me in modifying the query I am using to upload the data
Query:- 
copy hk_card_master_test from 'C:/inetpub/wwwroot/cards/media/static/gc_card_master2L.csv' with delimiter ',' csv header encoding 'ISO_8859_5'

--

Best Regards,
Sachin Kumar

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

Предыдущее
От: Sachin Kumar
Дата:
Сообщение: Re: PG Admin 4.28 is crashing while viewing 10M row data
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: Conditional query with copy command