We are running PrivateBin with the docker image privatebin/pdo so I can't try easily this update.
If you can release a rc-patch or a temporary image, I'll test it right away.
But as I mentioned in the issue, the query was fine.

From GitHub Copilot Chat:

Yes, the PostgreSQL query you've selected is correct for listing table names that are not part of the system catalogs (pg_catalog and information_schema). This query filters out system tables and returns only the user-defined tables in the database.

SELECT "tablename" FROM "pg_catalog"."pg_tables" 
WHERE "schemaname" NOT IN ('pg_catalog', 'information_schema');

This approach ensures that the query results include only the tables created by users, which is typically what applications need to interact with.

FYI, I tested the new query by overriding the Database.php file in a copy of the image and everything runs smoothly.

Just for my information, when do you plan to release a version including this fix ?

There are currently no plans. We had to rush the last release a little, due to the security fix. So far this is the only item up for the next release. Holiday seasons is still ongoing and mine is still coming up. Depending on activities in September and October, I'd assume we have a few things warranting a release by late fall, maybe?