gettables.py

import psycopg2
from config import dbconfig
 

def gettable():
    """ Connect to the PostgreSQL database server """
    conn = None
    try:
        # read connection parameters
        params = dbconfig()
 
        # connect to the PostgreSQL server
        conn = psycopg2.connect(**params)
 
        # create a cursor
        cur = conn.cursor()
        print("The database is live.")

        # execute and comit the sql statement
        with open("gettable.sql", 'r') as f:
            cur.execute(f.read())
        conn.commit()

        # since there is only table in the database fetchone() method is used. If there
        # more than one table, then use fetchall() method.
        for table in cur.fetchone():
            print(table)

    except (Exception, psycopg2.DatabaseError) as error:
        print(error)

    finally:
        if conn is not None:
            # close the cursor with the PostgreSQL
            cur.close()
            # close the connection with the PostgreSQL
            conn.close()
            print("The database is closed.")

gettable()