back to  ["saving and loading the database with elvira"] [[BR]]
back to top [..][[BR]]

{{{
#!sql
-- load this into dbeel
create schema ireland;
drop table if exists ireland.stations;
create table ireland.stations(
id serial,
locationcode integer,
sourcefile text,
easting numeric,
northing numeric,
catchment text,
waterbody text,
site text,
sitecode text);


-- the file is on the key
copy ireland.stations (
	locationcode,
        sourcefile ,
        easting ,
        northing ,
        catchment,
        waterbody,
        site ,
        sitecode)
        from 'f:/gis.csv' with CSV header delimiter as ',' NULL as 'NAN'; -975


}}}