Postgres data types

Get started with commonly-used Postgres data types with Neon's data type guides. For other data types that Postgres supports, visit the official Postgres Data Types documentation.

• Array

  Manage collections of elements using arrays

• Boolean

  Represent truth values in Postgres

• Date and time

  Work with date and time values in Postgres

• Character

  Work with text data in Postgres

• JSON

  Model JSON data in Postgres

• Decimal

  Work with exact numerical values in Postgres

• Floating point

  Work with float values in Postgres

• Integer

  Work with integers in Postgres

• Tsvector

  Optimize full-text search in Postgres with the tsvector data type

• UUID

  Work with UUIDs in Postgres