Answers for "postgresql root user"

1

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>>';"
Posted by: Guest on November-03-2020
0

postgresql grant owner to user

ALTER DATABASE name OWNER TO new_owner;
Posted by: Guest on June-04-2021

Browse Popular Code Answers by Language