Column Types
The goal of SchemaHero is to support all column types. Currently, there is support for the following Postgres types. If there are any missing, open an issue to report it.
| Column Type | Recognized Aliases | SchemaHero Version |
|---|---|---|
| bigint | v0.1.0 | |
| bigserial | serial8 | v0.1.0 |
| bit | int8 | v0.1.0 |
| bit varying | varbit | v0.1.0 |
| boolean | bool | v0.1.0 |
| box | v0.1.0 | |
| bytea | v0.1.0 | |
| character | char | v0.1.0 |
| character varying | varchar | v0.1.0 |
| cidr | v0.1.0 | |
| circle | v0.1.0 | |
| date | v0.1.0 | |
| double precision | float8 | v0.1.0 |
| inet | v0.1.0 | |
| integer | int, int4 | v0.1.0 |
| json | v0.1.0 | |
| jsonb | v0.1.0 | |
| line | v0.1.0 | |
| lseg | v0.1.0 | |
| macaddr | v0.1.0 | |
| money | v0.1.0 | |
| numeric | decimal | v0.1.0 |
| path | v0.1.0 | |
| pg_lsn | v0.1.0 | |
| point | v0.1.0 | |
| polygon | v0.1.0 | |
| real | float4 | v0.1.0 |
| smallint | int2 | v0.1.0 |
| smallserial | serial2 | v0.1.0 |
| serial | serial4 | v0.1.0 |
| text | v0.1.0 | |
| time | timetz | v0.9.0 |
| timestamp | timestamptz | v0.1.0 |
| tsquery | v0.1.0 | |
| tsvector | v0.1.0 | |
| txid_snapshot | v0.1.0 | |
| uuid | v0.1.0 | |
| xml | v0.1.0 |