We have a relatively big production postgres based db: ~20GB. The PostgreSQL database is hosted on heroku.
I would like to copy a small subset of the table data to my local database so I can run some tests on them without having to work on production.
I do not want to generate sample data myself, but rather use the data which already exists in the production environment.
~100 rows from each table in the database would be sufficient. Is there an easy way to accomplish this?