# Supported Types

## Standard Types

Most of the standard types with partial support are missing functionality regarding their parameters. For example, `timestamp` takes in a precision, but does not enforce it.

| SQL Type Name  | Implemented | Aliases                        |
| -------------- | :---------: | ------------------------------ |
| bit            |      ❌      |                                |
| bit\[]         |      ❌      |                                |
| boolean        |      ✅      |                                |
| boolean\[]     |      ✅      |                                |
| box            |      ❌      |                                |
| box\[]         |      ❌      |                                |
| bytea          |      🟠     |                                |
| bytea\[]       |      🟠     |                                |
| char           |      🟠     | character                      |
| char\[]        |      🟠     | character\[]                   |
| cidr           |      ❌      |                                |
| cidr\[]        |      ❌      |                                |
| circle         |      ❌      |                                |
| circle\[]      |      ❌      |                                |
| date           |      🟠     |                                |
| date\[]        |      🟠     |                                |
| datemultirange |      ❌      |                                |
| daterange      |      ❌      |                                |
| float4         |      ✅      | real                           |
| float4\[]      |      ✅      | real\[]                        |
| float8         |      ✅      | double precision               |
| float8\[]      |      ✅      | double precision\[]            |
| inet           |      ❌      |                                |
| inet\[]        |      ❌      |                                |
| int2           |      ✅      | smallint                       |
| int2\[]        |      ✅      | smallint\[]                    |
| int4           |      ✅      | int, integer                   |
| int4\[]        |      ✅      | int\[], integer\[]             |
| int4multirange |      ❌      |                                |
| int4range      |      ❌      |                                |
| int8           |      ✅      | bigint                         |
| int8\[]        |      ✅      | bigint\[]                      |
| int8multirange |      ❌      |                                |
| int8range      |      ❌      |                                |
| interval       |      ✅      |                                |
| interval\[]    |      ✅      |                                |
| json           |      🟠     |                                |
| json\[]        |      🟠     |                                |
| jsonb          |      🟠     |                                |
| jsonb\[]       |      🟠     |                                |
| line           |      ❌      |                                |
| line\[]        |      ❌      |                                |
| lseg           |      ❌      |                                |
| lseg\[]        |      ❌      |                                |
| macaddr        |      ❌      |                                |
| macaddr8       |      ❌      |                                |
| macaddr8\[]    |      ❌      |                                |
| macaddr\[]     |      ❌      |                                |
| money          |      ❌      |                                |
| money\[]       |      ❌      |                                |
| numeric        |      🟠     | decimal                        |
| numeric\[]     |      🟠     | decimal\[]                     |
| nummultirange  |      ❌      |                                |
| numrange       |      ❌      |                                |
| path           |      ❌      |                                |
| path\[]        |      ❌      |                                |
| point          |      ❌      |                                |
| point\[]       |      ❌      |                                |
| polygon        |      ❌      |                                |
| polygon\[]     |      ❌      |                                |
| serial2        |      ❌      | smallserial                    |
| serial4        |      ❌      | serial                         |
| serial8        |      ❌      | bigserial                      |
| text           |      ✅      |                                |
| text\[]        |      ✅      |                                |
| time           |      🟠     | time without time zone         |
| time\[]        |      🟠     | time without time zone\[]      |
| timestamp      |      🟠     | timestamp without time zone    |
| timestamp\[]   |      🟠     | timestamp without time zone\[] |
| timestamptz    |      🟠     | timestamp with time zone       |
| timestamptz\[] |      🟠     | timestamp with time zone\[]    |
| timetz         |      🟠     | time with time zone            |
| timetz\[]      |      🟠     | time with time zone\[]         |
| tsmultirange   |      ❌      |                                |
| tsquery        |      ❌      |                                |
| tsquery\[]     |      ❌      |                                |
| tsrange        |      ❌      |                                |
| tstzmultirange |      ❌      |                                |
| tstzrange      |      ❌      |                                |
| tsvector       |      ❌      |                                |
| tsvector\[]    |      ❌      |                                |
| uuid           |      ✅      |                                |
| uuid\[]        |      ✅      |                                |
| varbit         |      ❌      | bit varying                    |
| varbit\[]      |      ❌      | bit varying\[]                 |
| varchar        |      🟠     | character varying              |
| varchar\[]     |      🟠     | character varying\[]           |
| xml            |      ❌      |                                |
| xml\[]         |      ❌      |                                |

## Pseudo-Types

| SQL Type Name           | Implemented |
| ----------------------- | :---------: |
| any                     |      ❌      |
| anyarray                |      ✅      |
| anycompatible           |      ❌      |
| anycompatiblearray      |      ❌      |
| anycompatiblemultirange |      ❌      |
| anycompatiblenonarray   |      ❌      |
| anycompatiblerange      |      ❌      |
| anyelement              |      ✅      |
| anyenum                 |      ❌      |
| anymultirange           |      ❌      |
| anynonarray             |      ✅      |
| anyrange                |      ❌      |
| cstring                 |      ❌      |
| event\_trigger          |      ❌      |
| fdw\_handler            |      ❌      |
| index\_am\_handler      |      ❌      |
| internal                |      ❌      |
| language\_handler       |      ❌      |
| pg\_ddl\_command        |      ❌      |
| record                  |      ❌      |
| table\_am\_handler      |      ❌      |
| trigger                 |      ❌      |
| tsm\_handler            |      ❌      |
| unknown                 |      🟠     |
| void                    |      ❌      |

## OID Alias Types

See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/datatype-oid.html).

| SQL Type Name | Supported |
| ------------- | --------- |
| oid           | ✅         |
| xid           | 🟠        |
| regclass      | ✅         |
| regcollation  | ❌         |
| regconfig     | ❌         |
| regdictionary | ❌         |
| regnamespace  | ❌         |
| regoper       | ❌         |
| regoperator   | ❌         |
| regproc       | ✅         |
| regprocedure  | ❌         |
| regrole       | ❌         |
| regtype       | ✅         |