How to sort postgres table in the command line?

Question

I'm viewing a table in my command line but I'm not sure how it's sorted:

I use the TABLE "Notification"; command to display the rows in the table. Any tips on how to sort the display of this table? All my searches show how to sort a table result in a actual postgres query.

You have to run an actual PostgreSQL query with an ORDER BY clause. — Laurenz Albe
– Laurenz Albe, Commented May 16, 2022 at 16:46
Data in SQL tables is not ordered so you need specify an ORDER BY to sort by your desired field(s). TABLE is equivalent to SELECT * FROM some_table, so TABLE "Notification" ORDER BY some_fld. I would get into the habit of using SELECT. — Adrian Klaver
– Adrian Klaver, Commented May 16, 2022 at 18:16

John Hill · Accepted Answer · 2022-05-16 20:37:06Z

1

To sort the rows by a certain order the ORDER BY is used.

For example (In your case):

SELECT id, watched FROM schema_name.notification ORDER BY id ASC;

This will sort the table by id ascending, but it can also be sorted decending by using DESC instead of ASC.

I hope this helps.

answered May 16, 2022 at 20:37

John Hill

618 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort postgres table in the command line?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related