I have connected my postgres database from render on dbeaver and I want to create a new table. I run the following query :
CREATE TABLE draft_ilias.parcels_2 (
parcel_id serial4 NOT NULL,
user_id int4 NOT NULL,
name_area text NULL,
crop_type varchar(100) NULL,
area_m2 numeric(10, 2) NULL,
geom_4326 public.geometry(polygon, 4326) NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
irrigation bool NOT NULL DEFAULT false,
traps bool NOT NULL DEFAULT false,
station bool NOT NULL DEFAULT false,
bio bool NOT NULL DEFAULT false,
CONSTRAINT parcels_2_pkey PRIMARY KEY (parcel_id)
); -
SQL Error [42704]: ERROR: type “public.geometry” does not exist
Position: 192 - how to fix it??