How do I...Copy data from table to another in postgres using copy command

Question

1.00/5 (1 vote)

See more:

Hi All,

We use copy command to copy data of one table to a file outside database.

Is it possible to copy data of one table to another table using command.

If yes can anyone please share the query.

Or is there any better approach like we can use pg_dump or something like that.

Appreciate your help.

Regards,
Mohit

Posted 7-Jul-15 19:45pm

Member 11802905

Updated 7-Jul-15 19:48pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-07-07T20:09:00

Solution 1

If you are copying between two tables in the same database, you can do something like

SQL

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

Example:

SQL

INSERT INTO table2
SELECT * FROM table1;

Check this tutorial-
SQL INSERT INTO SELECT Statement[^]

Hope, it helps :)

Posted 7-Jul-15 20:09pm

Suvendu Shekhar Giri

Comments

Member 11802905 8-Jul-15 2:27am

Thanks Suvendu for ur reply but I just want to know is it possible to copy data from one table to another using copy command.

Suvendu Shekhar Giri 8-Jul-15 2:41am

I believe, "NO". As per the official documentation of PostgreSQL, COPY is used to copy data between a file and a table.
Check here PostgreSQL COPY

Member 11802905 8-Jul-15 5:28am

Thanks

How do I...Copy data from table to another in postgres using copy command

1 solution

Solution 1

Add your solution here

Preview 0

How do I...Copy data from table to another in postgres using copy command

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us