Postgres Pro
Downloads
Home   >   mailing lists

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

From leaf_yxj
Subject How to insert random character data into tables for testing purpose. THanks.
Date
Msg-id 1335975292838-5680973.post@n5.nabble.com
Whole thread Raw
Responses Re: How to insert random character data into tables for testing purpose. THanks.
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: leaf_yxj
Date:
Subject: How to insert random character data into tables.
Next
From: Chris Angelico
Date:
Subject: Re: Uppercase to lowercase trigger?