This pretty much calls for a user defined function. Plpgsql should work, but if you're more comfy in perl or tcl there's pl/tcl and pl/perl you can try as well. On Wed, Jun 20, 2012 at 8:43 AM, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> wrote: > Good morning, > > Is there a simply method in psql to format a string? > > For example, adding a space to every three consecutive letters: > > abcdefgh -> *** *** *** > > Thanks a lot! > Emi > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
