psycopg2 with Postgres fetchall works but not execute

Question

I am trying to execute some Postgres queries with psycopg2.

import psycopg2

conn = psycopg2.connect(
    host="test.postgres.database.azure.com",
    database="postgres",
    user="test",
    password="test")
cur = conn.cursor()

sql = "select site_panel from test.ws_sites"

cur.execute(sql)
rows =  cur.fetchall()

The query above works well and returns the data but the following query does not delete the table as intended.

 cur.execute ("DROP TABLE IF EXISTS test.ws_sites")

Anything wrong I'm doing here?

klin · Accepted Answer · 2022-06-17 17:37:01Z

3

A query that modifies table data or schema structure needs to be committed:

cur.execute ("DROP TABLE IF EXISTS test.ws_sites")
conn.commit()

Alternatively, place

conn.autocommit = True

after creating the connection.

answered Jun 17, 2022 at 17:37

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

psycopg2 with Postgres fetchall works but not execute

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related