pg_parcel

A solution to: https://postgrespro.com/list/thread-id/1715772

It's like a very minimal subset of pg_dump, but with the addition of mysqldump's --where option.

Most options are specified via config file.

```toml columnname = "customerid" schemaname = "public" databaseurl = "postgres://localhost:15432/postgres" skiptables = [ "dailyexchange_rates" ]

[overrides]

We only want the one customer identified by --id on the command line

customers = """ select * from customers where id = :id """

The user_files table doesn't have a customer_id column, so we need to join.

userfiles = """ select userfiles.* from usersfiles join users on users.id = userfiles.userid where users.customerid = :id """ ```

License

Licensed under either of

• Apache License, Version 2.0 (LICENSE-APACHE or http://www.apache.org/licenses/LICENSE-2.0)
• MIT license (LICENSE-MIT or http://opensource.org/licenses/MIT)

at your option.

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.