quote from manual: > CREATE EXTENSION loads a new extension into the current database. There > must not be an extension of the same name already loaded. >
You can try to alter[1] the extension to make it located to another schema. [1]: https://www.postgresql.org/docs/14/sql-alterextension.html On Tue, May 31, 2022 at 8:39 PM PG Doc comments form <nore...@postgresql.org> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createextension.html > Description: > > I'm trying to add an extension to two schemas that I have in my DB. > > steps: > > 1) > > CREATE EXTENSION unaccent with SCHEMA public; > > response: OK. > > 2) > > CREATE EXTENSION unaccent with SCHEMA public_test; > > response: SQL Error [42710]: ERROR: extension "unaccent" already exists > > I tryed: > > SET search_path = public_test; > CREATE EXTENSION unaccent; > > and the response is: response: SQL Error [42710]: ERROR: extension > "unaccent" already exists > -- I recommend David Deutsch's <<The Beginning of Infinity>> Jian
