How to import a CSV file into a PostgreSQL database table

13 sec read

  1. Type in the following command in postgres using the command line:
    copy products from ‘/home/user/products.csv’ using delimiters ‘,’

    • products = (Database Table)
    • ‘/home/user/products.csv‘ = (Location of the csv file)
    • You need to have insert privileges on the table you need to insert the data to

How to export data to csv file from postgres database?

Last Updated On April 07, 2018

Leave a Reply

avatar
  Subscribe  
Notify of