[GENERAL] How to insert random character data into tables.
-- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-insert-random-character-data-into-tables-tp5680962.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to insert random character data into tables for testing purpose. THanks.
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 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to insert random character data into tables for testing purpose. THanks.
leaf_yxj leaf_...@163.com 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 I don't how to insert the Random string data into column b. something like: test=# create table t_random as select s, md5(random()::text) from generate_Series(1,5) s; SELECT 5 Time: 163,624 ms test=*# select * from t_random ; s | md5 ---+-- 1 | ef82dcb3e8465fa9a7494c569dfa093f 2 | ad6ae62bb4a49c7889aba0bfcba224ff 3 | 27717d30d8cf069b3129853d90ae5035 4 | 530c200678711a414e000c60e73286bd 5 | 2b2c3692da1b60760ff95d41cdf9b82d (5 rows) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) If I was god, I would recompile penguin with --enable-fly. (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general