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
drop table if exists ireland.survey;
create table ireland.survey(
surveyid serial,
sourcefile text,
easting numeric,
northing numeric,
thedate date,
theyear integer,
catchment text,
waterbody text,
site text,
sitecode text,
sitelength numeric,
siteaveragewettedwidth numeric,
methodology text,
efishingunits integer,
numfishingpasses integer,
sitewettedarea numeric,
fishing1 integer,
fishing2 integer,
fishing3 integer,
fishing4 integer,
fishing5 integer,
totaleel integer,
estimate_for_site numeric,
ci_for_site numeric,
numbersperm2 numeric,
ciperm2 numeric,
catchability_p numeric,
percentageci numeric,
minest numeric,
densityperm2 numeric,
surveycode text,
samplingcode text,
locationcode integer);

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
}}}