pg_sample
pg_sample copied to clipboard
mla
PostgreSQL utility for creating a small, sample database from a larger one
**Example:** `./pg_sample --ordered --flip ` ```bash ./pg_sample --help --ordered Select from the table records after ordering the records by primary key value. --flip When passed as an option, the records...
Is it possible to export data with `insert` statements over `COPY`?
Would it be possible to select rows based in very simple criteria? I mean, I have a database with a very large table and I would like to select all...
I'm trying to dump a Django project, so I did `--limit="django_* = *,table_foo=15,*=15"`, which I was expecting to dump 15 rows from `foo` and all rows from all the tables...
Say I had tables school, class. If I dumped 100 classes from the class table and it depends on schools. Can I then put a limit such as school =...
Hi, I'm attempting to run this on a read-only replica of a database and I noticed that this is failing because of the following line. https://github.com/mla/pg_sample/blob/27c29168dce6adb81fc9f6bfac8d686ebcad84b2/pg_sample#L488 I noticed here that...
Hello again :) i wondered if it would make sense to extend the functionality of the limit parameter in a way, that wildcards are permitted in relation names. Example: limit="meta.*=0"...
Hello, Thank you for the handful tool Is there any opportunity to use wildcards like * and ? in table names? I can use * after schema name, but cannot...
Using --schema flag for having dump schema level granularity improved per schema filtering, make COPY less error prone changed DELIMITER, QUOTE and ESCAPE for better handling of complicated data type...
