PostgreSQL ERROR: type "geometry" does not exist

ERROR: type "geometry" does not exist

This error happens because of the absence of postgis plugin and this article explains the steps to install the same.

>CREATE EXTENSION postgis;

Then set the default search_path for database.

>ALTER DATABASE test SET search_path = SCHEMA,public;

Where DATABASE, SCHEMA need to be replaced with required values.

Search_path can be set for the roles also.

>ALTER ROLE foo SET search_path = SCHEMA,public;

Where ROLE, SCHEMA need to be replaced with required values.

That's all…