Is it possible to back up a PostgreSQL
database with only a fraction of the data (1000 Rows from each table)?
I am able to back up that database using pg_dump
. In some case I need db with minimum data.
pg_dump --host=localhost --port=5432 --username=postgres --password
--column-inserts --schema=test testdb > test_backup.sql
How can I modify the above command to take the back up with 1000 number of data??