Postgresql commands

postgres.sql

sudo -u postgres psql
 
CREATE DATABASE test_database;
 
CREATE USER test_user WITH password 'qwerty';
 
GRANT ALL privileges ON DATABASE test_database TO test_user;
 
psql -h localhost test_database test_user
 
CREATE SEQUENCE user_ids;
 
CREATE TABLE users (id INTEGER PRIMARY KEY DEFAULT NEXTVAL('user_ids'), login CHAR(64), password CHAR(64));