From: | stan <stanb(at)panix(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | citext, actually probably using extensions |
Date: | 2019-09-20 18:13:24 |
Message-ID: | 20190920181324.GA17323@panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I was pointed to the citext type to help solve an issue for a project I am
working on. I looked at this page:
https://nandovieira.com/using-insensitive-case-columns-in-postgresql-with-citext
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.
What am I doing incorrectly?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Bikram MAJUMDAR | 2019-09-20 18:39:34 | pgwatch2 monitoring dashboards |
Previous Message | Sonam Sharma | 2019-09-20 16:11:57 | Fwd: FW: pg_auto_failover |