/usr/share/postgresql/9.6/postgres.shdescription is in postgresql-9.6 9.6.11-0+deb9u1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1
1 pg_database default template for new databases