This file is indexed.

/usr/share/postgresql/9.5/extension/plpgsql--unpackaged--1.0.sql is in postgresql-9.5 9.5.14-0ubuntu0.16.04.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

1
2
3
4
5
6
7
/* src/pl/plpgsql/src/plpgsql--unpackaged--1.0.sql */

ALTER EXTENSION plpgsql ADD PROCEDURAL LANGUAGE plpgsql;
-- ALTER ADD LANGUAGE doesn't pick up the support functions, so we have to.
ALTER EXTENSION plpgsql ADD FUNCTION plpgsql_call_handler();
ALTER EXTENSION plpgsql ADD FUNCTION plpgsql_inline_handler(internal);
ALTER EXTENSION plpgsql ADD FUNCTION plpgsql_validator(oid);