SQL COPY table data from CSV file in Postgresql

SQL COPY command examples:

COPY censo.clases_materiales FROM '/home/csv/clases_materiales.csv' DELIMITER ',' CSV;

To ignore the column headers:

COPY catastro_censal.aval_carac_valor FROM '/home/csv/valores-caracteristicas.csv' 
    WITH DELIMITER ';' CSV HEADER;

Define columns to insert (for ignore PK field and postgres takes its sequence as default), also ignore header:

COPY catastro_censal.aval_depreciacion (espec, anios, bueno, regular, malo) 
	FROM '/home/csv/depreciacion.csv' WITH DELIMITER ';' CSV HEADER;

Using TAB character:

COPY censo.json_hclaves FROM '/home/csv/json_hclaves.csv' 
    WITH DELIMITER E'\t' CSV HEADER;

Advertisements