How to create and insert n rows of test data of random strings into table in Postgres with SQL? [duplicate]

Question

In SQL in Postgres, how do I create and insert n number of rows of test data with random strings length x?

e.g.,

CREATE TABLE my_table (my_text_column TEXT);
-- now insert n rows of test data into my_table, with random
-- strings of length x for my_text_column

Community · Accepted Answer · 2017-05-23 12:31:44Z

4

The answer is already available here

create table yourtable as select descr from 
          (SELECT generate_series(1,10) AS id,md5(random()::text) AS descr)s;

CommunityBot

11 silver badge

answered Apr 29, 2016 at 15:24

cableload

4,4156 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1