How To Insert Random Data In PostgreSQL

Faruk Erdem November 4, 2018 MSSQL

In some cases, we may want to increase the size of the database by inserting random data into the database.

In the script below, we create a table named t_random.

CREATE TABLE t_random AS SELECT s, md5(random()::text) FROM generate_Series(1,5) s;

1	CREATE TABLE t_random AS SELECT s, md5(random()::text) FROM generate_Series(1,5) s;

We increase the size of the table by inserting some data after the table is created.

INSERT INTO t_random VALUES (generate_series(1,1000000000), md5(random()::text));

1	INSERT INTO t_random VALUES (generate_series(1,1000000000), md5(random()::text));

We can learn the size of the table with the help of the following command.

SELECT pg_size_pretty(pg_relation_size('t_random'));

1	SELECT pg_size_pretty(pg_relation_size('t_random'));

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux