> On Sep 20, 2019, at 1:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> stan <stanb(at)panix(dot)com> writes:
>> But I must be doing something wrong. As the PG superuser, I did this:
>> postgres=# CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
>> CREATE EXTENSION
>
>> and as the superuser it shows up in the \dx display
>
>> BUT as a normal user:
>
>> stan=> \dx
>> List of installed extensions
>> Name | Version | Schema | Description
>
>> ---------+---------+------------+------------------------------
>> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural
>> language
>> (1 row)
>
>> It does not.
>
> Judging from the prompts you show, you installed the extension
> in the "postgres" database, but you need it in the "stan" database.
>
> regards, tom lane
>
>
And if you install the extension in the template1 db it will be included in ‘create database’ calls. Rather than having to add it by hand each time