PostgreSQL: Copy Table Data from another Table (INSERT INTO SELECT)

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing a demonstration on how to copy data from one table to another table using INSERT INTO SELECT in PostgreSQL.

This article may help the beginner of PostgreSQL, because moving or copying data within the database which is the ubiquitous task.

Use INSERT INTO SELECT statement, for this exercise:

Create two sample tables:

Insert data into tbl_A:

Copy data into tbl_B:

Check the result:

Don’t try a below option: