Python: PostgreSQL
connection
import psycopg2 from psycopg2 import Error, connection, cursor conn: connection | None = None c1: cursor | None = None try: conn = psycopg2.connect(host='localhost', port=5432, user='postgres', password='postgres', database='entail') c1 = conn.cursor() print(conn.get_dsn_parameters()) c1.execute('select version()') print(c1.fetchall()) except (Exception, Error) as e: print(e) finally: if connection and not connection.closed: if not c1.closed: c1.close() conn.close()
create table