In order to use the extension within database execute the following command:

CREATE EXTENSION uri;