When using COPY
to restore a CSV
file, 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
. simple SELECT
queries returns 0 rows, but the database size is 4GB. Also:
SELECT count(*) FROM tbl_data
return 0. Can anyone help?