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
