Connection to Postgres from Heroku

import os
import psycopg2
from urllib.parse import urlparse

#https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-python

p_url = urlparse(os.environ["DATABASE_URL"])

url = urlparse(p_url)

conn = psycopg2.connect(
    database=url.path[1:],
    user=url.username,
    password=url.password,
    host=url.hostname,
    port=url.port
)


print('Connected to postgres.')

# Todo do database stuff