Add support for specifying the postgres index type 

This PR adds the ability to optionally specify the postgres index type to use when creating an index (http://www.postgresql.org/docs/9.0/static/indexes-types.html).

Includes tests.