db='/var/lib/pacman/local'

dirs=($(grep -h "/$" $db/*/files))

for d in ${dirs[@]}; do
  grep -q "^${d%%\/}$" $db/*/files
  if (( $? == 0 )); then
    echo "Directory symlink assumed: $d"
    packages=($(grep -l "^${d}$" $db/*/files))
    for p in ${packages[@]}; do
      t=${p%%/files}
      echo "  Package: ${t#/var/lib/pacman/local/}"
    done
  fi
done