Re: Insert a space between each character - Mailing list pgsql-sql

Hi,

Use a regular expression, e.g.:

select trim(regexp_replace('foobarbaz', '(.)', E'\\1 ', 'g'));

See http://www.postgresql.org/docs/8.3/static/functions-matching.html
for more.
+mt

Nicholas I wrote:
> Hi,
>
>  can anybody help me, to insert a space between each character in
> postgresql.
>
>  for example,
>
>   ABC
>
>  output
>   A B C
>
> -Dominic