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 'C:/Documents and Settings/edeeyto/Desktop/EDA France Jan 12/gis.csv' with CSV header delimiter as ',' NULL as 'NAN'; --975


copy ireland.survey(
	sourcefile,
	easting,
	northing,
	thedate,
	theyear,
	catchment,
	waterbody,
	site,
	sitecode,
	sitelength,
	siteaveragewettedwidth,
	methodology,
	efishingunits,
	numfishingpasses,
	sitewettedarea,
	fishing1,
	fishing2,
	fishing3,
	fishing4,
	fishing5,
	totaleel,
	estimate_for_site,
	ci_for_site,
	numbersperm2,
	ciperm2,
	catchability_p,
	percentageci,
	minest,
	densityperm2,
	surveycode,
	samplingcode,
	locationcode)
        from 'f:/survey.csv' with CSV header delimiter as ';'; --1256
}}}