← Back to branch summary

~psycopg/psycopg/2.0.x

« back to all changes in this revision

Viewing changes to sandbox/test_copy2.py

  • Committer: Federico Di Gregorio
  • Date: 2009-04-20 22:38:09 UTC
  • Revision ID: fog@erin-20090420223809-y59bb142mo3vadnw
Better detection of PostgreSQL version

Show diffs side-by-side

added added

removed removed

Lines of Context:
sandbox/test_copy2.py
 
1
import psycopg2
 
2
 
 
3
dbconn = psycopg2.connect(database="test",host="localhost",port="5432")
 
4
query = """
 
5
        CREATE TEMP TABLE data (
 
6
            field01 char,
 
7
            field02 varchar,
 
8
            field03 varchar,
 
9
            field04 varchar,
 
10
            field05 varchar,
 
11
            field06 varchar,
 
12
            field07 varchar,
 
13
            field08 varchar,
 
14
            field09 numeric,
 
15
            field10 integer,
 
16
            field11 numeric,
 
17
            field12 numeric,
 
18
            field13 numeric,
 
19
            field14 numeric,
 
20
            field15 numeric,
 
21
            field16 numeric,
 
22
            field17 char,
 
23
            field18 char,
 
24
            field19 char,
 
25
            field20 varchar,
 
26
            field21 varchar,
 
27
            field22 integer,
 
28
            field23 char,
 
29
            field24 char
 
30
        );
 
31
        """
 
32
cursor = dbconn.cursor()
 
33
cursor.execute(query)
 
34
 
 
35
f = open('test_copy2.csv')
 
36
cursor.copy_from(f, 'data', sep='|')
 
37
f.close()
 
38
 
 
39
dbconn.commit()
 
40
 
 
41
cursor.close()
 
42
dbconn.close()
 
43