Postgres
Introduction
This is a page for keeping track of using postgres
Install
Nice and easy lemon squeezy
sudo apt install postgresql postgresql-contrib
Getting to CLI
Login and envoke the CLI
sudo -i -u postgres
psql
Quiting..
\q
Useful commands
# Show users
\du
# Show databases
\l
# Show tables
\dt
# Create database
CREATE DATABASE testdb;
# Use database
\c testdb
# Create Table
# Describe the Table
\d test_table
# Create Index
# Command History
\s