Move values from table to another in PostgreSQL

Question

Hello I have a PostgreSQL 9.1 database with such tables [tables are simplified]

enter image description here

For now I use only tables: account, account_word and word. But I wanted to add groups of words into my database. So I created tables wordgroup and wordgroup_word. Now my table account_word is no longer needed so I would like to move all words from account_word to wordgroup_word. In general:

I would like to move all account's word to his wordgroup where group's "is_all" is true and then delete account_word table

Could someone help me to achieve this?

Cheers

Grodek: you can follow something as specified here

Gopinagh.R
– Gopinagh.R

2012-11-05 09:21:37 +00:00
Commented Nov 5, 2012 at 9:21 — Gopinagh.R
– Gopinagh.R, Commented Nov 5, 2012 at 9:21

Mariusz Grodek · Accepted Answer · 2012-11-05 09:30:54Z

1

move all words from account_word to wordgroup_word.

 insert into wordgroup_word 
    select  wordgroup_id, word_id
    from account_word aw join wordgroup wg 
    on aw.account_id = wg.account_id 
    and is_all=true

edited Nov 5, 2012 at 9:30

Mariusz Grodek

6394 gold badges12 silver badges26 bronze badges

answered Nov 5, 2012 at 9:24

solaimuruganv

30.3k1 gold badge22 silver badges23 bronze badges

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

1 Comment

Mariusz Grodek Over a year ago

I will try your solution soon.

Collectives™ on Stack Overflow

Move values from table to another in PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related