10 Oct 2018   sql


Postgres has a character_length string function. I found this useful in check constraint scenarios:

create table addresses (
  id serial primary key,
  state text not null default 'AL' check (character_length(state) = 2)
);

https://www.postgresql.org/docs/current/static/functions-string.html