A function providing information about files in pg_logical/mappings
This entry relates to a PostgreSQL feature which is part of PostgreSQL 15, due to be released in late 2022.

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.


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


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

See also