Selecting data from schema based table in Postgresql using psycopg2

Question

I'm a newbie in Python and would like to select some data from postgreSQL database using python psycopg2 API.

The table I'm selecting is inside a schema dl(dl.products),so when I write the code

Conn=   psycopg2.connect(host="localhost",database="postgres",user="postgres", password="postgres")
  Cur=conn.cursor()
  Cur.execute("select * from dl.products")

It's showing the error relation dl.products doesn't exists.

Can anyone show me an example on how to do this?

Sandeep · Accepted Answer · 2019-04-28 21:10:34Z

3

Please try the below code,

  Query = """select * from dl."products";"""
   cursor.execute(Query)
   print("Selecting rows from test table using cursor.fetchall")
   row = cursor.fetchone()
   while row is not None:
        print(row)
        row = cursor.fetchone()
   print("Print each row and it's columns values")

answered Apr 28, 2019 at 21:10

Sandeep

7312 gold badges11 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Selecting data from schema based table in Postgresql using psycopg2

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related