ejemplo simple:

import psycopg2
 
cnx = psycopg2.connect( user="<usuario>",
                        password="<password>",
                        host="<host>",
                        port="<port>",
                        database="<db>" )
 
print("Informarción PostgreSQL Server:")
print(cnx.get_dsn_parameters(), "\n")

Ejemplo simple con Try Catch:

import psycopg2
 
try:
 
  cnx = psycopg2.connect( user="<usuario>",
                        password="<password>",
                        host="<host>",
                        port="<port>",
                        database="<db>" )
 
  print("Informarción PostgreSQL Server:")
  print(cnx.get_dsn_parameters(), "\n")
 
except:
 
  print("No se pudo conectar")

• https://pynative.com/python-postgresql-tutorial/
• https://cloud.google.com/spanner/docs/pg-psycopg2-connect?hl=es-419
• https://www.datacamp.com/tutorial/tutorial-postgresql-python
• https://www.psycopg.org/docs/usage.html
• https://wiki.postgresql.org/wiki/Psycopg2_Tutorial

import psycopg2
 
try:
 
  cnx = psycopg2.connect( user="<usuario>",
                        password="<password>",
                        host="<host>",
                        port="<port>",
                        database="<db>" )
 
  print("Informarción PostgreSQL Server:")
  print(cnx.get_dsn_parameters(), "\n")
 
  cursor = cnx.cursor()
  cursor.execute("insert into usuarios( usuario, password, nombrecompleto) values('ABAN3', 'EBEN', 'ABAN BANBIN')")
 
  cnx.commit()
 
except:
 
  print("No se pudo conectar")

• https://stackoverflow.com/questions/19235686/psycopg2-insert-into-table-with-placeholders
• https://neon.com/postgresql/postgresql-python/insert

Store procedure:

• https://www.geeksforgeeks.org/postgresql/how-to-write-a-normal-select-procedure-in-postgresql/
• https://neon.com/postgresql/postgresql-python/postgresql-python-call-postgresql-functions

Existen dos formas:

• cursor.fetchone()
• cursor.fetchall()

• https://neon.com/postgresql/postgresql-python/query