Suppose I have a string such as:
and I would like to reformat it as:
abc def ghi
(that is, I have added some formatting spaces to the string).
Is there a PostgreSQL function which will do that? Something like:
reformat(abcdefghi,'xxx xxx xxx')
I know there isn’t the above function, but there might be a built in function to do something like that.
If not, I am happy to write such a function, but I though I would check.