Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Unsupported PostgreSQL functions - Amazon Redshift

Unsupported PostgreSQL functions

Many functions that are not excluded have different semantics or usage. For example, some supported functions will run only on the leader node. Also, some unsupported functions will not return an error when run on the leader node. The fact that these functions do not return an error in some cases should not be taken to indicate that the function is supported by Amazon Redshift.

Important

Do not assume that the semantics of elements that Amazon Redshift and PostgreSQL have in common are identical. Make sure to consult the Amazon Redshift Database Developer Guide SQL commands to understand the often subtle differences.

For more information, see SQL functions supported on the leader node.

These PostgreSQL functions are not supported in Amazon Redshift.

  • Access privilege inquiry functions

  • Advisory lock functions

  • Aggregate functions

    • STRING_AGG()

    • ARRAY_AGG()

    • EVERY()

    • XML_AGG()

    • CORR()

    • COVAR_POP()

    • COVAR_SAMP()

    • REGR_AVGX(), REGR_AVGY()

    • REGR_COUNT()

    • REGR_INTERCEPT()

    • REGR_R2()

    • REGR_SLOPE()

    • REGR_SXX(), REGR_SXY(), REGR_SYY()

  • Array functions and operators

  • Backup control functions

  • Comment information functions

  • Database object location functions

  • Database object size functions

  • Date/Time functions and operators

    • CLOCK_TIMESTAMP()

    • JUSTIFY_DAYS(), JUSTIFY_HOURS(), JUSTIFY_INTERVAL()

    • PG_SLEEP()

    • TRANSACTION_TIMESTAMP()

  • ENUM support functions

  • Geometric functions and operators

  • Generic file access functions

  • IS DISTINCT FROM

  • Network address functions and operators

  • Mathematical functions

    • DIV()

    • SETSEED()

    • WIDTH_BUCKET()

  • Set returning functions

    • GENERATE_SERIES()

    • GENERATE_SUBSCRIPTS()

  • Range functions and operators

  • Recovery control functions

  • Recovery information functions

  • ROLLBACK TO SAVEPOINT function

  • Schema visibility inquiry functions

  • Server signaling functions

  • Snapshot synchronization functions

  • Sequence manipulation functions

  • String functions

    • BIT_LENGTH()

    • OVERLAY()

    • CONVERT(), CONVERT_FROM(), CONVERT_TO()

    • ENCODE()

    • FORMAT()

    • QUOTE_NULLABLE()

    • REGEXP_MATCHES()

    • REGEXP_SPLIT_TO_ARRAY()

    • REGEXP_SPLIT_TO_TABLE()

  • System catalog information functions

  • System information functions

    • CURRENT_CATALOG CURRENT_QUERY()

    • INET_CLIENT_ADDR()

    • INET_CLIENT_PORT()

    • INET_SERVER_ADDR() INET_SERVER_PORT()

    • PG_CONF_LOAD_TIME()

    • PG_IS_OTHER_TEMP_SCHEMA()

    • PG_LISTENING_CHANNELS()

    • PG_MY_TEMP_SCHEMA()

    • PG_POSTMASTER_START_TIME()

    • PG_TRIGGER_DEPTH()

    • SHOW VERSION()

  • Text search functions and operators

  • Transaction IDs and snapshots functions

  • Trigger functions

  • XML functions

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.