postgresql - 如何将CSV文件数据导入PostgreSQL表？(How to import CSV file data into a PostgreSQL table?)

Question

如何编写一个存储过程，该存储过程从CSV文件导入数据并填充表？

  ask by vardhan translate from so

Answer 1

Take a look at this short article .

(看一下这篇简短的文章 。)

---

Solution paraphrased here:

(解决方案的解释如下：)

Create your table:

(创建表：)

CREATE TABLE zip_codes 
(ZIP char(5), LATITUDE double precision, LONGITUDE double precision, 
CITY varchar, STATE char(2), COUNTY varchar, ZIP_CLASS varchar);

Copy data from your CSV file to the table:

(将数据从CSV文件复制到表格中：)

COPY zip_codes FROM '/path/to/csv/ZIP_CODES.txt' WITH (FORMAT csv);