Unsupported PostgreSQL Data Types
Generally, if a query attempts to use an unsupported data type, including explicit or implicit casts, it will return an error. However, some queries that use unsupported data types will run on the leader node but not on the compute nodes. See SQL Functions Supported on the Leader Node.
For a list of the supported data types, see Data Types.
These PostgreSQL data types are not supported in Amazon Redshift.
BIT, BIT VARYING
Network Address Types
SERIAL, BIGSERIAL, SMALLSERIAL
Object Identifier Types
Text Search Types