Can my DB?

Data Types

Native data types including arrays, UUIDs, enums, intervals, and custom types.

0 features
but not in
Array Data Type
A column type holding an ordered list of same-typed values, queryable and (in some engines) indexable as a single column.
ARRAYarray columnmulti-valued column
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Enum / Domain Types
User-defined types representing a fixed set of allowed string values, enforced by the database.
ENUMCREATE TYPE AS ENUMdomainenumerated typelookup type
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Network Address Types
Native data types for IP addresses, network CIDR blocks, and MAC addresses with built-in operators and functions.
inetcidrmacaddrIP addressnetwork typeCIDR
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Range Types
Native types representing a range of values (e.g., date ranges, numeric ranges) with built-in operators for overlap, containment, and adjacency.
range typedaterangetsrangeint4rangenumrangeRange&&@>range overlap
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
UUID Data Type
A column type dedicated to 128-bit UUID values, with native comparison and (on some engines) built-in generators.
UUIDGUIDUNIQUEIDENTIFIERRAW(16)
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
XML Type
Native XML data type with built-in XML parsing, XPath/XQuery querying, and XML construction functions.
XMLXMLTypexml data typeXQueryXPathFOR XMLXMLTABLE
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery