How to split string to array by individual characters?
Postgres has too many features, so sometimes is good to remind some.
Function
string_to_array
is well known. This function has two or three parameters. If second parameter (delimiter) is null, then input string is separated to array of characters.postgres=# select string_to_array('Pavel Stěhule',null); ┌───────────────────────────────┐ │ string_to_array │ ╞═══════════════════════════════╡ │ {P,a,v,e,l," ",S,t,ě,h,u,l,e} │ └───────────────────────────────┘ (1 row)