0014_extension_in_public.md

Level: WARN

Rationale

Entities like tables and functions in the public schema are exposed through Supabase APIs by default. When extensions are installed in the public schema, the functions, tables, views, etc that they contain appear to be part of your project's API.

How to Resolve

To relocate an extension from the public schema to another schema, execute:

alter extension <some_extension> set schema <some_schema>;

Example

If the ltree extension was initially created in thh public schema with

create extension ltree;

or

create extension ltree schema public;

You can relocate its components to the extensions schema by running

alter extension ltree set schema extensions;