psycopg2

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

How to set up a PostgreSQL database in Django

I\'m new to Python and Django. I\'m configuring a Django project using a PostgreSQL database engine backend, But I\'m getting errors on each database operation. For example when I run manage.py syncd[详细]

2023-02-18 05:47 分类：问答
Using COPY FROM stdin to load tables, reading input file only once

I\'ve got a large (~60 million row) fixed width source file with ~1800 records per row. I need to load this file into 5 different tables on an instance of Postgres 8.3.9.[详细]

2023-02-14 20:09 分类：问答
Passing a python dictionary to a psycopg2 cursor

I need to call a PostgreSQL 8.4 function which requires 17 input paramters from Python. The values are stored in a dic开发者_JAVA技巧tionary. So I can write:[详细]

2023-02-14 07:58 分类：问答
Problem w/Apache2.2+psycopg2.2.2+mod_wsgi on Ubuntu

So I\'m having a problem similar to others I\'ve seen people complain about on Windows, but it appears theirs is a Windows only problem being fixed in a new version of psycopg2.[详细]

2023-02-13 17:56 分类：问答
Python: Regex question / CSV parsing / Psycopg nested arrays

I\'m having trouble parsing nested array\'s returned by Psycopg2. The DB I\'m working on returns records that can have nested array\'s as valu开发者_JAVA技巧e. Psycopg only parses the outer array of s[详细]

2023-02-10 22:32 分类：问答
Postgres Performance Tips Loading in billions of rows

I am in the middle of a project involving trying to grab numerous pieces of information out of 70GB worth of xml documents and loading it into a relational database (in this case postgres) I am curren[详细]

2023-02-10 03:03 分类：问答
Use psycopg2 to construct queries without connection

I have several occasions where I want to collect data when in the field. This is in situations where I do not always have access to my postgres database.[详细]

2023-02-08 09:19 分类：问答
psycopg2, SELECT, and schemas

I\'m trying to do a simple select statement on a table that\'s part of the \"dam_vector\" schema. The error I get is:[详细]

2023-02-07 03:55 分类：问答
how to correctly compare unicode string from psycopg2 in Python?

I have a problem with comparing a UTF-8 string obtained from PostgreSQL database: >>> db_conn = psycopg2.connect(\"dbname=\'foo\' user=\'foo\' host=\'localhost\' password=\'xxx\'\")[详细]

2023-02-05 07:28 分类：问答
Python, SQL: Set the columns read as parameter

I have a SQL query, mad in Python using Psycopg2. The query reads some columns from the arches table:[详细]

2023-01-30 05:36 分类：问答