Subject: Re: Conditional query with copy command
To: pgsql-admin@lists.postgresql.org
References: 
 <CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <f05f4e12-8eea-62fe-4a7b-3e5a0298aaf0@jakobs.com>
Date: Thu, 26 Nov 2020 10:42:49 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.5.0
MIME-Version: 1.0
In-Reply-To: 
 <CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="sm6bYG3do3QGnXmZu1BmX0VBHZmWrEIjf"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--sm6bYG3do3QGnXmZu1BmX0VBHZmWrEIjf
Content-Type: multipart/mixed; boundary="9sLHVSqmosRz7hycAg0Xyy19Hit77h7j4";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <f05f4e12-8eea-62fe-4a7b-3e5a0298aaf0@jakobs.com>
Subject: Re: Conditional query with copy command
References: <CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com>
In-Reply-To: <CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmail.com>

--9sLHVSqmosRz7hycAg0Xyy19Hit77h7j4
Content-Type: multipart/alternative;
 boundary="------------4097CC031FD0D1B733F098E7"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------4097CC031FD0D1B733F098E7
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi,

Use the new syntax as of PostgreSQL 9.0:

copy hk_card_master_test from=20
'C:/inetpub/wwwroot/cards/media/static/gc_card_master2L.csv' (format=20
csv, header, encoding 'ISO_8859_5') where card_status =3D '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=20
> condition on a column (Card_Status) inside=C2=A0the CSV that only where=
=20
> Card_Status =3D 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=20
> 'C:/inetpub/wwwroot/cards/media/static/gc_card_master2L.csv' with=20
> delimiter ',' csv header encoding 'ISO_8859_5'
>
> --=20
>
> Best Regards,
> Sachin Kumar

--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------4097CC031FD0D1B733F098E7
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>Use the new syntax as of PostgreSQL 9.0:</p>
    <p>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 =3D
      'A'</p>
    <p>This allows a simple WHERE condition as shown.</p>
    <p><br>
    </p>
    <div class=3D"moz-cite-prefix">Am 26.11.20 um 09:27 schrieb Sachin
      Kumar:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CALg-PKDeVkeia_6Dv-_Tc0wm4qQVYPioe9i+D-FhERx84aKEzw@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Hi Experts,
        <div><br>
        </div>
        <div>I am uploading 10 million data using CSV, but I want to put
          a condition on a column (Card_Status) inside=C2=A0the CSV that =
only
          where Card_Status =3D A data should be uploaded rest data are
          not uploaded.<br>
          Please guide me in modifying the query I am using to upload
          the data<br>
          Query:-=C2=A0</div>
        <div>copy hk_card_master_test from
          'C:/inetpub/wwwroot/cards/media/static/gc_card_master2L.csv'
          with delimiter ',' csv header encoding 'ISO_8859_5'<br
            clear=3D"all">
          <div><br>
          </div>
          -- <br>
          <div dir=3D"ltr" class=3D"gmail_signature"
            data-smartmail=3D"gmail_signature"><br>
            Best Regards, <br>
            Sachin Kumar<br>
          </div>
        </div>
        <img src=3D"http://s.bl-1.com/LKbJdfd.gif" moz-do-not-send=3D"tru=
e"
          width=3D"1" height=3D"1"></div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------4097CC031FD0D1B733F098E7--

--9sLHVSqmosRz7hycAg0Xyy19Hit77h7j4--

--sm6bYG3do3QGnXmZu1BmX0VBHZmWrEIjf
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCX794mQUDAAAAAAAKCRCKV5yTsxlhuiIz
AKDcQ93nnLwAmF4798eDWNvvZF/eFwCfXFDuG0F9zy8yae+kuyWW5IcH9LA=
=2VoW
-----END PGP SIGNATURE-----

--sm6bYG3do3QGnXmZu1BmX0VBHZmWrEIjf--