Copy data from one database table to another database table in Postgrex query [duplicate]

Question

I am using COPY public.source TO STDOUT; It is copying table source from database foo and sending it to psql shell.

I want to copy all records from the same table source of database foo to table dest in database bar. Any idea how can I do it with query like COPY public.source TO <missing solution to copy data into bar.public.dest>;

I think it's better to do this in the shell and not with sql commands, see stackoverflow.com/questions/3195125/…. — zwippie
– zwippie, Commented May 8, 2020 at 13:07
I am also to remove elixir tag since the question has nothing to do with elixir. — Aleksei Matiushkin
– Aleksei Matiushkin, Commented May 8, 2020 at 13:19

Aleksei Matiushkin · Accepted Answer · 2020-05-08 13:18:06Z

1

Here is answering the particular question about using COPY.

According to the documentation on PostgresSQL COPY,

COPY — copy data between a file and a table

which roughly means you are to do this in two steps: copy the existing data from source DB to file/stdin and then copy from file/stdin to destination DB.

answered May 8, 2020 at 13:18

Aleksei Matiushkin

121k12 gold badges109 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy data from one database table to another database table in Postgrex query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related