re¶
regexp_split_to_array()¶
select
prt[1] person_id
, prt[2] person_name
from (
select
regexp_split_to_array(str, ',') prt
from (
values
('1, ilnurgi1')
, ('2, ilnurgi2')
) t(str)
) t
/*
person_id | person_name
----------+------------
1 | ilnurgi1
2 | ilnurgi2
*/
regexp_split_to_table()¶
select
regexp_split_to_table(
$$
1;ilnurgi1
2;ilnurgi2
$$
, E'\\n'
) ptr
/*
ptr
-----------
1; ilnurgi1
2; ilnurgi2
*/