Create postgres Docker container & simple management commands

postgres_container.sh

###################
# Docker COMMANDS #
###################

# Create volume for persistance
docker volume create pgdata

# Create the container
docker run --name pg -e POSTGRES_USER=test -e POSTGRES_PASSWORD=test -d -v pgdata:/var/lib/postgresql/data -p 5432:5432 postgres

# Access using psql
docker exec -it pg psql -U postgres



#####################
# POSTGRES COMMANDS #
#####################

# List databases
\l

# Connect to database
\c db_name

# Describe all relations (tables) in the DB
\dt