title: Loading zipped CSV(filename.csv.gz) file into PostgreSQL table
body: <p>How to load larger amount of csv.gz file into Postgresql without unzipping to csv file ,since I tried pipeline command (mkfifo pipelinename) but it doesn't work for me. Is there any other solution to solve this issue ? </p>
  
  <p>I have try to load it from local to postgresql using following command
  command : zcat file.csv.gz | psql -U username -d database;</p>
  
  <p>Result : out of memory</p>
  
  <p>Need : I want to load a big size csv.gz (around 15+ GB) file from centos to postgresql database.</p>