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 100000 rows into this table. I know how to insert generate_series into coloumn ID. But I don't how to insert the Random string data into column b. Please help. Thanks. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-insert-random-character-data-into-tables-for-testing-purpose-THanks-tp5680973.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general