INSERT INTO dsm_services(
	id,
	officialname,
	englishname,
	websiteurl,
	logourl,
	contactemail,
	latitude,
	longitude,
	timezone,
	namespaceprefix,
	languages,--array
	collectedfrom,
	dateofvalidation,
	provenanceaction,
	platform,
	activationid,
	description,
	releasestartdate,
	releaseenddate,
	missionstatementurl,
	databaseaccesstype,
	datauploadtype,
	databaseaccessrestriction,
	datauploadrestriction,
	citationguidelineurl,
	certificates,
	aggregator,
	issn,
	eissn,
	lissn,
	registeredby,
	subjects,--array
	managed,
	eosc_datasource_type,
	eosc_type,
	primary_provide_gateway,
	affiliated_provide_gateways
) VALUES (
	:id,
	:officialname,
	:englishname,
	:websiteurl,
	:logourl,
	:contactemail,
	:latitude,
	:longitude,
	:timezone,
	:namespaceprefix,
	:languages,--array
	:collectedfrom,
	:dateofvalidation,
	:provenanceaction,
	:platform,
	:activationid,
	:description,
	:releasestartdate,
	:releaseenddate,
	:missionstatementurl,
	:databaseaccesstype,
	:datauploadtype,
	:databaseaccessrestriction,
	:datauploadrestriction,
	:citationguidelineurl,
	:certificates,
	:aggregator,
	:issn,
	:eissn,
	:lissn,
	:registeredby,
	:subjects,--array
	:managed,
	:eoscdatasourcetype,
	:eosctype,
	:primaryprovidegateway,
	string_to_array(:affiliatedprovidegateways,',')
)
