PostgreSQL - How to show all columns with indexes?

To show all columns with indexes

1. Using psql:

\d table_name;

It shows the view of tables variables, indexes and constraints.

2. Using SQL query editor:

SELECT * FROM pg_indexes WHERE tablename = 'table_name';

---

Need a good GUI tool for PostgreSQL? Check out TablePlus. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.