accounts=> create table users(nick citext primary key,pass text not null);
ERROR: type “citext” does not exist
LINE 1: create table users(nick citext primary key,pass text not nul…
accounts=> create extension citext;
CREATE EXTENSION
accounts=> \dx
List of installed extensions
Name | Version | Schema | Description
---------±--------±-----------±-------------------------------------------------
citext | 1.6 | public | data type for case-insensitive character strings
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
accounts=> create table users( nick citext primary key,pass text not null);
CREATE TABLE