Supported PostgreSQL Data Type

[dhamanutd]

List of postgres data type that not yet or already recognised by raiden imports/apply

PostgreSQL/PostgREST Data Type	Golang Data Type	From PostgreSQL -> Go	From Go -> PostgreSQL
smallint	int16	✔	✔
integer	int32	✔	✔
bigint	int64	✔	✔
decimal	float64	✔	✘
numeric	float64	✔	✘
real	float32	✔	✔
double precision	float64	✔	✔
smallserial	int16	✔	✔
serial	int32	✔	✔
bigserial	int64	✔	✔
character varying	string	✔	✔
varchar	string	✔	✔
character	string	✔	✘
char	string	✔	✔
bpchar	string	✔	✘
text	string	✔	✔
bytea	[]byte	✘	✘
timestamp without time zone	time.Time	✔	✔
timestamp	time.Time	✔	✔
timestamp with time zone	time.Time	✔	✔
timestampz	time.Time	✔	✔
date	time.Time	✔	✔
time without time zone	time.Time	✔	✔
time	time.Time	✔	✔
time with time zone	time.Time	✔	✔
timez	time.Time	✔	✔
interval	time.Duration	✔	✔
boolean	bool	✔	✔
uuid	uuid.UUID	✔	✔
json	interface{} / map[string]interface{}	✔	✘
jsonb	interface{} / map[string]interface{}	✔	✘
int4range	string	✘	✘
int8range	string	✘	✘
numrange	string	✘	✘
tsrange	string	✘	✘
tstzrange	string	✘	✘
daterange	string	✘	✘
smallint[]	[]int16	✘	✘
integer[]	[]int32	✘	✘
bigint[]	[]int64	✘	✘
decimal[]	[]float64	✘	✘
numeric[]	[]float64	✘	✘
real[]	[]float32	✘	✘
double precision[]	[]float64	✘	✘
boolean[]	[]bool	✘	✘
character varying[]	[]string	✘	✘
varchar[]	[]string	✘	✘
character[]	[]string	✘	✘
char[]	[]string	✘	✘
text[]	[]string	✘	✘
bytea[]	[][]byte	✘	✘
timestamp without time zone[]	[]time.Time	✘	✘
timestamp[]	[]time.Time	✘	✘
timestamp with time zone[]	[]time.Time	✘	✘
timestampz[]	[]time.Time	✘	✘
date[]	[]time.Time	✘	✘
time without time zone[]	[]time.Time	✘	✘
time[]	[]time.Time	✘	✘
time with time zone[]	[]time.Time	✘	✘
timez[]	[]time.Time	✘	✘
interval[]	[]time.Duration	✘	✘
uuid[]	[]uuid.UUID	✘	✘
json[]	[]interface{} / []map[string]interface{}	✘	✘
jsonb[]	[]interface{} / []map[string]interface{}	✘	✘