Hi guys,
I got a very big database, that I need to export (dump) into a new test server.
However, this new database test server doesn't need to have all the data. I would like to have only the first 100 rows(example) of each table in my database.
I'm using pg_sample to do that, but unfortunately it doesn't work well.
It doesn't get the first 100 rows. It gets random 100 rows.
Do you guys have any idea how could I do this?
Thanks
Patrick