Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBveS-000563-1I for pgsql-performance@arkaria.postgresql.org; Mon, 15 Oct 2018 05:42:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gBveQ-00058d-4e for pgsql-performance@arkaria.postgresql.org; Mon, 15 Oct 2018 05:42:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBveP-00058O-OI; Mon, 15 Oct 2018 05:42:45 +0000 Received: from mxgate02.cyient.com ([110.76.168.203]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBveG-0006Er-0x; Mon, 15 Oct 2018 05:42:43 +0000 X-IronPort-AV: E=Sophos;i="5.54,383,1534789800"; d="png'150?scan'150,208,217,150";a="52212603" Received: from unknown (HELO CYMADFPBSMTP) ([172.17.1.108]) by mxgate02.cyient.com with ESMTP; 15 Oct 2018 10:58:59 +0530 Received: from CYMADFPBSMTP.CORP.CYIENT.COM (localhost.localdomain [127.0.0.1]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id 01DFD8034811; Mon, 15 Oct 2018 11:12:15 +0530 (IST) Received: from CYINMBX5.CORP.CYIENT.COM (unknown [172.17.4.165]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id DD69A8034812; Mon, 15 Oct 2018 11:12:14 +0530 (IST) Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX5.CORP.CYIENT.COM (172.17.4.165) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.1415.2; Mon, 15 Oct 2018 11:12:28 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::70ad:7702:3b34:3aeb]) by CYINMBX4.CORP.CYIENT.COM ([fe80::70ad:7702:3b34:3aeb%19]) with mapi id 15.01.1415.002; Mon, 15 Oct 2018 11:12:28 +0530 From: Dinesh Chandra 12108 To: "pgsql-performance@postgresql.org" CC: "pgsql-performance-owner@postgresql.org" Subject: Import csv in PostgreSQL Thread-Topic: Import csv in PostgreSQL Thread-Index: AdRkScWsTOHYr64FS0icniYe+QcoUQ== Date: Mon, 15 Oct 2018 05:42:28 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.82] Content-Type: multipart/related; boundary="_004_d3d51b180d0e473893d605d861a36d6ecyientcom_"; type="multipart/alternative" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_004_d3d51b180d0e473893d605d861a36d6ecyientcom_ Content-Type: multipart/alternative; boundary="_000_d3d51b180d0e473893d605d861a36d6ecyientcom_" --_000_d3d51b180d0e473893d605d861a36d6ecyientcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a CSV file having only 400 records. I have to import it in DB table, it's working fine but why it's importing 1= 047303 rows as I have only 400 records are present in that file. Could you please help me on this? [cid:image001.png@01D46477.F29B0B00] Regards, Dinesh Chandra ________________________________ DISCLAIMER: This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies = of the original message. Check all attachments for viruses before opening t= hem. All views or opinions presented in this e-mail are those of the author= and may not reflect the opinion of Cyient or those of our affiliates. --_000_d3d51b180d0e473893d605d861a36d6ecyientcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,<= /p>

 

I have a CSV file havi= ng only 400 records.

 

I have to import it in= DB table, it’s working fine but why it’s importing 1047303 row= s as I have only 400 records are present in that file.

Could you please help = me on this?

 

 

Regards,

Dinesh Chandra

 



DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies of the original message. Check all a= ttachments for viruses before opening them. All views or opinions presented= in this e-mail are those of the author and may not reflect the opinion of = Cyient or those of our affiliates.
 --_000_d3d51b180d0e473893d605d861a36d6ecyientcom_-- --_004_d3d51b180d0e473893d605d861a36d6ecyientcom_ Content-Type: image/png; name="image001.png" Content-Description: image001.png Content-Disposition: inline; filename="image001.png"; size=2779; creation-date="Mon, 15 Oct 2018 05:42:28 GMT"; modification-date="Mon, 15 Oct 2018 05:42:28 GMT" Content-ID: Content-Transfer-Encoding: base64 iVBORw0KGgoAAAANSUhEUgAAArgAAAAnCAIAAABrDazHAAAAAXNSR0IArs4c6QAAAAlwSFlzAAAO xAAADsMB2mqY3AAACoBJREFUeF7tnYth4zYMhu24g90i3aATdLrbpBt0gsYuKcgwApAg+JDjJH9y cRSZBMEPIAA9rDufOr9+//7NPX79+tXZG81BAARAAARAAARAAARAAARAAARAAAS+BYHzy86CT13Q eQv1Z0Rt6pK680akV7FN7TyK1Uq2JFFSf7s9rJLq6PDxTwLNw1k1hSZ5bsA2lV3k+a2aXbhNcNa2 mbLvK5xUW3iSryjK2dnrz00vLRqRF9GAp/WuR2XxoJ8MKOZ4e8Span5o5ytjoIxIrEDTvhx+VSiW dvE5q8k212+NZ685xtorSk0+kVFkG7tt+dCeePyJ2L1o/aDrvgXbHdSsOL3ifCKLZ0ZJRxO2llon RXuznmnDrqsZDf2+Dh/W5LjRHXqTg1qeyj0sZ2cd0lsz2kp9IqL8sWY0YbBd9u3185rzD5i1GR9t uIyv+kgkiUsbmN2Tu9T8UK0X1Uymduk/tRRSXC9Wpl2SReHSUT8rTjpmKrr6Qv8vDl2zl4wtxUpF JZeI3Wfy0WcWCkuiZM3wLNxuNLvIBrVqUe6fMcCT44sdrivNFLU91I42efjEmnZZqK21exJOX9aF rNoLNenyouK4NT/vkhxsXHS5g/xQFQfBWuGzTBMEWFwUNZ2DU+6KisUwInf6xy1j0zy01zP935+I jCr+0aafdyJ2L8aronpvsqmKcfyWdEFuY8dw2pMEKV/m79q4tbTk6MlvRUpp69nNADEfzoLuXuOs GFqF47Yv2ovNZBOeXyWocWt6ykGbtIvJNbIAgpDjNcewwNpijvi/4lOzlxPirTMEi9qDcrm/ooP+ UOQQnFfcjkFlnPXix08VD+nP9LrWveOziJOZaTmjTy+f3vYqHVhDPCH4z/CR+q+SwzLfLA4agykX T3Gkd1Wx47e3c6idKlFyrFPaIov2yK8xV14bazhTklgWHnRfbu8XlRE+NRpFv6/Z0RFCbzH/CPze SdmoyqMozv7o0hZNPQfiQhFC0a+C/i/rCYbMy9OZgmPHLj9XftuEVmugCqNmUPblFP2na16RiUSi bY1z7zqSxo3o1mzD66LZ0mnQtV78gWr6xNdv73rsbV/Uf5X/k3DHKEvs1Rsn40H7cemBcr+CtUp7 moCVP+PEKlWQqpMKL4w11gYyNyyZ+NFClqy0VUrWlOl1qt72S/Rf6FdBfeSIFl2XPgNVnVVSFUbB WTjlQjGLd82rmSB7lZScff69kgfaNxdvpAyi8mVg9KIDFEWtkr9EyVqtsNCvavMt2msgna2KkwrF o1CgCahhONvNm7Mof4l1pZI2qKljsuaIvk8MWK45IhrECTixJhj44mMNtHRK1VWxJq4VrYWaxwb9 XB3wvQJkDlPFmLiK85KI5/CP23GmZW0Wn2XHF1+/jJrd/sn+r/g0q72abwQ5xw+tQzczHp0dj5DP pOxGc+HJWFOLO3I/rbr5yNJU7MkNrF18xzrCjr1TfqZdeu1e86UjuEUCXMTP/UikRuk11mT7sRoo Pqhd0XH/r/Fn5r3O46jti/qsmqCm8BH6xBNe05+D7nGEHWnoOJ9n2v0s1VILo/aWmgn3KrZ35Eso cmjuQvU45WC1EUnMtm/QCdhg/tSK+g/wDK4oq0yQj/W8SPVDWtVcIrLftyPT8wusphPabOfYRTEc qO1qzh93rSShaEqW0JyyskvEvs5Mi/rIIZouHcHYFCIBDvunFMLz6uKpgm/xT4d/MY7V1lGE23Bw UDyL6cdyri0QyWGAp5oFBy4m4+e85uKSoabZ2GnQm8LialuANSdX+U7FyUjy5QlGOAenMPLApaDo GYOhbzCPAhQIvBSBYkKymfKldIYyX5oA8tGw+eLougsF58hgWF10tATAGV4BAiAAAiAAAiAAAiAA AiAAAiDw0gT2MwrNy07Fq/U0M3uROH5Cg06w1y54S/mSYu2CGbdxrr3RiFJa80aElzYglAMBEAAB EACBIwnkTz1w3lX5tZiPOa2mDed2jKDO9oqmVKYov3ZXDutDQzcnpfSvtQ9OBM1AAARAAARA4FsS yI9w5rMCtaP2+YLAskvj1u574sa1MiJiCVU3FLuo8ygzNyFHVEIbEAABEAABEPhyBPRzFCL5dckk mwM5JxukAk05NW2bZcqSaUIICIAACIAACHxpAqEHLtUOx+XZCD7r0HWDgs/OfijZP+i3Q/N5i2JH u9Nv/6UtDeVBAARAAARAYIDAeKFAh/Iy18rbFwZUkV1qh/vygoVqUyxQajdS1OQvufFicu7oDgIg AAIgAAKvQ0AXCpFbB56jvTrc57qkWI4MnMbAHQnPsSNGAQEQAAEQ+NIE9v9m2h5hyxsYB9LwJJT5 LO5XPM5Fh0nN0R0EQAAEQAAEvhOBqecoqHSrPkTgY6qVJqmXeisySrGUqelTk9+l/3dyAswFBEAA BEAABEAABEAABEAABEAABEAABEAABEAABEAABEAABEAABEAABEAABJ5AoPt/j3yCTjQE3zGgngsZ v8+Rb1x4/s2YT6OEgUAABEAABEDgUALjz1FYopbzeET78cglI0IICIAACIAACIBAnMBnFgqHPkSZ hduNOB20BAEQAAEQAIEfTuAsz/CrU/TFjwuq8/kJHx/6O+2pmZQ/8PHIyMcayZzyaoUa94fbG9MH ARAAARAAgS4C+wOXZB/Kx5zUi7cIpHfV04799la+fMCifBS0kmMnY5+yLB/aKEV1gUBjEAABEAAB EAABS+Bx6YFyv2qRdq66QFCUv8QkpKT8WiIWQkAABEAABEAABB6FAlUJ6ojc/g8Lw8iK8oelyY7F Mwq4R2EJWwgBARAAARD44QRCNzMuPK9QxH2EfHlpgwaNf67yh/sEpg8CIAACIAACTOBxM6NNpcWb E1OzyE2F/h2OPDyLkllc7uRbFtRGJPHbvjA8CIAACIAACIDA4QSOOAFwuNIYAARAAARAAARAoJ9A 95MZa6cZ+odGDxAAARAAARAAgVcncP7zr7+zjrf0TV+3W96iv+/78v5z+k6v5+1V/EzMcB80/9pG Sr9o9DTM42cfdx+yczieVxacpd+u2+vtek1b123fXeQ+vzT2+Zz2vt9OqdH77fZ+vf13vb6/p420 Y6dE6iQcxOLtfL68pa/t9Xy65D15FklQHjL1o+EIK82YFKHxhRo8w0z8PkD+vSmWf9Jg+Sv/2uBs EknGXeYmb9txupGUc9IrdXl7u1w2TS+XXRBZtbti7DQEmn9vAh/W8mOV7dGk4J9pLeV1kV9pTaaX 0zWvj31NkZM/XHfz20vy27zAkifTQtgXwIc1TH8UAhWc/Hs7IWZ3GIHzP/++fxTOKWZPP/u7j9U7 lrGrM7iXCXvy3IuTLUnua/2+NQNBJNCcsHOhsEcoSrT30HJPyNfTKaV1LhRSrZCqhPSaoxnFIH7d AlIKXjkP50Jh26DSIb9FNUn6l0oOrgy2nR+S+kOLj3wF9w+RM6d8ipTi614JPaqQu/Vy46wfhdr0 k76TslSQoUyYcS30ZQL7Wt7dMGV9KoSpKqbCldw+r4q9StiWIa2G01a57/XxtvyTv271wPa9FQqX yx9cJVPZzKN/3KKyf3Gwgq1B4GcS+B9WfPi7drI+bAAAAABJRU5ErkJggg== --_004_d3d51b180d0e473893d605d861a36d6ecyientcom_--