Single Postgres DB with multiple temporal and temporal_visibility schemas

[raj_chinni]

Hi Team,

The current automation creates database with name temporal and temporal_visibility, how to use the automation to create multiple schemas in single database like qa_temporal and qa_temporal_visibility in same database.

GitHub - temporalio/helm-charts: Temporal Helm charts

./temporal-sql-tool create-database -database temporal
./temporal-sql-tool create-database -database temporal_visibility

temporalio/temporal/blob/release/v1.20.x/schema/postgresql/v12/temporal/database.sql#L1

Thanks,
-Raj

[raj_chinni]

exporting the SQA_DATABASE and updating the database name in temporalio/temporal/blob/release/v1.20.x/schema/postgresql/v12/temporal/database.sql#L1 worked.
export SQL_DATABASE=qa_temporal