title: Import CSV with unknown columns to PostgreSQL using Python
body: <p>I'm trying to import a CSV file which contains 74 columns to a PostgreSQL table.I have tried to do it via PostgreSQL and couldn't able to do it, below is the post, from this post came to know that i need a client side programming language to accomplish this,So thought of doing it through python as our project uses python for additional backend operations.</p>
  
  <p>I'm new to python and i have searched a lot but in every example i found, the table column names was predefined, in my case since the CSV contains 74 columns it will not be possible to create a table by hardcoding every columns.</p>
  
  <p><strong>So can anyone suggest or recommend a generalised solution for this,It will be of great help.</strong></p>
  
  <p><a href="https://stackoverflow.com/questions/56787570/cannot-copy-a-csv-file-from-local-machine-to-remote-server">Cannot COPY a CSV file from local machine to remote server</a></p>