I have tried several solutions, none worked except simplest solution: pip3 install psycopg2==2.7.5 this command worked perfectly (seems like a problem with a version)
Use the copy_from cursor method f = open(r’C:\Users\n\Desktop\data.csv’, ‘r’) cur.copy_from(f, temp_unicommerce_status, sep=’,’) f.close() The file must be passed as an object. Since you are coping from a csv file it is necessary to specify the separator as the default is a tab character
ya, i know it’s months old 😛 DB-API’s cursor appears to be closely modeled after SQL cursors. AFA resource(rows) management is concerned, DB-API does not specify whether the client must retrieve all the rows or DECLARE an actual SQL cursor. As long as the fetchXXX interfaces do what they’re supposed to, DB-API is happy. AFA … Read more
Escaping is automatic, you just have to call: cursor.execute(“query with params %s %s”, (“param1”, “pa’ram2”)) (notice that the python % operator is not used) and the values will be correctly escaped. You can escape manually a variable using extensions.adapt(var), but this would be error prone and not keep into account the connection encoding: it is … Read more
I ran into a similar problem and after a couple of hours of blood, sweat and tears, found the answer simply requires the addition of one parameter. Instead of cursor = conn.cursor() write cursor = conn.cursor(name=”my_cursor_name”) or simpler yet cursor = conn.cursor(“my_cursor_name”) The details are found at http://initd.org/psycopg/docs/usage.html#server-side-cursors I found the instructions a little confusing … Read more
psycopg2 could not translate host name
I faced the same issue on macOS and solved it by running below steps: Uninstall psycopg2: pip uninstall psycopg2 Re-install psycopg2: pip install psycopg2-binary
I made it work. This is the code: FROM python:3.8.3-slim #Image python:3.9.5-slim also works # Image python:3.9.5-slim-buster also works RUN apt-get update \ && apt-get -y install libpq-dev gcc \ && pip install psycopg2
The solution Burhan pointed out reduces the memory usage for large datasets by only fetching single rows: row = cursor.fetchone() However, I noticed a significant slowdown in fetching rows one-by-one. I access an external database over an internet connection, that might be a reason for it. Having a server side cursor and fetching bunches of … Read more