PostgreSQL Common Operations: Reference + Examples

WIP Alert This is a work in progress. Current information is correct but more content may be added in the future.

load CSV file into table

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:

COPY zip_codes FROM '/path/to/csv/ZIP_CODES.txt' DELIMITER ',' CSV;

If your CSV file has a HEADER row you wish to ignore, use this slightly modified command instead:

COPY zip_codes FROM '/path/to/csv/ZIP_CODES.txt' DELIMITER ',' CSV HEADER;

References:

• PostgreSQL Docs: COPY -- copy data between a file and a table