Amazon Redshift supports numerous system information functions.
CURRENT_AWS_ACCOUNT
CURRENT_DATABASE
CURRENT_NAMESPACE
CURRENT_SCHEMA
CURRENT_SCHEMAS
CURRENT_SESSION_ARN
CURRENT_USER
CURRENT_USER_ID
DEFAULT_IAM_ROLE
GET_MOUNTED_ROLE
HAS_ASSUMEROLE_PRIVILEGE
HAS_DATABASE_PRIVILEGE
HAS_SCHEMA_PRIVILEGE
HAS_TABLE_PRIVILEGE
LAST_USER_QUERY_ID
PG_BACKEND_PID
PG_GET_COLS
PG_GET_GRANTEE_BY_IAM_ROLE
PG_GET_IAM_ROLE_BY_USER
PG_GET_LATE_BINDING_VIEW_COLS
PG_GET_SESSION_ROLES
PG_LAST_COPY_COUNT
PG_LAST_COPY_ID
PG_LAST_UNLOAD_ID
PG_LAST_QUERY_ID
PG_LAST_UNLOAD_COUNT
SLICE_NUM Function
USER
ROLE_IS_MEMBER_OF
USER_IS_MEMBER_OF
VERSION
Javascript is disabled or is unavailable in your browser.
To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.
Thanks for letting us know we're doing a good job!
If you've got a moment, please tell us what we did right so we can do more of it.
Thanks for letting us know this page needs work. We're sorry we let you down.
If you've got a moment, please tell us how we can make the documentation better.