Postgres Pro
Downloads
Home   >   mailing lists

Conditional query with copy command - Mailing list pgsql-admin

From Sachin Kumar
Subject Conditional query with copy command
Date
Msg-id CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com
Whole thread Raw
Responses Re: Conditional query with copy command  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Sachin Kumar
Date:
Subject: Re: PG Admin 4.28 is crashing while viewing 10M row data
Next
From: Holger Jakobs
Date:
Subject: Re: Conditional query with copy command