Database not browsable during COPY on PostgreSQL - Mailing list pgsql-novice

From Majid Azimi
Subject Database not browsable during COPY on PostgreSQL
Date
Msg-id CADOhCmut2XO4fu9vFA2VX1=jSsi5m6Lrkg1Jpf9tMb2HsZ-k8A@mail.gmail.com
Whole thread Raw
Responses Re: Database not browsable during COPY on PostgreSQL  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List 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?

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: postgreSQL odbc driver for Sun Solaris
Next
From: Majid Azimi
Date:
Subject: Re: Database not browsable during COPY on PostgreSQL