psycopg
psycopg - Get formatted sql instead of executing
I have a piece of Python code, that interacts with a PostgreSQL 开发者_高级运维database via psycopg.[详细]
2023-03-21 19:11 分类:问答psycopg2 strange behavior
from django.db import connection q = \'some value\' sql1 = \'SELECT * FROM table WHERE field LIKE %%%s%%\' % q[详细]
2023-03-07 23:39 分类:问答PostgreSQL connection closes unexpectedly when doing a large insert
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 complet[详细]
2023-02-12 16:21 分类:问答postgresql CLUSTER command not clearing dead tuples
We have a background process (linux daemon in an infinite loop) that automatically takes all lines from csv files that are placed in a certain directory and imports them into a table. The daemon proce[详细]
2023-02-04 08:31 分类:问答海底世界是谁画的呢??
90****139 2022-03-23 21:41 1、首先准备一张纸和几支彩笔。 2、先用桔黄色在纸的下方涂一条桔黄色,表示海底的沙子。[详细]
2022-12-27 21:31 分类:问答What does Postgres do when BEGIN is run on a connection in autocommit mode?
I\'m trying to better understand the concept of \'autocommit\' when working with a Postgres (psycopg) connection.Let\'s say I have a fresh connection, set its isolation level to ISOLATION_LEVEL开发者_[详细]
2022-12-24 01:08 分类:问答