Re: Test data sets

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
-------------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  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