Import csv in PostgreSQL

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 1047303 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 __

Suggestion to optimize performance of the PLSQL procedure.

Dear expert, Could you please review and suggest to optimize performance of the PLSQL procedure in PostgreSQL? I have attached the same. Thanks in advance Regards, Dinesh Chandra DISCLAIMER: This email message is for the sole use of the intended recipient(s)

Installing PostgreSQL 9.5 in centos 6 using YUM

Hi Team, Could anyone help me to solve the below issue. I am installing PostgreSQL 9.5 in centos 6 using YUM [root@VM-02 PostgreSQL]# yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-3.noarch.rpm Loaded plugins: fastestmirror, refresh-packag

Re: Re: PGadmin error while connecting with database.

ved. tcp 0 0.0.0.0:5432 0.0.0.* LISTEN Regards, Dinesh Chandra Cyient Ltd. From: Mariel Cherkassky Sent: Friday, January 12, 2018 2:14:31 PM To: Dinesh Chandra 12108 Cc: pgsql-performance-ow...@postgresql.org; pgsql-performa...@postgresql.org Subj

PGadmin error while connecting with database.

Dear Expert, While connecting PostgreSQL 9.3 with PGAdmin client I am getting the below error. [cid:image001.png@01D38B8F.6F382110] However I am able to connect the database using psql thourgh Putty. Entry in pg_hba.conf # IPv4 local connections: hostall all 127.0

RE: Re: Unable to connect Postgres using psql while postgres is already running.

Hi Laurenz Albe, Thanks for your response. But file ".s.PGSQL.5432" does not exist . How can I re-create this or any other option? Regards, Dinesh -Original Message- From: Laurenz Albe [mailto:laurenz.a...@cybertec.at] Sent: 10 January, 2018 2:41 PM To: Dinesh Chandra 1210

Unable to connect Postgres using psql while postgres is already running.

Hi Expert, After restarting PostgreSQL Server, I am unable to connect postgres from putty, I am getting error psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? While postgres i

CPU 100% usage caused by unknown postgres process..

Hi, My CPU utilization is going to 100% in PostgreSQL because of one unknown process /x330341 is running from postgres user. PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 19885 postgres 20 0 192684 3916 1420 S 99.3 0.1 5689:04 x330341 The same fil

ODBC--call failed :: Bindings were not allocated properly

Dear Team, I am accessing PostgreSQL database objects using Microsoft-Access ODBC connection and tables are loaded but while opening table getting the below error msg. ERROR :: ODBC--call failed :: Bindings were not allocated properly. (#15) and [cid:image001.png@01D3694F.14B9A540] Regard