Conexão

import psycopg2

#Dicionário de conexão
connString = {
    'dbname' : 'postgres',
    'user' : 'postgres',
    'pass' : 'adm',
    'port' : '5432'
}

con = psycopg2.connect('dbname=%s user=%s password=%s' %
(
    connString['dbname'],
    connString['user'],
    connString['pass']
))