| From: | "Thomasine Dade (tdade)" <tdade(at)cisco(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to sort in pgAdmin 4 |
| Date: | 2017-10-06 14:53:37 |
| Message-ID: | AFD3F930-803D-4644-B0BD-696C78D69382@cisco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Surcouf | 2017-10-06 15:06:24 | Table Node Feature |
| Previous Message | Silvera, Ignacio | 2017-10-06 12:19:26 | Re: pgAdmin 4 v2.0 Released! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Williams | 2017-10-06 15:23:56 | Re: Postgresql CDC tool recommendations ? |
| Previous Message | pinker | 2017-10-06 14:34:17 | Re: delete a file everytime pg server starts/crashes |