HeidiSQL is not showing any data even when table size is more than 0B

Asked Dec 18 '22 at 07:47

Active Dec 18 '22 at 08:27

Viewed 257 times

I have Postgresql Database in production and i'm trying to insert data from my localhost using psycopg2 library. i'm seeing my database through HeidiSQL. But after i finished inserting the data, my HeidiSQL shows that table size increased but when i try to see the data, it shows 0 rows. I have tried to drop all tables and re-migrate and re-insert the data, but still it shows 0 rows even when the table size is not 0 B.

I have tried to insert table one by one from the program by comment the other insert and it works. But i still can't understand why i can't see any data when i'm inserting simultaneously

edited Dec 18 '22 at 08:27

asked Dec 18 '22 at 07:47

Michael Halim

Are you refreshing the display after doing the insert? The display does not automatically refresh. I see you have a filter set, are you sure the filter still applies? – Tim Roberts Dec 18 '22 at 07:56
i have restarted heidisql after i insert my data. And my filter is not set. `id>0` filter is recent filter – Michael Halim Dec 18 '22 at 07:58
Perhaps you don't run HeidiSQL in autocommit mode and forgot to `COMMIT`. – Laurenz Albe Dec 19 '22 at 07:03

HeidiSQL is not showing any data even when table size is more than 0B

0 Answers0