config_pkl.py

#!/usr/bin/env python2
# -*- coding: utf-8 -*-
"""
Created on Wed Jun 13 13:08:44 2018

@author: siva
"""

import psycopg2 as pg
import pandas.io.sql as psql

try:
    conn = pg.connect("dbname='CommonConfig' user='pgAdmin@atl-ditenv' host='atl-ditenv.postgres.database.azure.com' password='Postgres12'")
except:
    print "I am unable to connect to the database"

dataframe = psql.read_sql("SELECT * FROM configurationvalues", conn)

config_pkl = dataframe.to_pickle("config_pkl")