Pattern you always want to generate Generate random text in PostgreSQL:
CREATE TABLE "mytable" ("i" INTEGER, "j" INTEGER);
INSERT INTO "mytable" SELECT i, i*2 FROM generate_series(1, 10) as s(i);

Ancestors (14)

  1. PostgreSQL function
  2. PostgreSQL
  3. SQL implementation
  4. SQL
  5. Relational database management system
  6. Relational database
  7. Type of database
  8. Database
  9. Software
  10. Computer
  11. Information technology
  12. Area of technology
  13. Technology
  14. Home

View article source

Discussion (0)

New discussion

There are no discussions about this article yet.

Articles by others on the same topic (0)

There are currently no matching articles.
See all articles in the same topic Create my own version