Search code examples
sqldatabasepostgresqlaltersuperuser

Postgres: upgrade a user to be a superuser?


In postgres, how do I change an existing user to be a superuser? I don't want to delete the existing user, for various reasons.

# alter user myuser ...?

Solution

  • ALTER USER myuser WITH SUPERUSER;
    

    You can read more at the Documentation for ALTER USER