Re: citext, actually probably using extensions

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