Pages

Tuesday, September 3, 2019

pspg supports sort by selected column

Master branch of pspg supports sort by column selected by vertical cursor.

Why I wrote this feature? You can try to list of tables in psql by \dt+ command. The result is sorted by schema and by name. Sometimes can be interesting to see result ordered by table's sizes. Now it is easy. Press Alt-v to show vertical cursor. Later move to right to "Size" column. Then press d as descendent sort. You can get resuly like attached screenshot:



The sort is working only on numeric columns (but units used by psql are supported)

Update: Now, you can test this feature in version 1.9.0.

No comments:

Post a Comment