Sql

psql -h localhost -U postgres

sudo -u postgres -i
psql -d postgres

sudo -u postgres -i

createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME

template1=# CREATE USER username WITH PASSWORD 'user_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;

sudo -u postgres createrUser Username

PREVIOUS	NEXT

Code Example
Sql :: $query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
Sql :: What is the compatibility level of a SQL database
Sql :: get parameter value in mysql trigger
Sql :: split first name and last name in sql
Sql :: change name of colum in sql table
Sql :: user privileges postgresql information_schema
Sql :: how to insert into existing database postgresql sqlalchemy python
Sql :: insert random numbers in columns postgress
Sql :: mysql smallint range
Sql :: Failed to connect to localhost:1433 - self signed certificate
Sql :: NOT LIKE sql laravel
Sql :: sql select except null
Sql :: postgresql CREATE EXTENSION pgcrypto
Sql :: What is localhost IP and MySql default port no.
Sql :: inner join in update query mysql
Sql :: datetime add 2 hours sql
Sql :: delete index in postgresql
Sql :: describe table query in postgresql
Sql :: mysql update set sum
Sql :: how to know password of mysql root in linux terminal
Sql :: installing postgresql ubuntu
Sql :: combine two columns using sql query
Sql :: shell mysql connect
Sql :: An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
Sql :: sql update table based on another table
Sql :: this is incompatible with sql_mode=only_full_group_by laravel
Sql :: ORA-00903: invalid table name
Sql :: create unique index postgres
Sql :: sql select sum group by id laravel join
Sql :: spring import sql