Horje
createdb postgres command line Code Example
create postgres database 
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
createdb with postgresql on ubuntu 
susudo -u postgres
psqlpostgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;
Source: medium.com
createdb postgres command line 
su - postgres
# if not created
createuser test
# now create db
createdb testdb
alter user testuser with encrypted password 'qwerty';
grant all privileges on database testdb to testuser;
Source: stackoverflow.com



Sql

Related
logtash mysql cofiguration file Code Example logtash mysql cofiguration file Code Example
sql case when exists in another table Code Example sql case when exists in another table Code Example
mysql update column with value from another table Code Example mysql update column with value from another table Code Example
sql server in python Code Example sql server in python Code Example
sql get highest date from 3 tabels Code Example sql get highest date from 3 tabels Code Example

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



 

Horje