Import excel sheet to Postgresql database

Question

Is there any tool/ query based mechanism for importing excel sheet data (xls/csv) to postgresql table?

Duplicate of https://stackoverflow.com/questions/20039856/import-excel-data-into-postgresql-9-3 — mic, Aug 19 '19 at 14:53

score 1 · Accepted Answer · edited Jul 31 '14 at 08:58

1

Try This

COPY Your_Table FROM 'D:/column.csv' WITH DELIMITER ';' CSV HEADER;

edited Jul 31 '14 at 08:58

Vivek S.

answered Jul 31 '14 at 07:35

Thush

1 Answers1