How do I query a postgres-db view with psycopg2?

Question

I've got psycopg2 running and I can successfully query tables of my database. This is a working example of querying the table my_table:

import psycopg2
try:
  conn_string="dbname='my_dbname' user='user' host='localhost' password='password'"
  print "Connecting to database\n->%s" % (conn_string)

  conn = psycopg2.connect(conn_string)
  print "connection succeeded"
except:
  print "no connection to db"

cur = conn.cursor()

try:
  cur.execute(""" SELECT *  from my_table; """)

  records = cur.fetchall()
  cur.close()

except:
  print "Query not possible"

Question: How can I query a view, let it be called my_view, within the same database my_dbname?

Martijn Pieters · Accepted Answer · 2012-11-09 12:55:27Z

3

The same way you'd query a table. From a SELECT point of view, a VIEW is the exact same thing as a TABLE:

cur.execute("SELECT * from my_view")

Note that you generally do not want to use a black except:. Catch a specific exception if you have to, but you are usually better off not catching the exception at all rather than block all feedback on errors as you've done here.

edited Nov 9, 2012 at 12:55

answered Nov 9, 2012 at 12:21

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

3 Comments

zehpunktbarron Over a year ago

Thank you for your response. The problem I actually have has nothing to to whether I query a table or a view. The view I created within my database had an other owner (not "user" as in "conn_string"). So after changing user in "conn_string" the query works.

Martijn Pieters Over a year ago

@C.B.: I suspected there might be something else going on but your question didn't include any detail. Updated my answer with a remark towards your exception handling, which would not have helped you diagnose this problem.

WestCoastProjects Over a year ago

for not "swallowing" exceptions +1

Collectives™ on Stack Overflow

How do I query a postgres-db view with psycopg2?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related