• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. DWS and Postgres SQL
  6. Function Differences

Function Differences

For details about supported functions in DWS, see Functions and Operators.

The following PostgreSQL functions are not supported in DWS:

  • Enumerate functions
  • XML functions
  • Access privilege inquiry functions
    • has_sequence_privilege(user, sequence, privilege)
    • has_sequence_privilege(sequence, privilege)
  • System catalog information functions
    • pg_get_triggerdef(trigger_oid)
    • pg_get_triggerdef(trigger_oid, pretty_bool)
  • Line functions
  • pg_node_tree