pg_stat_file ( filename text [, missing_ok boolean ] ) → record ( size bigint, access timestamp with time zone, modification timestamp with time zone, change timestamp with time zone, creation timestamp with time zone, isdir boolean )Returns a record containing the file's size, last access time stamp, last modification time stamp, last file status change time stamp (Unix platforms only), file creation time stamp (Windows only), and a flag indicating if it is a directory.
FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS
pg_stat_file
Read PG 18 manual ↗Returns a record containing the file's size, last access time stamp, last modification time stamp, last file status change time stamp (Unix platforms only), file creation time stamp (Windows only), and a flag indicating if it is a directory.
Signatures & examples
Version history 3
- PG 12 → 13changed
- PG 10 → 11changed
- PG 9.4 → 9.5changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source