Re: Re: How to insert random character data into tables for testing purpose. THanks.

Hi Bruce,

Thanks. I tried. It works.
Regards.

Grace

At 2012-05-03 07:14:21,"Bruce Momjian" <bruce(at)momjian(dot)us> wrote:
>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(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +