How to import data into postgre?

  • I am trying to import .csv data provided into table through pgadmin4 with both mouse work or command line. But neither of the methods works.

    • the windows work: right click the mouse on table name then click import/export, copy the path input the import path
    • SQL query: create table, then execute
      copy jena.customers from 'C:\Users\Jena\Documents\...\DS102\customers.csv' delimiter ',' csv;
      Both action return none response.
      Please show the right way to import the data.

    jena.customersrom ‘C:\Users\Jena\Documents\Course\DS102\customers.csv’ delimiter ‘,’ csv;

  • Did you encounter any error message after you run the copy command?


与 BitTiger Community 的连接断开,我们正在尝试重连,请耐心等待