How do I create custom search attributes during system setup with pgsql as the visibility store db

Hi there,

We’re trying to add custom search attributes during system installation. The documentation seems a bit outdated / incomplete so I come here seeking the wisdom of practitioners / maintainers to understand how to add custom search attributes during system startup (not using the cli).

The visbility documentation Self-hosted Visibility feature setup | Temporal Documentation tells me that the visibility store setup happens in auto-setup.sh, which uses temporal-sql-tool to I run sql statements I presume, but thusfar I am unable to find an example or documentation on where to add which statements to add my custm search attributes during the installation proces.

Some pointers to the appropriate documentation (if any) or an example file (and how to wire that into the setup) would be greatly appreciated. Any other way that ds use the cli in a way that allows us to add the attributes during installation would be equally valueable for us.