| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Cherio <cherio(at)gmail(dot)com> |
| Cc: | Alex Williams <valenceshell(at)protonmail(dot)com>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgadmin 4 feature behavior change requests |
| Date: | 2019-06-27 18:44:56 |
| Message-ID: | CA+OCxowwSP0s=wMTahQi5Uriaf_Wzsy8+XWmuErbp-dFzxdS1Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Thu, Jun 27, 2019 at 2:06 PM Cherio <cherio(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Where is Where | 2019-06-28 01:01:16 | Re: import upload file to pgadmin get CSRF error |
| Previous Message | Cherio | 2019-06-27 18:05:50 | Re: pgadmin 4 feature behavior change requests |