Re: Huge sample dataset for testing. - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Huge sample dataset for testing.
Date
Msg-id 20090428123615.GE13320@a-kretschmer.de
Whole thread Raw
In response to Re: Huge sample dataset for testing.  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
In response to Tim Uckun :
> Thanks I'll try something like that.
>
> I guess can create some random dates or something for other types of fields
> too.

Sure, dates for instance:

test=*# select (current_date + random() * 1000 * '1day'::interval)::date from generate_series(1,10);
    date
------------
 2010-12-11
 2009-06-20
 2009-08-13
 2011-10-17
 2011-10-09
 2010-10-13
 2010-02-04
 2011-03-04
 2012-01-17
 2010-11-18
(10 rows)


>
> I was hoping there was already something like this available though because
> it's going to take some time to create relations and such.

You want really download a database or table with 100 million rows?


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Huge sample dataset for testing.
Next
From: Jasen Betts
Date:
Subject: Re: postgres only in local socket