I am using pgAdmin 4 v2 on Mac OS X 10.12.6.
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.