Python - convert pgqueryobject to string

Question

Prelude:
Python version: 2.7.9
Pygresql version: 4.0

Problem:
I am trying to check if a sub string exists within a pgqueryobject using python.

Basically I have this in terms of code:

import pg
con = pg.connect(...)
q = con.query(...)

Where q is a pgqueryobject returned from the con.query(...)

Calling print(q) prints the entire table however converting q to a string such as:

string = str(q)
print(string)

Prints "<pg query result>".

I am trying to see if table has now instances (rows) which I planned on doing by converting the table to a string and searching for "0 rows" but I can't seem to figure out how to convert it to a string.

Is there I way I can go about doing this?

You can most likely accomplish this by saving the output of q.getresult() into a variable and then casting it into a string. pygresql.org/contents/pg/query.html#pg.Query.getresult — Andre S.
– Andre S., Commented Aug 3, 2017 at 23:21

Andre S. · Accepted Answer · 2017-08-04 13:24:47Z

1

You can most likely accomplish this by saving the output of q.getresult() into a variable and then casting it into a string.

http://www.pygresql.org/contents/pg/query.html#pg.Query.getresult

answered Aug 4, 2017 at 13:24

Andre S.

2,7422 gold badges16 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Python - convert pgqueryobject to string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related