postgresql-9.1 – Tarik Billa

Postgresql SQL: How check boolean field with null and True,False Value?

February 2, 2023 by Tarik

There are 3 states for boolean in PG: true, false and unknown (null). Explained here: Postgres boolean datatype Therefore you need only query for NOT TRUE: SELECT * from table_name WHERE boolean_column IS NOT TRUE;

Postgresql: ERROR: type “citext” does not exist

January 9, 2023 by Tarik

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;