• github.com/deepfryed/pg_typecast

Provides typecasting support for the pg gem. The code is extracted from swift (github.com/shanna/swift) as a drop-in enhancement for users of pg.

**THIS CODE IS NOT MAINTAINED ANYMORE**

This was done as an initial proof of concept and is not maintained anymore. If you’re looking for a database adapter that does typecasting for pg, have a look at github.com/deepfryed/swift-db-postgres

• ruby >= 1.9.1

• pg >= 0.9.0

• This gem overrides the PGresult#each method.

• The rows are returned as hashes with field names as symbols and values typecast from postgres types to ruby types.

• Timestamp conversion is done to localtime. The server and client are assumed to be in same timezone unless you use the ‘timestamp with time zone’ data type in postgresql.

If pg_config is not on your PATH, then just set POSTGRES_INCLUDE and POSTGRES_LIB environment variables to the include and lib directories.

require 'pg'
require 'pg_typecast'

adapter = PGconn.connect 'host=127.0.0.1 dbname=test'
result  = adapter.exec('select * from users')
result.each do |row|
  p row
end

The following table illustrates the typecasting done from postgresql types to native ruby types.

+--------------------+---------------------------+
| postgresql type    |   ruby type               |
+--------------------+---------------------------+
| bool               |   TrueClass or FalseClass |
| bytea              |   StringIO                |
| date               |   Date                    |
| float              |   Float                   |
| integer            |   Fixnum or Bignum        |
| numeric            |   BigDecimal              |
| timestamp          |   Time                    |
| timestampz         |   Time                    |
+--------------------+---------------------------+

See LICENSE.