Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres set user as superuser

ALTER USER myuser WITH SUPERUSER;
Comment

postgres add superuser to database

create USER <<username>>;
ALTER USER <<username>> WITH SUPERUSER;
ALTER USER <<username>> WITH PASSWORD '<<password>>';
Comment

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>>';"
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle stop 
Sql :: sqlserver create table from select 
Sql :: mysql search like order by best match 
Sql :: delete table sql 
Sql :: add postgresql to path 
Sql :: replace null with 0 in sql 
Sql :: asp.net core with postgresql deploy on ubuntu 
Sql :: psql import backup file for windows 
Sql :: inner join php my admin 
Sql :: ksql terminate all queries 
Sql :: select tables with name like mysql 
Sql :: mariadb number format 
Sql :: mysql change primary key 
Sql :: how to add default constraint in mysql 
Sql :: oracle ora-00054 find 
Sql :: Uncaught Error: Cannot use object of type mysqli_result as array 
Sql :: reset identity column values in sql server 
Sql :: sql server cannot create database diagram 
Sql :: use of now() in mysql 
Sql :: sql server date format dd/mm/yyyy 
Sql :: DB::transaction 
Sql :: add foreign key constraint in postgresql 
Sql :: random record using order by rand() mysql 
Sql :: dynamic sql invalid table name 
Sql :: mysql procedures 
Sql :: sql where contains 
Sql :: pl sql disable trigger 
Sql :: ora-01109 database not open in oracle 19c 
Sql :: sql offset 
Sql :: get value from a table an insert it with other values in another table sql 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =