title: How to upload text file in postgresql which have multiple space between columns?
body: <p>Here file1 &amp; file2 5 column but file2 have 4 columns data available.
  I am not able to upload/import file in table because they have no delimiter.
  Table total column 5 &amp; every file should be <strong>upload/import in same table</strong>.</p>
  <p>Every column's value has <strong>fixed length</strong> like column1 has 1,10; column2 has 14,12; column3 has 30,2; column4 has 41,8; column5 has 54,4.</p>
  <p><strong>&gt; I use PostgreSQL Database Server. What should I do? Please help me.</strong></p>
  <h2><strong>file1</strong></h2>
  <pre><code>88056846     465             L          4.009        AB3C
  88056846     465             L                       AB3C
  88056846     465             L          4.009        AB3C
  </code></pre>
  <h2><strong>file2</strong></h2>
  <pre><code>88056846     465                        4.009        AB3C
  88056846     465                        4.009        AB3C
  88056846     465                        4.009        AB3C
  </code></pre>
  <p><strong><a href="https://i.stack.imgur.com/Pg3qE.png" rel="nofollow noreferrer">enter image description here is real view file1 &amp; file2</a></strong></p>