Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Bruce,
 
Thanks. I tried. It works.
Regards.
 
Grace



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux