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

2012-05-02 Thread Andreas Kretschmer
leaf_yxj wrote: > Hi Guys, I want to insert the random character data into tables for testing > purpose. > I created a table as follows : > > create table test ( id int, b char(100)); > > I need to insert 10 rows into this table. I know how to insert > generate_series into coloumn ID. But

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

2012-05-02 Thread leaf_yxj
Hi Guys, I want to insert the random character data into tables for testing purpose. I created a table as follows : create table test ( id int, b char(100)); I need to insert 10 rows into this table. I know how to insert generate_series into coloumn ID. But I don't how to insert the Random