Horje
how to create a new user in postgresql Code Example
create db user postgres 
sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;
Source: medium.com
how to create a new user in postgresql 
CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
Source: medium.com
psql create user 
# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';
how to create new user and database postgresql in ubuntu 
$ sudo -u postgres psqlpsql=# alter user <username> with encrypted password '<password>';
Source: medium.com



Sql

Related
oracle table statistics Code Example oracle table statistics Code Example
sql group by error Code Example sql group by error Code Example
postgresql get last day of month Code Example postgresql get last day of month Code Example
how to check last gather stats on table in oracle Code Example how to check last gather stats on table in oracle Code Example
mysql backup skip table Code Example mysql backup skip table Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje