Re: Extra Paranthesis on joins on saving a view - Mailing list pgadmin-support

From richard coleman
Subject Re: Extra Paranthesis on joins on saving a view
Date
Msg-id CAGA3vBt-TQ+54KDfWW_=Rk19jUD3HjWqawnPd9hrNRO7dtJhFg@mail.gmail.com
Whole thread Raw
In response to Re: Extra Paranthesis on joins on saving a view  (Alex Williams <valenceshell@protonmail.com>)
List pgadmin-support
Alex, 

Sounds like you would like to register some feature requests for pgAdmin4.  Your best bet would be to enter them here:

One item per feature request.

Good luck, 

rik.

On Wed, Dec 2, 2020 at 8:44 PM Alex Williams <valenceshell@protonmail.com> wrote:
Hi,

I'm not sure if this is something new but in previous versions of pgadmin (currently using 4.27 where this is happening,) when creating a view, more or less, my original sql was maintained, but now it's mangling the joins like MS Access does with the Jet database with lots of parenthesis's (yes, I still use Access 2000.) Is there a way to disable this? I find it very difficult to parse and wind up removing them all only to have come back when saved when I'm done modifying / saving the view.

Also, can you:
1. Allow renaming tables/functions/etc... without having to invoke properties....it's very slow sometimes to bring up that dialog....and sometimes I use rename just to copy a object name, not to rename it.

2. When running View/Edit->First 100 Rows, can you not lock it, i.e., it's a convenient way to have the select statement written without typing and then you add the predicates/joins.

3. When creating a table, can you please allow rearranging of the columns.

Thanks,

Alex



pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: Extra Paranthesis on joins on saving a view
Next
From: Durumdara
Date:
Subject: How to save a blob (binary, bytea) to a local file?