On Thu, Jun 27, 2019 at 2:06 PM Cherio <che...@gmail.com> wrote: > 2. Have a sql query check button (unless I'm mistaken, I don't see it) >> where it will check if your sql syntax is correct, but wont execute it. >> > > I personally use "Analyze" for that purpose. It seems to be doing exactly > that >
A plain EXPLAIN would also achieve that, but without the cost of ANALYZE. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
