title: Copy in Postgres from a tab delimited file to table
body: <p>I am working on a copy command to copy the contents of a tab delimited file with a header to a table in postgres. I have used copy before so I know how it works but I have a question regarding how I can get around some data being missing in the file.</p>
  
  <p>I have premade the table to have the same column names as the values in the header.</p>
  
  <p>Some of the "columns" from the file that I received are just blank. I have put fake data in just to get the command working but this is something that is going to be automated weekly. I was wondering if I am just going to have to tell the people to make sure their data is correct or if there is a way to tell the copy command to input a NULL in the place of blank data.</p>
  
  <p>I thought I might have to place in blank tabs and that would act as a null but I wasn't sure if that was the best course of action.</p>