All Collections
Database Object and Feature Support
PostgreSQL and AlloyDB Support Summary
PostgreSQL and AlloyDB Support Summary

PostgreSQL and AlloyDB object and data type support summary

S
Written by Serge Gershkovich
Updated over a week ago

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

For more info on working with AlloyDB, see this article.

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

    • 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

  • 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?