How can I generate a range of numbers with text using Postgresql

Question

I want to create a table 'content' with the column name 'info' with each line inserted with the text "Record number 1" up to "Record number 100".

I've created the table and column so far with this code but I'm not sure how to generate the range:

CREATE TABLE content (info TEXT);

Akhilesh Mishra · Accepted Answer · 2021-05-29 03:48:04Z

4

This can be done using generate_series in following way.

  create table content (info text); 

  insert into content
  select concat('Record number ', generate_series(1, 100));  

  select * from content;

Akhilesh Mishra

6,1503 gold badges20 silver badges37 bronze badges

answered May 29, 2021 at 3:14

Harsh Gundecha

1,23511 silver badges16 bronze badges

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

1 Answer 1