Day18: Extracting from PostgreSQL

Posted by csiu on March 14, 2017 | with: 100daysofcode,

Another late night. Again today will be simple. In yesterday’s post, we stored data in a PostgreSQL database. Naturally, I now want to extract data for analysis.

Psycopg: PostgreSQL + Python

Looking at Getting data from table in database, we can use the psycopg2 Python library.

  • Documentation for Psycopg, a PostgreSQL database adapter for Python, is found here