Skip site navigation (1) Skip section navigation (2)

Database not browsable during COPY on PostgreSQL

From: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Database not browsable during COPY on PostgreSQL
Date: 2012-03-06 08:36:00
Message-ID: CADOhCmut2XO4fu9vFA2VX1=jSsi5m6Lrkg1Jpf9tMb2HsZ-k8A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi guys,

When using COPY to restore a CSV file, PostgreSQL shows alot of

CONTEXT:  COPY tbl_vbvdata, line 8039085:
"1648469982,20431325,1314343300,4.5,87,1,643160,1"

Also phppgadmin shows that the real database size(4GB) but when I
choose to browse the table it shows Estimated row count to 0. I did a
VACUUM ANALYZE. After that simple SELECT queries returns 0 rows, Also:

SELECT count(*) FROM tbl_vbvdata

return 0. Can anyone help?

Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2012-03-06 08:46:27
Subject: Re: Database not browsable during COPY on PostgreSQL
Previous:From: Michael WoodDate: 2012-03-06 08:20:33
Subject: Re: postgreSQL odbc driver for Sun Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group