#database #sql #postgres #copy

postgres-binary-copy

Support for binary-format COPY query execution with postgres

9 unstable releases (4 breaking)

0.5.0 Jul 23, 2017
0.3.1 Nov 6, 2016
0.2.1 Apr 2, 2016
0.2.0 Jan 4, 2016
0.1.0 Jul 4, 2015

#205 in Database interfaces

Download history 124/week @ 2019-06-26 162/week @ 2019-07-03 69/week @ 2019-07-10 30/week @ 2019-07-17 15/week @ 2019-07-24 32/week @ 2019-07-31 29/week @ 2019-08-07 46/week @ 2019-08-14 175/week @ 2019-08-21 30/week @ 2019-08-28 105/week @ 2019-09-04 30/week @ 2019-09-11 56/week @ 2019-09-18 76/week @ 2019-09-25 74/week @ 2019-10-02

118 downloads per month
Used in 2 crates (1 directly)

MIT license

23KB
503 lines

postgres-binary-copy

CircleCI Latest Version

Support for binary-format COPY query execution with rust-postgres.

Documentation

Example

extern crate postgres;
extern crate postgres_binary_copy;

use postgres::{Connection, TlsMode};
use postgres::types::{Type, ToSql};
use postgres_binary_copy::BinaryCopyReader;

fn main() {
    let conn = Connection::connect("postgres://postgres@localhost",
                                   TlsMode::None).unwrap();

    conn.execute("CREATE TABLE foo (id INT PRIMARY KEY, bar VARCHAR)", &[])
        .unwrap();

    let types = &[Type::Int4, Type::Varchar];
    let data: Vec<Box<ToSql>> = vec![Box::new(1i32), Box::new("hello"),
                                     Box::new(2i32), Box::new("world")];
    let data = data.iter().map(|v| &**v);
    let mut reader = BinaryCopyReader::new(types, data);

    let stmt = conn.prepare("COPY foo (id, bar) FROM STDIN (FORMAT binary)").unwrap();
    stmt.copy_in(&[], &mut reader).unwrap();
}

Dependencies

~2.5MB
~57K SLoC