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

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;

Thanks.
Regards.

Grace

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-insert-random-character-data-into-tables-for-testing-purpose-THanks-tp5680973p5681242.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.