The query I tried is this:
Create table test1 as
Select
row_number() over() as ID,
(st_dump(st_split(input.geom, blade.geom))).geom as geom
from roads input
join roads blade on st_intersects(input.geom, blade.geom);
The error that pops up is like this:
ERROR: Splitter line has linear intersection with input
SQL state: XX000