|
On 08/23/2013 03:29 AM, sachin kotwal
wrote:
create sample table with one or two rows then use following command to
populate data.
INSERT INTO TABLE_NAME VALUES(generate_series(1,1000000000));
Cartesian joins are also useful - especially when you want
semi-realistic data. A quick Google will get you a list of 1000
surnames and another 1000 given names. Then a cartesian join like:
select given.givenname, surnames.surname from given,surnames
will give you a million rows. Add a middle-initial column and you
quickly expand to 26-million unique names. Need more? There are
lists that go well beyond 1000 names or you can just use a full
middle name instead of an initial and get a 1,000,000,000 names (or
somewhat less if you eliminate names where first/middle/last name
are the same).
Then you can chuckle at your newly integrated society with Huang
Alexopoulos O'Leary, Albrecht Fernandez Grebenshchikov and Wekesa
Étienne Nikoleta.
Add in similar lists of common town-names and street-names along
with some generated street numbers and you will quickly exceed the
world population and/or your storage capacity.
Cheers,
Steve
|
