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
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.
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:
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.
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
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
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.
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:
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\'\")
I have a SQL query, mad in Python using Psycopg2. The query reads some columns from the arches table: