Query for uploading CSV file in postgreSQL database

Question :

  • I need to  SQL query for uploading CSV file in database
  • I have one CVS file and I need to update this file direct in table .

 

Solution:

COPY tableName FROM '{filepath}\\{fileName}.CSV' DELIMITERS ',' CSV;

 

Details:

I have used inbuilt query and changed parameter like path etc and I solved this problem now I’m able to uploading CSV file in direct.