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