change data in table Postgresql

Question

I have table:

| code   |  name  |
|--------|--------|
| A      |  name1 |
| A      |  name2;name3 |

I want to change data in table:

| code   |  name  |
|--------|--------|
| A      |  name1 |
| A      |  name2 |
| A      |  name3 |

How do it? Please help me!

Does the names column always have just one name or two separated by a semi colon? Have you tried something yet? — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 14, 2017 at 10:06
The name column maybe: 'name1' or 'name1;name3' or 'name1;name2;name3' — niemnv
– niemnv, Commented Sep 14, 2017 at 10:11

Tim Biegeleisen · Accepted Answer · 2017-09-14 10:31:36Z

3

You can do:

select
    code,
    unnest(string_to_array("name", ';'))
from codename

Demo

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

answered Sep 14, 2017 at 10:15

jgrocha

3,1221 gold badge31 silver badges36 bronze badges

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

Wow! Thanks @tim-biegeleisen for the demo. It is really nice to see it working.