database_postgres_python
A collection of simple Python scripts that demonstrate how to create and interact with PostgreSQL databases.
These scripts closely follow the PostgreSQL tutorial pages.
Clone and build postgres:
http://git.postgresql.org/git/postgresql.git
https://www.postgresql.org/docs/11/install-short.html
You may need to install readline and re-run ./configure: https://packages.ubuntu.com/search?keywords=readline
Make sure the regressions test run: https://www.postgresql.org/docs/current/regress-run.html
Follow the tutorial examples to get up to speed with psql: https://www.postgresql.org/docs/11/tutorial-sql-intro.html
Scripts require psycopg2 module: "sudo apt-get install python-psycopg2"
Run my scripts from the command line and verify by logging into the db from psql.