Fast db insert with postgresql binary copy
Project description
Use pgcopy for fast data loading into PostgreSQL with binary copy.
Features
Support for many data types
Support for multi-dimensional array types
Support for schema and schema search path
Transparent string encoding
Utility for replacing entire table
Quickstart
from datetime import datetime from pgcopy import CopyManager import psycopg2 cols = ('id', 'timestamp', 'location', 'temperature') now = datetime.now() records = [ (0, now, 'Jerusalem', 72.2), (1, now, 'New York', 75.6), (2, now, 'Moscow', 54.3), ] conn = psycopg2.connect(database='weather_db') mgr = CopyManager(conn, 'measurements_table', cols) mgr.copy(records) # don't forget to commit! conn.commit()
Supported datatypes
pgcopy supports the following PostgreSQL scalar types:
bool
smallint
integer
bigint
real
double precision
char
varchar
text
bytea
date
time
timestamp
timestamp with time zone
numeric
json
jsonb
uuid
arrays
Documentation
See Also
cpgcopy, a Cython implementation, about twice as fast.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pgcopy-1.4.3.tar.gz
(12.7 kB
view hashes)
Built Distribution
pgcopy-1.4.3-py2.py3-none-any.whl
(12.5 kB
view hashes)
Close
Hashes for pgcopy-1.4.3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b678365afcab0a5a59bb168a45695ffa216ffb3aa8244a390a5c2d982f80a9b1 |
|
MD5 | b1fe86ce5c1a4122db4d12e782ac69cf |
|
BLAKE2b-256 | 35710234e0d9879e76f426e7a6b726f0fbb6be7b06a32685001e01d15a231cab |