Simple use of PostgresSql in Python using psycopg2

script.py

import psycopg2

#Create Connection to PostgreSQL

connection = psycopg2.connect(
            host = "localhost",
            database="system",
            user = "<your user name>",
            password = "<your password>")

# Open a cursor to perform database operations
cursor = connection.cursor()
#execute your query (insert in users table)
cursor.execute("insert into users (id, email, password) values (%s, %s, %s)", (1, "[email protected]", "root") )

#execute your query (get data from users table)
cursor.execute("select id, email, password from users")

#fetchall=> Fetch all (remaining) rows of a query result, returning them as a list of tuples. An empty list is returned if there is no more record to fetch
rows = cursor.fetchall()

for row in rows:
    print(row)

#Commit any pending transaction to the database.
connection.commit()

#close the cursor
cursor.close()

#close the connection
connection.close()