Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Generating sample data - Mailing list pgsql-general

From Steve Crawford
Subject Re: [GENERAL] Generating sample data
Date
Msg-id CAEfWYyyLpFK8Mq3FeKUOP30fogyjBbpnTSZ_7YUuMCfwhfqfjg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Generating sample data  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view

On Tue, Dec 27, 2016 at 12:01 PM, Steve Crawford <scrawford@pinpointresearch.com> wrote:
You could start here:

I have rolled my own on occasion by just pulling some public lists of most common given names and family names and toing a full-join. Same for city, streets, etc.

-Steve

On Tue, Dec 27, 2016 at 11:23 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
  My previous databases used real client (or my own) data; now I want to
generate sample data for the tables in the two applications I'm developing.
My web search finds a bunch of pricey (IMO) commercial products.

  Are there any open source data generators that can provide sample data
based on each table's schema?

TIA,

Rich




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


Sorry, "doing" a full-join. Which also leads to lots of fun cross-cultural names like "Muhammad Wang" and "Santiago O'Leary".

Cheers,
Steve

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: [GENERAL] Generating sample data
Next
From: Rich Shepard
Date:
Subject: Re: [GENERAL] Generating sample data