Re: [GENERAL] 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 br...@momjian.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 (

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

Hi Andreas, Thanks a lot. I tried those following , they work. 1) insert into test values ( generate_series(1,1000), md5(random()::text)); 2) create table t_random as select s, md5(random()::text) from generate_Series(1,5) s; Thanks. Regards. Grace -- View this message in context:

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

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,1000), md5(random()::text)); 2) create table t_random as select s, md5(random()::text) from