psycopg2 example in python

Shammi Anand answered on April 8, 2023 Popularity 9/10 Helpfulness 3/10

answer psycopg2 example in python

related pip psycopg2

psycopg2 example in python

Comment

import psycopg2
from psycopg2 import Error

try:
    # Connect to an existing database
    connection = psycopg2.connect(user="postgres",
                                  password="pynative@#29",
                                  host="127.0.0.1",
                                  port="5432",
                                  database="postgres_db")

    # Create a cursor to perform database operations
    cursor = connection.cursor()
    # Print PostgreSQL details
    print("PostgreSQL server information")
    print(connection.get_dsn_parameters(), "\n")
    # Executing a SQL query
    cursor.execute("SELECT version();")
    # Fetch result
    record = cursor.fetchone()
    print("You are connected to - ", record, "\n")

except (Exception, Error) as error:
    print("Error while connecting to PostgreSQL", error)
finally:
    if (connection):
        cursor.close()
        connection.close()
        print("PostgreSQL connection is closed")

Popularity 9/10 Helpfulness 3/10 Language python

Source: pynative.com

Tags: psycopg2 python

Link to this answer
Share Copy Link

Contributed on Jul 27 2023

Shammi Anand

0 Answers Avg Quality 2/10

Closely Related Answers

pip psycopg2

Comment

-1

$ pip install psycopg2

Popularity 10/10 Helpfulness 7/10 Language whatever

Source: pypi.org

Tags: pip

Link to this answer
Share Copy Link

Contributed on Apr 08 2023

Dark Donkey

0 Answers Avg Quality 2/10

psycopg2 example in python

Contents

More Related Answers

psycopg2 example in python

Closely Related Answers

pip psycopg2

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.