Python PostgreSQL

psycopg2

import psycopg2

sql = """
    SELECT *
    FROM test
"""

try:
    conn = psycopg2.connect(database='xx', user='root', host='localhost', port='5432', password='password')
    cur = conn.cursor()
    cur.execute(sql)          
    ver = cur.fetchall()
except:
    print "I am unable to connect to the database"

sqlalchemy

Return sql values as Pandas Dataframe

from sqlalchemy import create_engine
import pandas as pd
engine = create_engine('postgresql://root:password@localhost:5432/xx')
df = pd.read_sql_query(sql, con=engine)