There are many scenarios where you need a lot of data created very quickly. So, let's see an example of how to create a table in Postgres with a million rows. 
Note: You need to have Docker already installed on your laptop. 
Step 1: Pull Docker image
<pre><code>docker pull postgres
</code></pre>Step 2: Run Docker Container
<pre><code>docker run -e POSTGRESS_PASSWORD=postgres --name pg1 postgress
</code></pre>pg1 -&gt; name of the container
postgres -&gt; name of the image
Step 3: Log into the container
Go to a new terminal and type the following command to log into the container pg1
<pre><code>docker exect -it pg1 psql -U postgres
</code></pre>This will take you to the psql terminal
Step 4: Create Table
<pre><code>create table temp(t int);
</code></pre>We are just creating a table with one int column. 
Step 5: Run SQL query to create a million rows
<pre><code>insert into temp select from generate_series(0,1000000);
</code></pre>Note: generate_series is a Postgresql function, 
That's it! There you have a table with a million rows.

There are many scenarios where you need a lot of data created very quickly.  So, let's see an example of how to create a table in Postgres with a million rows. 

Note: You need to have Docker already installed on your laptop. 

**Step 1: Pull Docker image**

```
docker pull postgres
``` 


**Step 2: Run Docker Container**

```
docker run -e POSTGRESS_PASSWORD=postgres --name pg1 postgress
``` 
pg1 -> name of the container

postgres -> name of the image

**Step 3: Log into the container**
Go to a new terminal and type the following command to log into the container pg1
```
docker exect -it pg1 psql -U postgres
``` 
This will take you to the psql terminal

**Step 4: Create Table**


```
create table temp(t int);
``` 
We are just creating a table with one int column. 


**Step 5: Run SQL query to create a million rows**


```
insert into temp select from generate_series(0,1000000);
``` 
Note: generate_series is a Postgresql function, 

That's it! There you have a table with a million rows.

How To Create A Postgres Table With Million Rows?

I am a Software Engineer who has been too comfortable with a corporate job for over 6 years. Now, on a mission to be a founder of a SaaS product. I write extensively about my transition here.
