| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Conditional query with copy command |
| Date: | 2020-11-26 09:42:49 |
| Message-ID: | f05f4e12-8eea-62fe-4a7b-3e5a0298aaf0@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
Use the new syntax as of PostgreSQL 9.0:
copy hk_card_master_test from
'C:/inetpub/wwwroot/cards/media/static/gc_card_master2L.csv' (format
csv, header, encoding 'ISO_8859_5') where card_status = 'A'
This allows a simple WHERE condition as shown.
Am 26.11.20 um 09:27 schrieb Sachin Kumar:
> 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
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sachin Kumar | 2020-11-26 10:14:45 | Re: Conditional query with copy command |
| Previous Message | Sachin Kumar | 2020-11-26 08:27:37 | Conditional query with copy command |