CREATE TABLE public.line (id integer Not Null,
                          name VARCHAR (25),
                          geom geometry (LineString, 27700));

ALTER mytable ADD COLUMN (roadlength real);

UPDATE mytable
SET roadlength = ST_LENGTH(geom::geography)*1000;

UPDATE mytable
SET roadlength = ST_LENGTH(geom)*1000;