Postgres Pro
Downloads
Home   >   mailing lists

Help : Removal of leading spaces in all the columns of a table - Mailing list pgsql-general

From srikkanth
Subject Help : Removal of leading spaces in all the columns of a table
Date
Msg-id 20200212124246.3340.qmail@f4mail-235-121.rediffmail.com
Whole thread Raw
Responses Re: Help : Removal of leading spaces in all the columns of a table  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Re: Help : Removal of leading spaces in all the columns of a table  (Susan Hurst <susan.hurst@brookhurstdata.com>)
List pgsql-general
Tree view

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 inputs.

 

Thanks,

Srikanth B

pgsql-general by date:

Previous
From: farjad.farid
Date:
Subject: RE: Function not imported in Entity Framework
Next
From: Charles Clavadetscher
Date:
Subject: Re: Help : Removal of leading spaces in all the columns of a table