title: How can I remove tailing white space while loading data from CSV file into an Postgres Table?
body: <p>I want to remove the trailing whitespaces from CSV file.</p>
  
  <p>Sample CSV file Data:<strong>(Delimitor=";")</strong></p>
  
  <p><code>X ;Y;Z</code> </p>
  
  <p><code>X1  ; Y1;Z1</code></p>
  
  <p><code>X2;Y2; Z2</code></p>
  
  <p>I would have gone for something like <strong>SED</strong> or <strong>GREP</strong> but the file size is huge so it may impact the performance because of preprocessing.</p>
  
  <p>I am looking for a way to remove these whites spaces at the time of loading only.</p>