Pandas read_sql with parameters
Are there any examples of how to pass parameters with an SQL query in Pandas?
psycopg2
How to install psycopg2 with “pip” on Python?
I’m using virtualenv and I need to install “psycopg2”.
Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
What’s the best way to make psycopg2 pass parameterized queries to PostgreSQL? I don’t want to write my own escpaing mechanisms or adapters and the psycopg2 source code and examples are difficult to read in a web browser.
Passing table name as a parameter in psycopg2
I have the following code, using pscyopg2:
DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
I got a lot of errors with the message :
Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
I’m trying to build a Flask app using Postgres with Docker. I’d like to connect to an AWS RDS instance of Postgres, but use Docker for my Flask app. However, when trying to set up psycopg2 it runs into an error because it can’t find pg_config. Here’s the error:
Error Installing Psycopg2 on MacOS 10.9.5
I’m trying to install Psycopg2 on my Macbook, but I am getting an error. I found a lot of the same questions on StackOverflow but no answer seems to work.
I’m using:
How to set up a PostgreSQL database in Django
I’m new to Python and Django.
How can I use psycopg2.extras in sqlalchemy?
I want to upload a huge number of entries (~600k) into a simple table in a PostgreSQL DB, with one foreign key, a timestamp and 3 float per each entry. However, it takes 60 ms per each entry to execute the core bulk insert described here, thus the whole execution would take 10 h. I have found out, that it is a performance issue of executemany() method, however it has been solved with the execute_values() method in psycopg2 2.7.