Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

PG_LAST_UNLOAD_COUNT()

Returns the number of rows that were unloaded by the last UNLOAD command executed in the current session. PG_LAST_UNLOAD_COUNT is updated with the query ID of the last UNLOAD, even if the operation failed. The query ID is updated when the UNLOAD is executed. If the UNLOAD fails because of a syntax error or because of insufficient privileges, PG_LAST_UNLOAD_COUNT returns the count for the previous UNLOAD. If no UNLOAD commands were executed in the current session, or if the last UNLOAD failed during the unload operation, PG_LAST_UNLOAD_COUNT returns 0.

Syntax

Copy
pg_last_unload_count()

Return Type

Returns BIGINT.

Example

The following query returns the number of rows unloaded by the latest UNLOAD command in the current session.

Copy
select pg_last_unload_count(); pg_last_unload_count -------------------- 192497 (1 row)

On this page: