psycopg2 can only get query result for one table

I want to query a PostgreSQL database with several tables using psycopg2. But it can only return true results for only one table, and for the other tables it returns 0 rows(empty array) after fetchall() and no error reported. I have already checked that the user has full authority over the database. And the same SQL script is correct (The same SQL script only get a 0-row-result in psycopg2). Where might the problem be?

https://stackoverflow.com/questions/66847875/psycopg2-can-only-get-query-result-for-one-table March 29, 2021 at 09:57AM