Re: test data

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: "'Andy Colson'" <andy(at)squeakycode(dot)net>, "'PostgreSQL general'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: test data
Date: 2011-03-05 03:28:49
Message-ID: 06fa01cbdae5$71a696a0$54f3c3e0$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You could try online yellow-pages and extract names from the HTML; I did
this a long time ago for some reason. There may be copyright issues to
consider but if you are using it for internal test data.......

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Andy Colson
Sent: Friday, March 04, 2011 8:42 PM
To: PostgreSQL general
Subject: [GENERAL] test data

I seem to like having more realistic test data, to that end I have collected
a large number of first names and last names over the last few years. Now
I'd kinda like to collect business names. I've been searching around and
cannot find anything.

I was wondering if anyone had any business names, or a place where I might
download a bunch. I'm not interested in addresses or phone numbers or
anything other than its name.

In return I'd be happy to share my firstname/lastname list.

OR -- anybody know where I could download a phone book?

OR -- anybody know of a big database with lots of rows?

(I played with the us census tiger data... but its to geographic points, not
fun to play with) (And not wikipedia, its mostly just text, and not fun to
play with)

Thanks,

-Andy

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

  • test data at 2011-03-05 01:41:48 from Andy Colson

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-03-05 06:52:06 Re: invalid byte sequence
Previous Message Adrian Klaver 2011-03-05 03:19:51 Re: database is bigger after dump/restore - why? (60 GB to 109 GB)