copy and insert rows in postgresql

Question

hey guys I've some data in event_name with a community_code = 1 . now I need to add rows to the same data to the table with community_code = 2. instead of adding each row, is it possible to add all the rows with different community_code. please help me out thank you. please look into image for reference.

Yes his answer works for me go ahead with that.

Arj-One
– Arj-One

2022-02-07 14:15:02 +00:00
Commented Feb 7, 2022 at 14:15 — Arj-One
– Arj-One, Commented Feb 7, 2022 at 14:15

The Impaler · Accepted Answer · 2022-01-31 15:29:34Z

2

You can insert by querying the table and replacing values as needed. For example:

insert into community_comms (id, community_id, event_name) 
select id, 2, event_name
from community_comms
where community_id = 1

answered Jan 31, 2022 at 15:29

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

copy and insert rows in postgresql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related