Help on Posgis ¶

Postgis book ​http://www.postgis.fr/book/print/156#413413413

I would like to create a postgis table from a postgres table with x y ¶

The data are in lambert II étendu

select * from bdmap.spatial_ref_sys where srtext like '%Lambert%' and srtext like '%II%' 

seems to be 27572

CREATE table bdmap.STATIONsp
(
  st_id numeric(22) NOT NULL,
  st_altitude numeric(22),
  st_abcisse numeric(22),
  st_codecsp character varying(8),
  st_codesei character varying(8),
  st_datearret date,
  st_datecreation date,
  st_distancesource numeric(22),
  st_distancemer numeric(22),
  st_finalite character varying(70),
  st_imageign character varying(30),
  st_imagedept character varying(30),
  st_lieudit character varying(32),
  st_limites character varying(75),
  st_localisation character varying(60),
  st_longueur numeric(22),
  st_moduleia numeric(22),
  st_cd_naturecourseau numeric(22),
  st_ordonnee numeric(22),
  st_penteign numeric(22),
  st_pkaval numeric(22),
  st_raisremp character varying(80),
  st_sbv numeric(22),
  st_t_janvier numeric(22),
  st_t_juillet numeric(22),
  st_cd_typecourseau numeric(22),
  st_cd_tet numeric(22),
  st_st_id numeric(22),
  st_cm_id numeric(22),
  st_cx_id numeric(22),
  st_th_id numeric(22),
  st_eh_id numeric(22),
  st_uh_id numeric(22),
  st_dt_cre date,
  st_dt_maj date,
  st_qi_maj character varying(64),
  st_masseeau numeric(22),
  CONSTRAINT stationsp_pkey PRIMARY KEY (st_id)
);

COMMENT ON TABLE bdmap.STATIONsp IS 'Table similaire à la table station mais géoréférencee';
SELECT AddGeometryColumn(bdmap, station,'the_geom', 27572,'POINT',2)