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 <em...@encs.concordia.ca> 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@postgresql.org) > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general