RubyFlow The Ruby and Rails community linklog

×

The Ruby and Rails community linklog

Made a library? Written a blog post? Found a useful tutorial? Share it with the Ruby community here or just enjoy what everyone else has found!

Using insensitive-case columns in PostgreSQL with citext

by Nando Vieira —

When I first migrated to Postgres from MySQL, I had some duplicated records until I realized that Postgres uses sensitive-case text columns by default. In this article I’ll show you how you can avoid this problem by using citext.

Post a comment

You can use basic HTML markup (e.g. <a>) or Markdown.

As you are not logged in, you will be
directed via GitHub to signup or sign in