SimpleCodeSnippets

This page is more of a scratch pad for remember simple code snippets for future reference.

1. Import CSV to postgreSQL database table:

COPY graphdata(startdate, "value", series_id, region_id)
FROM 'C:/work/work_cerc/CERC_Documents/CARBONES_Graph_CSV/Fgpp.txt'
WITH DELIMITER ','
CSV HEADER

2. Import tab delimited text to postgreSQL database table:

COPY units("units_id","units_name")
FROM 'E:/PostgreSQL/units.txt'
WITH DELIMITER '    '
CSV HEADER;

COPY variable("variable_id","variable_code","variable_name","units_id","isflux")
FROM 'E:/PostgreSQL/variable.txt'
WITH DELIMITER '    '
CSV HEADER;