public.geometry(MultiLineString,3857) does not exist

geometry_error.sql

-- If you have an error running a query with geometry in Postgresql

CREATE TABLE "some_random_table" (

        "id" int4 NOT NULL,

        "map_coords" "public"."geometry(MultiLineString,3857)",

        "col3" int4 NOT NULL,

        "col4_id" int4 NOT NULL,

        CONSTRAINT "some_random_tablee_pkey" PRIMARY KEY ("id")

);

-- like this:

-- ERROR:  type "public.geometry(MultiLineString,3857)" does not exist

-- LINE 5:         "map_coords" "public"."geometry(MultiLineString,3857...

--                             ^
-- And you know that it does exist, just take the double quote away from that line to and voilá:

CREATE TABLE "some_random_table" (

        "id" int4 NOT NULL,

        map_coords public.geometry(MultiLineString,3857),

        "col3" int4 NOT NULL,

        "col4_id" int4 NOT NULL,

        CONSTRAINT "some_random_tablee_pkey" PRIMARY KEY ("id")

);