Breaking News: Grepper is joining You.com. Read the official announcement!

python postgresQL select table

Long Lark answered on February 24, 2022 Popularity 6/10 Helpfulness 5/10

answer python postgresQL select table

python postgresQL select table

Comment

import psycopg2

try:
    connection = psycopg2.connect(user="sysadmin",
                                  password="pynative@#29",
                                  host="127.0.0.1",
                                  port="5432",
                                  database="postgres_db")
    cursor = connection.cursor()
    postgreSQL_select_Query = "select * from mobile"

    cursor.execute(postgreSQL_select_Query)
    print("Selecting rows from mobile table using cursor.fetchall")
    mobile_records = cursor.fetchall()

    print("Print each row and it's columns values")
    for row in mobile_records:
        print("Id = ", row[0], )
        print("Model = ", row[1])
        print("Price  = ", row[2], "\n")

except (Exception, psycopg2.Error) as error:
    print("Error while fetching data from PostgreSQL", error)

finally:
    # closing database connection.
    if connection:
        cursor.close()
        connection.close()
        print("PostgreSQL connection is closed")

Popularity 6/10 Helpfulness 5/10 Language sql

Source: pynative.com

Tags: postgresql python select sql

Link to this answer
Share Copy Link

Contributed on Feb 24 2022

Long Lark

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

python postgresQL select table

Contents

More Related Answers

python postgresQL select table

Grepper

Documentation

Social

Legal

Contact

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