SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "epci" CASCADE;
BEGIN;
CREATE TABLE "epci"();
SELECT AddGeometryColumn('epci','geometrie',5490,'GEOMETRY',2);
CREATE INDEX "epci_geometrie_geom_idx" ON "epci" USING GIST ("geometrie");
ALTER TABLE "epci" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "epci" ADD COLUMN "code_siren" VARCHAR(9);
ALTER TABLE "epci" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "epci" ADD COLUMN "nom_officiel" VARCHAR(120);
ALTER TABLE "epci" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "epci" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "epci" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "epci" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "epci" ADD COLUMN "liens_vers_autorite_administrative" VARCHAR;
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "epci" ("geometrie", "cleabs", "code_siren", "nature", "nom_officiel", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "liens_vers_autorite_administrative") FROM STDIN;
[encoded data, 316564 characters]	EPCI____0000002150237198	249710047	Communauté de communes	CC de Marie-Galante	2018/11/24 00:00:00	2019/05/20 14:47:45.624	\N	\N	SURFACTI0000001171495308
[encoded data, 815196 characters]	EPCI____0000002150236151	200041507	Communauté d'agglomération	CA La Riviera du Levant	2018/11/24 00:00:00	2020/04/14 15:21:51.505	\N	\N	SURFACTI0000002007748818
[encoded data, 644424 characters]	EPCI____0000002150237199	249710062	Communauté d'agglomération	CA du Nord Basse-Terre	2018/11/24 00:00:00	2020/04/14 15:21:51.505	\N	\N	SURFACTI0000001171996350
[encoded data, 661052 characters]	EPCI____0000002150236214	200044691	Communauté d'agglomération	CA du Nord Grande Terre	2018/11/24 00:00:00	2020/04/14 15:21:51.505	\N	\N	SURFACTI0000001171494182
[encoded data, 532320 characters]	EPCI____0000002150235977	200018653	Communauté d'agglomération	CA Cap Excellence	2018/11/24 00:00:00	2020/04/14 15:21:51.505	\N	\N	SURFACTI0000001171936265
[encoded data, 676996 characters]	EPCI____0000002150237200	249710070	Communauté d'agglomération	CA Grand Sud Caraïbe	2018/11/24 00:00:00	2020/04/14 15:21:51.505	\N	\N	SURFACTI0000001171439988
\.
END;
COMMIT;
