I'm a beginner at python. We use this code to execute SQL commands. cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (100, "abcdef")) I wonder is this prepared statement or just a cli...

This might be a rather silly question but what am I doing wrong here? It creates the table but the INSERT INTO doesn't work, I guess I'm doing something wrong with the placeholders? conn = psycopg...

I use psycopg2 to connect to PostgreSQL on Python and I want to use connection pooling. I don't know what should I do instead commit() and rollback() when I execute INSERT query. db = pool.Simple...

I have the following postgreSql table stock, there the structure is following with column insert_time has a default value now() | column | pk | type | +-------------+-----+-----------+ | id | yes ...

What would be the equivalent of psycopg's cur.mogrify on mysql? From: http://initd.org/psycopg/docs/cursor.html mogrify(operation[, parameters]) Return a query string after arguments binding. ...

I have a pretty simple snippet of Python code to run a Postgres query then send the results to a dashboard. I'm using psycopg2 to periodically run the same query. Let's not worry about the looping ...

So I am building a query based on user input in flask with this code: if empty_indic_form.validate_on_submit(): query='select name, year, value, display_name from literal inner join ent on ent_i...

I have an application that parses and loads data from csv files into a Postgres 9.3 database. In serial execution insert statements/cursor executions work without an issue. I added celery in the m...

This string: "CREATE USER %s PASSWORD %s", (user, pw) always gets expanded to: CREATE USER E'someuser' PASSWORD E'somepassword' Can anyone tell me why? Edit: The expanded string above is the...

The psycopg docs state: "Psycopg connections are not green thread safe and can’t be used concurrently by different green threads. Trying to execute more than one command at time using one cursor pe...

I am currently analyzing a wikipedia dump file; I am extracting a bunch of data from it using python and persisting it into a PostgreSQL db. I am always trying to make things go faster for this fil...

I'm populating a PostgreSQL table with ~11.000.000 rows that have been selected before from another database. I'm using Python and psycopg2. The whole process takes an estimated 1.5 hours to comple...

I have a piece of Python code, that interacts with a PostgreSQL database via psycopg. All literature warns against doing sql formatting by oneself, and recommends letting the driver do it. E.g.: ...