Re: Re: How to insert random character data into tables for testing purpose. THanks. - Mailing list pgsql-general

On Wed, May 02, 2012 at 11:03:47AM -0700, leaf_yxj wrote:
> Hi Andreas,
>
> Thanks a lot.
>
> I tried those following , they work.
>
> 1) insert into test values ( generate_series(1,100000000000),
> md5(random()::text));
>
>
> 2) create table t_random as select s, md5(random()::text) from
> generate_Series(1,5) s;

Here is a method that generates strings with a little more variability:

    SELECT
        (
                SELECT string_agg(x, '')
                FROM (
                        SELECT chr(ascii('A') + (random() * 25)::integer)
            -- reference 'b' so it is correlated and re-evaluated
                        FROM generate_series(1, 40 + b * 0)
                ) AS y(x)
        )
    FROM generate_series(1,5) as a(b);

                    string_agg
    ------------------------------------------
     JWNRUIEPJQGDVBXDJDTROFSNMKGVNAQWWEORMSHV
     KNYGOWJXBEPOJICURIQGIIDFMRXYLFUUSTCIRLGR
     PVHXEITVQKBZREFEVDDHHYCASEIKPOCFJJDNRWJJ
     HKIYONDLQGSXFUXXZGHPUKUESXRLUATBLCAAPDLG
     JEENYCLYISODDIGWGXHBYCCJECJTFUAOYECXGNWO
    (5 rows)

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +