Postgres Python Query import pg vs import psycopg2

Question

I'm am working on editing a python script and I need to check if a table exists. The code works however since I am now trying to check if a table exists I need to first understand what is going on.

The code currently has:

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

and a bunch of calls to:

con.query(...)

I found this example on SO: Checking if a postgresql table exists under python (and probably Psycopg2) but I am unsure if psycopg2 is the same as pg and I can't seem to find any documentation on pg so I don't know if import pg can do con.exucute(...) simular to how psycopg2 can.

Everytime I search for pg I get documentation for psycopg2.

Anyone know the differences between the two? Can I use con.execute() and con.cursor() for pg?

pg is most likely a reference to the PyGreSQL library, which is DB-API compliant, as is psycopg2, so they should operate the same--though ordinarily you would use the execute method of a cursor object rather than of the connection object. — rd_nielsen
– rd_nielsen, Commented Aug 3, 2017 at 20:11
@rd_nielsen Does a cursor object march with an execute and store the last value of the execute? — Error - Syntactical Remorse
– Error - Syntactical Remorse, Commented Aug 3, 2017 at 20:15
The results of execute() can be obtained through the cursor object with cursor.fetchone() or cursor.fetchall(). The complete DB-API specifications are here: python.org/dev/peps/pep-0249. Whichever library you use may have some additional features; you should check that documentation also. — rd_nielsen
– rd_nielsen, Commented Aug 3, 2017 at 20:18

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

pg refers to the PyGreSQL driver:

http://www.pygresql.org/

PyGreSQL is a Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script or application.

PyGreSQL consists of two parts: the “classic” PyGreSQL interface provided by the pg module and the newer DB-API 2.0 compliant interface provided by the pgdb module.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 3, 2017 at 20:11

Clodoaldo Neto

127k30 gold badges250 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Postgres Python Query import pg vs import psycopg2

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related