Re: citext, actually probably using extensions

> On Sep 20, 2019, at 1:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> stan <stanb@panix.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
toadd it by hand each time