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:
Are you using the Retool db? If so, it doesn't support schemas
You can try using an alias:
select p.id, p.email 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.