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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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