psql -d postgres -c "ALTER USER app WITH SUPERUSER;"
Make a role a superuser
Promotes the role to superuser, which bypasses every privilege check in the cluster: it can read all data and drop anything. Grant it only to roles you trust completely. Prefer targeted grants for application roles.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.