How to fix raster does not exists error?

Question

PostgreSQL

Hello. I'm trying to add a field of type "raster" to an existing table, but I'm getting the error "ERROR: type "raster" does not exist".
Postgres version 12.1, installed extension postgis. macOS version 10.15.2 Add request

BEGIN;
--
-- Add field extra_raster to worldborder
--
ALTER TABLE "world_worldborder" ADD COLUMN "extra_raster" raster NULL;
CREATE INDEX "world_worldborder_extra_raster_id" ON "world_worldborder"USING GIST (ST_ConvexHull("extra_raster"));
COMMIT;

How to solve this problem? Thank you!

Answer 1

Now postgis version is 3.0.0

https://postgis.net/2019/10/20/postgis-3.0.0/

-- install these if you need them
CREATE EXTENSION postgis_raster;