When I filter my data so that I can edit it, it sets a default sort. The text of the query is displayed but it’s grayed so I cannot edit the ORDER BY statement. How can I change the order by?
In pgAdmin 3, I had a “Data Sorting” option but do not see that option in pgAdmin 4.
These are the steps I followed in pgAdmin 4:
Right-click on table name
Choose View/Edit Data > Filtered Rows
Enter the filter value that will be used to create the WHERE clause
Click OK
The query displays at the top and it’s grayed out and it includes an ORDER BY statement
Thanks.
Please note, this should go to pgadmin-support. I have forwarded for you
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.