Re: Huge sample dataset for testing.

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: Huge sample dataset for testing.
Дата
Msg-id 20090428123615.GE13320@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: Huge sample dataset for testing.  (Tim Uckun <timuckun@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: Huge sample dataset for testing.
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: postgres only in local socket