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