您正在寻找regexp_split_to_table()
:
http://www.postgresql.org/docs/9.2/static/functions- string.html
select regexp_split_to_table('hello world', E'\\s+');
hello
world
(2 rows)
如何在PostgreSQL的换行符上将值拆分为多行?
您正在寻找regexp_split_to_table()
:
http://www.postgresql.org/docs/9.2/static/functions- string.html
select regexp_split_to_table('hello world', E'\\s+');
hello
world
(2 rows)