Postgresql: ERROR: type "citext" does not exist

postgresql-9.1

Solution

Ok figured it out. I have several databases and `CREATE EXTENSION citext` has to be run for each db to install the extension in that DB. You must do on psql prompt:

psql =# \c db_1
CREATE EXTENSION citext;

psql =# \c db_2
CREATE EXTENSION citext;

Problem

I have read other posts, when searching, an answer to this question. I am using PostgreSQL 9.1, and created extension 'citext' using `CREATE EXTENSION citext`, but when I try to create any columns of type 'citext', it throws this error ERROR: type "citext" does not exist I researched but did not find any concrete answers? Any idea why?

Original source