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

2012-05-03 Thread yxj
Hi Bruce, Thanks. I tried. It works. Regards. Grace At 2012-05-03 07:14:21,"Bruce Momjian" 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(

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

2012-05-02 Thread Bruce Momjian
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 > ge

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

2012-05-02 Thread leaf_yxj
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: