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 |