Select Page

How to import a CSV file into a PostgreSQL database table

  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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.