Postgres Insert statements from stdin

Question

I have a dump file which is:

COPY public.applications (id, reference_id, lead_id) FROM stdin;

This is followed by the rows that need to be added.

Instead of copy, I want to insert these rows from stdin because copy is replacing my entire table (removing existing data in the table). I just want to add rows, not remove any existing ones.

I tried:

insert into public.applications (id, reference_id, lead_id) values FROM stdin;

But this is incorrect syntax. Whats the correct way to do this? Is there a way to tweak the copy command to only add rows and not replace the table?

copy does not removed existing rows

user330315
– user330315

2019-12-29 08:36:22 +00:00
Commented Dec 29, 2019 at 8:36 — user330315
– user330315, Commented Dec 29, 2019 at 8:36

FlyingAura · Accepted Answer · 2019-12-29 10:16:22Z

1

As currently pointed out in the comments, copy does not do replacements. Which is to say, COPY public.applications (id, reference_id, lead_id) FROM stdin; will emulate same behaviour as insert.

answered Dec 29, 2019 at 10:16

FlyingAura

1,6116 gold badges28 silver badges41 bronze badges

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

2 Comments

user248884 Over a year ago

Whats the difference then between insert and copy?

FlyingAura Over a year ago

Check stackoverflow.com/questions/32043420/…

Collectives™ on Stack Overflow

Postgres Insert statements from stdin

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related