psycopg2

相关标签：javascript jquery android 多少钱 iPhone

INSERT INTO and String Concatenation with Python

I have hit a major speed bump in inserting data in to my DB. You can see from the code below that I am simply building the SQL statement to pass in to the execute command. The values are correct and a[详细]

2023-03-08 07:55 分类：问答
Got an error while connecting to database

I am unable to connected to database in linux using psycopg2. I have postgresql installed in linux and my code is:[详细]

2023-03-05 15:06 分类：问答
getting recarray into postgres using psycopg2

Just would like to get a quick idea on the best, meaning least coding, way to get lots of data in recarray into postgres using psycopg2. I have seen some stuff using cast but really I thought it would[详细]

2023-03-04 15:20 分类：问答
multiprocessing + psycopg2 zombie children

I am try开发者_JAVA技巧ing to insert and update a few million rows using psycopg and multiprocessing. Going by the documentation found in http://initd.org/psycopg/docs/usage.html#thread-and-process-sa[详细]

2023-02-28 16:45 分类：问答
Import psycopg2 from python script

I am trying to use psycopg2 installed by easy_install in a python script. This is the header of my script :[详细]

2023-02-24 12:47 分类：问答
Efficient way to run select query for millions of data

I want to run various select query 100 million times and I have aprox. 1 million rows in a table. Therefore, I am looking for the fastest method to run all these select queries.[详细]

2023-02-22 20:05 分类：问答
Can't connect the postgreSQL with psycopg2

It\'s the first time that I can\'t find the answer about some tech problems Here\'s my problems: >> conn=psycopg2.connect(database=\"mydb\", user=\"postgres\", password=\"123\",port=5432)[详细]

2023-02-21 05:54 分类：问答
psycopg2: Will PostgreSQL store a copy of a table on disk if it has run out of memory

I am running the following query on 489 million rows (102 gb) on a computer with 2 gb of memory: select * from table order by x, y, z, h, j, l;[详细]

2023-02-20 18:07 分类：问答
Postgres - Sql - PgSql Cheatsheets

I am developing some python queries using psycopg and I was looking for some good cheat sheet. Which Post开发者_运维知识库gres - Sql - PgSql Cheatsheets do you use regularly during DB development?I j[详细]

2023-02-18 21:01 分类：问答
Where can I download binary eggs with psycopg2 for Windows?

I\'m looking for binary eggs with psycopg2\'s binaries for Windows but can\'t find any. On http://initd.开发者_如何转开发org/psycopg/download/ there\'s only source package and link to Windows port of[详细]

2023-02-18 15:59 分类：问答