Copy PostgreSQL data to the same table, replacing some fields

Question

I have a table with three columns:

id, 
name:string, 
location:int

I need to copy all records with location = 14 to the same table, but I need the copies to change locations to 15. Of course, id's must be changed too, to their autoincrement values.

How do I do that in PostgreSQL?

u want to update location 14 to 15 ??u can use update query

GaneshP
– GaneshP

2014-06-24 12:41:33 +00:00
Commented Jun 24, 2014 at 12:41 — GaneshP
– GaneshP, Commented Jun 24, 2014 at 12:41
@GaneshP No he can't just update because he needs new ids

Clodoaldo Neto
– Clodoaldo Neto

2014-06-24 12:46:06 +00:00
Commented Jun 24, 2014 at 12:46 — Clodoaldo Neto
– Clodoaldo Neto, Commented Jun 24, 2014 at 12:46
No, I need to copy them, leaving original records intact.

shal
– shal

2014-06-24 13:07:35 +00:00
Commented Jun 24, 2014 at 13:07 — shal
– shal, Commented Jun 24, 2014 at 13:07

Clodoaldo Neto · Accepted Answer · 2014-06-24 13:10:00Z

3

insert into t (name, location)
select name, 15
from t
where location = 14

edited Jun 24, 2014 at 13:10

answered Jun 24, 2014 at 12:42

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

1 Comment

shal Over a year ago

I don't need to delete it, I need to copy them, leaving original records intact.

Collectives™ on Stack Overflow

Copy PostgreSQL data to the same table, replacing some fields

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related