Re: filling database

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

<http://en.wikipedia.org/wiki/Nikoleta>