| 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: | Whole Thread | Raw Message | 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 |