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

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to insert random character data into tables for testing purpose. THanks.
Date: 2012-05-02 16:14:52
Message-ID: 1335975292838-5680973.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-05-02 16:30:20 Re: Uppercase to lowercase trigger?
Previous Message leaf_yxj 2012-05-02 16:10:43 How to insert random character data into tables.