This is a script to connect PostgreSQL with Python3

Connection between Python and PostgreSQL

import psycopg2 as pg

conn = pg.connect(user="postgres",
                  password="root",
                  host="localhost",
                  port="5432",
                  database="python_postgres")

try:
  with conn as cn:
    with cn.cursor() as cursor:
      sentence = ""
except(Exception) as e:
  print("Error: unable to fetch data -", e)
finally:
  conn.close()