--按分割符切割SELECT regexp_split_to_table('kenyon, china loves',E'\\s');
regexp_split_to_table
-----------------------
kenyon,
china
loves
-- 按字母分割SELECT regexp_split_to_table('kenyon,,china', E'\\s*');
regexp_split_to_table
-----------------------
k
e
n
y
o
n
,,
c
h
i
n
a