pg_ls_logicalmapdir()

A function providing information about files in pg_logical/mappings

pg_ls_logicalmapdir() is a system function for examining the contents of the directory pg_logical/mappings.

pg_ls_logicalmapdir() was added in PostgreSQL 15.

Usage

pg_ls_logicalmapdir ()
        →  setof record ( name text, size bigint, modification timestamp with time zone )

pg_ls_logicalmapdir() returns a list of all normal files in the pg_logical/mappings directory together with their size and modification timestamp.

Note that the rows are not returned in any particular order, so it may be useful to add an explicit sort criteria.

Change history

Categories

Data directory, File access and manipulation, Logical replication, System function

See also

pg_ls_logicalsnapdir()