> On Sep 20, 2019, at 1:12 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > stan <stanb@xxxxxxxxx> 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
