Skip to main content

PostgreSQL and AlloyDB Support Summary

SqlDBM Support
Updated

 

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

    • Partitioning Key

      • Range

      • List

      • Hash

    • Partitions (defined as part of the partitioning key)

      • Schema

      • Name

      • For values

        • Value from

        • Value to

      • Default

    • 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

    • POLYGON

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

Related articles