Help Center/ Relational Database Service/ User Guide/ Working with RDS for PostgreSQL/ RDS for PostgreSQL Enhanced Edition/ Macro Variables
Updated on 2024-10-14 GMT+08:00
View PDF
Share

Macro Variables

This section describes the macro variables added to RDS for PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open-source edition.

  • SYSDATE: indicates the current system time.
  • SYSTIMESTAMP: indicates the current system timestamp.
  • DBTIMEZONE: indicates the current database time zone.
  • SESSIONTIMEZONE: indicates the current session time zone.
  • ROWNUM: indicates the tuple number in the query results.
Parent Topic: RDS for PostgreSQL Enhanced Edition