bin+lib pgarchive

Read PostgreSQL custom format archives

4 releases (2 breaking)

0.3.0 Oct 4, 2023
0.2.0 Oct 3, 2023
0.0.1 Oct 2, 2023
0.0.0 Oct 2, 2023

#1202 in Database interfaces

MIT license

42KB
887 lines

Parser for PostgreSQL dumps in custom format

This crate allows inspecting the contents of a PostgreSQL backup as made using pg_dump -Fc or pg_dump --format=custom, and provides direct access all raw table data. This can be useful if you do not trust the SQL statements embedded in the dump, or if you want to process data without loading it into a database.

use std::fs::File;
use pgarchive::Archive;

let mut file = File::open("tests/test.pgdump").unwrap();
match Archive::parse(&mut file) {
    Ok(archive) => println!("This is a backup of {}", archive.database_name),
    Err(e) => println!("can not read file: {:?}", e),
};

lib.rs:

Parser for PostgreSQL dumps in custom format

This crate allows inspecting the contents of a PostgreSQL backup as made using pg_dump -Fc or pg_dump --format=custom, and provides direct access all raw table data. This can be useful if you do not trust the SQL statements embedded in the dump, or if you want to process data without loading it into a database.

use std::fs::File;
use pgarchive::Archive;

let mut file = File::open("tests/test.pgdump").unwrap();
match Archive::parse(&mut file) {
    Ok(archive) => println!("This is a backup of {}", archive.database_name),
    Err(e) => println!("can not read file: {:?}", e),
};

Dependencies

~1.4–2.2MB
~39K SLoC