Pythons

connect.py.-

import psycopg2

con = psycopg2.connect(host='localhost', port='5432',dbname='demo', user='openpg', password='openpgpwd')
cur = con.cursor()
cur.execute("SELECT version()")
ver = cur.fetchone()
print(ver)

connect2.py

import psycopg2.extras

con = psycopg2.connect(host='localhost', port='5432',dbname='demo', user='openpg', password='openpgpwd')
cur = con.cursor(cursor_factory=psycopg2.extras.DictCursor)
query = ("SELECT * FROM res_company")
cur.execute(query)
rows = cur.fetchall()
for row in rows:
    print(dict(row))
cur.close()

update.py

import psycopg2

conn = psycopg2.connect(host='localhost', port='5432',dbname='demo', user='openpg', password='openpgpwd')
cur = conn.cursor()
query = "UPDATE res_company SET name='NEW NAME TEST' WHERE id=1"
print(query)
cur.execute(query)
conn.commit()
conn.close()