pgcopy
| Crates.io | pgcopy |
| lib.rs | pgcopy |
| version | 0.0.2 |
| created_at | 2019-01-31 20:18:04.299899+00 |
| updated_at | 2019-02-07 17:03:01.027773+00 |
| description | PostgreSQL binary COPY format generator |
| homepage | https://github.com/svartalf/rust-pgcopy |
| repository | https://github.com/svartalf/rust-pgcopy.git |
| max_upload_size | |
| id | 111874 |
| size | 41,106 |
svartalf (svartalf)
documentation
https://docs.rs/rust-pgcopy/
README
pgcopy
Write data into a PostgreSQL COPY WITH BINARY format, somewhat faster way to insert a lot of entries into database
that plain text or CSV.
Supported data types
| PostgreSQL type | Rust equivalent | |
|---|---|---|
| ✔ | smallint | i16 |
| ✔ | integer | i32 |
| ✔ | bigint | i64 |
| decimal | ||
| numeric | ||
| ✔ | real | f32 |
| ✔ | double | f64 |
| char | char |
|
| ✔ | char varying | &str |
| ✔ | text | &str |
| ✔ | bytea | &[u8] |
| ✔ | timestamp | chrono::naive::NaiveDateTime |
| ✔ | timestamp with time zone | chrono::DateTime |
| ✔ | date | chrono::Date or chrono::naive::NaiveDate |
| ✔ | time | chrono::naive::NaiveTime |
| interval | ||
| ✔ | boolean | bool |
| cidr | ||
| inet | ||
| ✔ | macaddr | [u8; 6] or eui48::MacAddress |
| ✔ | macaddr8 | [u8; 6], [u8; 8] or eui48::MacAddress |
| ✔ | uuid | [u8; 16] or uuid::Uuid |
| xml | ||
| json | ||
| jsonb | ||
| array |