From: | Medi Montaseri <medi(at)cybershell(dot)com> |
---|---|
To: | tsmets(at)brutele(dot)be |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Test data sets |
Date: | 2002-03-27 07:06:50 |
Message-ID: | 3CA16F89.9DE8E13@cybershell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sure try this one
#!/bin/perl
for ( my $i = 0 ; $i < 100000000; $i++)
{
$buf = sprintf("John-%d:addr-%d:whatever-%d\n", $i);
print $buf;
}
save the output to a file and slurp it in
Or if you want, write a DBI code that does 10000000 inserts.
tsmets(at)brutele(dot)be wrote:
> I was wandering were I could find data sets to test some of the behavior of
> my DB.
> I basically need a few thousands records of address like data ...
> May be pumping it from the on-line telephone guides is an option but ... is
> there smthg available as such on the net ?
>
> Tx,
>
> thomas,
>
> --
> Thomas SMETS
> rue J. Wytsmanstraat 62
> 1050 Bruxelles
> yahoo-id : smetsthomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
-------------------------------------------------------------------------
Medi Montaseri medi(at)CyberShell(dot)com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Rnd | 2002-03-27 07:37:27 | Re: C Function with Arrays Question |
Previous Message | David Stanaway | 2002-03-27 07:06:37 | Re: [SQL] resetting sequence |