Skip to content
This repository


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Adds support for missing PostgreSQL data types to ActiveRecord


Adds missing native PostgreSQL data types to ActiveRecord and convenient querying extensions for ActiveRecord and Arel for Rails 4.x

Build Status Code Climate Gem Version

Looking for help?

If it is a bug please open an issue on Github. If you need help using the gem please ask the question on Stack Overflow. Be sure to tag the question with DockYard so we can find it.


Add this line to your application's Gemfile:

gem 'postgres_ext'

And then execute:

$ bundle

Or install it yourself as:

$ gem install postgres_ext


Just require 'postgres_ext' and use ActiveRecord as you normally would! postgres_ext extends ActiveRecord's data type handling and query methods in both Arel and ActiveRecord.

Where are the datatypes from PostgresExt 1.x? ActiveRecord 4.x includes all the data types that PostgresExt added to ActiveRecord 3.2.x. We'll be adding more datatypes as we come across them.


To work on postgres_ext locally, follow these steps:

  1. Run bundle install, this will install all the development dependencies
  2. Run rake setup, this will set up the .env file necessary to run the tests and set up the database
  3. Run rake db:create, this will create the test database
  4. Run rake db:migrate, this will set up the database tables required by the test


Dan McClain twitter github

Something went wrong with that request. Please try again.