Thank you so much guys, my mistake I didn't pay attention. I'm new
to PostgreSQL and your help is much appreciated!
Em ter., 31 de mai. de 2022 às 12:32, Tom Lane escreveu:
> "David G. Johnston" writes:
> > On Tuesday, May 31, 2022, PG Doc comments form
> > wrote:
> >> I'm trying to add an
"David G. Johnston" writes:
> On Tuesday, May 31, 2022, PG Doc comments form
> wrote:
>> I'm trying to add an extension to two schemas that I have in my DB.
> It doesn’t work and isn’t documented as something that does work. I really
> don’t see a need to say you cannot install the same
On Tuesday, May 31, 2022, PG Doc comments form
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:
>
>
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
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)