2016-10-19 13:39 GMT+13:00 Michael Paquier <michael.paqu...@gmail.com>:
> On Wed, Oct 19, 2016 at 9:24 AM, Patrick B <patrickbake...@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.
