From a945feb02f6d64df2219ea1044251a7fe2ea98fc Mon Sep 17 00:00:00 2001
From: Mateja <mail@matejamaric.com>
Date: Sat, 3 Apr 2021 00:37:03 +0200
Subject: Initial commit.

---
 postgresql | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 postgresql

(limited to 'postgresql')

diff --git a/postgresql b/postgresql
new file mode 100644
index 0000000..63b2dc2
--- /dev/null
+++ b/postgresql
@@ -0,0 +1,50 @@
+pacman -S postgresql
+chmod postgres:postgres /var/lib/postgres
+
+sudo -iu postgres
+initdb -D /var/lib/postgres/data
+
+vim data/pg_hba.conf
+vim data/postgresql.conf
+
+'''
+exit
+systemd restart postgres
+sudo -iu postgres
+'''
+
+createuser user_name
+createdb -O db_owner db_name
+psql db_name db_user
+
+\du
+\l
+\c db
+\dt
+\q
+
+
+End everything with ;
+
+CREATE DATABASE d
+USE d
+DROP DATABASE d
+CREATE TABLE t(...) 
+DROP TABLE t
+TRUNCATE TABLE t
+
+INSERT INTO t VALUES(...)
+SELECT ... FROM t [WHERE ...]
+UPDATE t SET ... WHERE ...
+DELETE FROM t WHERE ...
+
+ALTER DATABASE name RENAME TO new_name
+ALTER DATABASE name OWNER TO new_owner
+
+ALTER TABLE name RENAME TO new_name
+ALTER TABLE name SET SCHEMA new_schema
+
+SQL DDL (Date Definition Language) - create, alter, drop, rename, truncate, comment
+SQL DQL (Date Query Language) - select
+SQL DML (Date Manipulation Language) - insert, update, delete, merge, call, explain plan, lock table
+SQL DCL (Date Control Language) - grant, revoke
-- 
cgit v1.2.3