Re: Help : Removal of leading spaces in all the columns of a table

> On Feb 12, 2020, at 7:09 AM, Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> wrote:
>
> 
> I once wrote a trigger function to do just what you asked, however, it was a huge drain on performance so I didn't use it for long, so I dropped the trigger. Hopefully, someone has a more practical approach. I would be interested in this also.
>
> Sue
>
> ---
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Susan E Hurst
> Principal Consultant
> Brookhurst Data LLC
> Email: susan(dot)hurst(at)brookhurstdata(dot)com
> Mobile: 314-486-3261
>> On 2020-02-12 06:42, srikkanth wrote:
>>
>> Hi Team,
>>
>> How can i write the syntax to remove the leading spaces on a table for all the columns.
>>
>> Also, want to know how to do the all words of all the columns in capital along with removing of leading\excessive\trailing spaces at a time.
>>
>> Can you please help me out, let me know in case of any

For larger production tables I would stream the converted data through COPY into a new table of identical shape, build indeces then rename both and truncate/drop old table.