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