On Wed, Oct 19, 2016 at 9:24 AM, Patrick B <patrickbakerbr@gmail.com> wrote: > 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.
Why aren't 100 random rows enough to fulfill what you are looking for? What you are trying here is to test the server with some sample data, no? In this case, having the first 100 rows, or a set of random ones should not matter much (never tried pg_sample to be honest). -- Michael
Actually it does matter because there is some essential data that has to be in there so the code can work.