Skip to main content
All CollectionsDatabase Object and Feature Support
PostgreSQL and AlloyDB Support Summary
PostgreSQL and AlloyDB Support Summary

Postgres and AlloyDB object and data type support summary

S
Written by Serge Gershkovich
Updated this week

This article summarizes the features, objects, properties, and data types that are available for PostgreSQL and AlloyDB projects.

Objects and properties

  • Schemas

    • Comment/Description

  • Tables

    • Constraints

    • Index

      • Columns

      • Where

      • Only (not to recurse)

      • Method

        • Brin

        • Btree

        • Gin

        • Gist

        • Hash

        • Spgist

      • Tablespace

      • Deferrable

      • Initially deferred

      • Fill factor

      • Vacuum cleanup index scale factor

      • Buffering

      • FastUpdate

      • Gin pending list limit

      • Pages per range

      • Auto summarize

      • Comment/Description

    • Partitions (Partitioning Key)

      • Range

      • List

      • Hash

    • Options

      • Unlogged

      • Tablespace

    • Storage Options

      • Has OIDS

      • User catalog table

      • Fill factor

      • Toast tuple target

      • Parallel workers

      • Toast storage options

        • Auto-vacuum enabled

        • Vacuum threshold

        • Vacuum scale factor

        • Vacuum cost delay

        • Vacuum cost limit

        • Freeze min age

        • Freeze max age

        • Freeze table age

        • Multixact freeze min age

        • Multixact freeze max age

        • Multixact freeze table age

        • Log min duration

    • Comment/Description

    • Post Script

  • Views

    • Materialized

    • Recursive

    • Temporary

    • Secure

    • Check Option

  • Columns

    • Data type (see summary of types below)

    • (NOT) NULL

    • Default

    • Identity

      • Start

      • Increment

      • Cache

      • Min

      • Max

      • Cycle

    • Collation

    • Comment/Description

Data types

  • Numeric Data Types

    • DECIMAL

    • NUMERIC

    • INTEGER

    • INT

    • MONEY

    • SERIAL

    • REAL

    • DOUBLE PRECISION

  • String & Binary Data Types

    • VARCHAR

    • CHARACTER VARYING

    • CHARACTER

    • CHAR

    • TEXT

    • TSQUERY

    • TSVECTOR

  • Logical Data Types

    • BOOLEAN

  • Date & Time Data Types

    • DATE

    • TIME

    • INTERVAL

    • TIMESTAMP

    • TIMESTAMP WITH TIME ZONE

    • TIME WITH TIME ZONE

    • INTERVAL YEAR

    • INTERVAL MONTH

    • INTERVAL DAY

    • INTERVAL HOUR

    • INTERVAL MINUTE

    • INTERVAL SECOND

    • INTERVAL YEAR TO MONTH

    • INTERVAL DAY TO HOUR

    • INTERVAL DAY TO MINUTE

    • INTERVAL DAY TO SECOND

    • INTERVAL HOUR TO MINUTE

    • INTERVAL HOUR TO SECOND

    • INTERVAL MINUTE TO SECOND

  • Geospatial Data Types

    • POINT

    • POLIGON

    • LINE

    • LSEG

    • BOX

    • PATH

    • CIRCLE

  • String Bit Data Types

    • BIT

    • BIT VARYING

  • Network Address Data Types

    • CIDR

    • INET

    • MACADDR

    • MACADDR8

  • UUID Data Types

    • UUID

    • XML

    • JSON

    • JSONB

  • Built-in Range

    • INT4RANGE

    • INT8RANGE

    • NUMRANGE

    • TSRANGE

    • TSTRANGE

    • DATERANGE

  • Object Identifier Data Types

    • OID

    • REGPROC

    • REGPROCEDURE

    • REGOPER

    • REGOPERATOR

    • REGCLASS

    • REGTYPE

    • REGROLE

    • REGNAMESPACE

    • REGCONFIG

    • REGDICTIONARY

  • Pg_lsn Data Types

    • PG_LSN

  • user-level transaction ID snapshot

    • TXID_SNAPSHOT

See also:

Did this answer your question?