Python Add Data Codes

Certainly! Here’s an example of Python code that demonstrates how to add data to a PostgreSQL database using the psycopg2 library:

import psycopg2

# Connect to the PostgreSQL database
conn = psycopg2.connect(
    host="localhost",
    database="your_database",
    user="your_username",
    password="your_password"
)

# Create a cursor
cursor = conn.cursor()

# Define the SQL statement with placeholders
sql = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"

# Set the values to be inserted
values = ("DataValue1", "DataValue2")

try:
    # Execute the SQL statement with the values
    cursor.execute(sql, values)

    # Commit the transaction
    conn.commit()

    print("Data inserted successfully.")
except (Exception, psycopg2.Error) as error:
    print("Error inserting data:", error)

# Close the cursor and the connection
cursor.close()
conn.close()

Make sure to replace the following placeholders with your own values:

• localhost: The hostname or IP address of your PostgreSQL server.
• your_database: The name of the PostgreSQL database.
• your_username: The username for accessing the database.
• your_password: The password for accessing the database.
• your_table: The name of the table where you want to add data.
• column1, column2: The names of the columns in the table where you want to add data.
• 'DataValue1', 'DataValue2': The values you want to add to column1 and column2 respectively.

This code uses the psycopg2 library to establish a connection to the PostgreSQL database, create a cursor, execute an SQL INSERT statement with placeholders, provide the values to be inserted, commit the transaction, and handle any potential exceptions that may occur. The code also outputs a success message if the data insertion is successful. Make sure to install the psycopg2 library before running this code by executing pip install psycopg2 in your Python environment.