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!

Answer 1

You can do:

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

Demo