PostgreSQL does not return rows

Hey everyone, how are you? I'm having an issue when running a query against a PostgreSQL. The query returns results on pgAdmin, but when i run it on the query console on Retool it executes succesfully, however no result is returned.

Can you post screenshots and the query you are using?

Hey Scott, thanks for replying. Here's a screenshot that the query run successfully, it should've returned 100 rows. On pgAdmin returns successfully:

Captura de pantalla 2023-06-16 a la(s) 16.17.09

Are you using the Retool db? If so, it doesn't support schemas
You can try using an alias:
select, from public.user p LIMIT 100

Hey there! If the query runs successfully on Retool but doesn't return results, it might be an issue with how Retool is processing or displaying the data. Double-check your Retool configurations, data bindings, or any post-processing steps that might be affecting the display of results from PostgreSQL.