/SQL/Postgres set user as superuser

Postgres set user as superuser

Postgres set user as superuser

ALTER USER myuser WITH SUPERUSER;

1

Source: stackoverflow.com

Postgres create user with superuser privileges

sudo -u postgres createuser -s -i -d -r -l -w <<username>>
sudo -u postgres psql -c "ALTER ROLE <<username>> WITH PASSWORD '<<password>>';"

1

Source: stackoverflow.com

Similar codes

11 votes128 views4 answers
Query DISTINCT
SQL
1 vote124 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote154 views1 answer
Postgressql uuid
SQL
0 vote155 views1 answer
How to combine rows in sql server procedure
SQL
1 vote137 views1 answer
Postgresql escape single quote
SQL
4 votes132 views2 answers
How to delete row in sql
SQL
10 votes123 views2 answers
Sql merge statement
SQL
0 vote136 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote128 views1 answer
Mysql convert charset
SQL
2 votes136 views1 answer
Sqlite indexes
SQL

Share