JDBC PostgreSQL check database for empty tables and delete them

Question

I have to check for tables in PostgreSQL database that have empty rows, using JDBC, and then delete them from the server. How can I do that? I'm pretty convinced I'd have to iterate through ResultSet object I'd get from the "search" query and put the table names in a looped DROP statement, but have no idea how to retrieve them.

@a_horse_with_no_name getting count from database statisctics to perform drop table, I won't go that way — JustMe, Nov 07 '17 at 09:32

score 0 · Answer 1 · answered Nov 07 '17 at 09:57

0

check List all tables in postgresql information_schema

in short select * from information_schema.tables shows all tables

answered Nov 07 '17 at 09:57

Mehdi M

1
1

JDBC PostgreSQL check database for empty tables and delete them

1 Answers1