Google Code-in

Use the Python database adapter psycopg to query data from a PostgreSQL table. You'll need to first establish a connection to the PostgreSQL application through psycopg, create a sample table, insert some sample data into the table, and then finally execute a series of queries (such as the SELECT statement) against the data. Illustrate a few different Python methods (such as fetchmany() or fetchall()) for querying data.

The expected submission will be a document explaining the steps taken along with screenshots illustrating your progress, in addition to the output from a command to display the table list in the created database.

This task is dependent on the information learned from completing a separate task: PostgreSQL & Python - Creating Tables.