List all indexes in postgres database

indexes.sql

# VIEW INDEXES applied on database.
select schemaname, tablename, indexname, indexdef from pg_indexes WHERE schemaname='public';


# Create superuser for postgres on linux shell with postgres user. 
user@ubuntu$ sudo su postgres
user@ubuntu$ createuser --interactive --pwprompt root
> Enter password for new role: ********
> Enter it again: ********
> Shall the new role be a superuser? (y/n) y