I’ve a variable all_dt, which contains the following dates (first date is called stard_dt and second date is end_dt)

all_dt=
2024-05-02|2024-05-03 
2019-06-25|2019-12-31
2020-01-01|2020-12-31
2021-01-01|2021-12-31
2022-01-01|2022-12-31
2023-01-01|2023-12-31
2024-01-01|2024-01-15

Question is, how can I then use date values from all_dt as loop (while or any other loop) and assign first date as “start_dt, and second date as and end_dt?

for example, using date values from all_dt variable in loop to call following function:

 psql -c "SELECT my_function_name('target_table_name,'${start_dt','${end_dt}');" -d ${database_name}    

When loop runs, above function will be called as many times as there are dates in the all_dt variable, for instance like below:

psql -c "SELECT my_function_name('target_table_name,'2024-05-02','2024-05-03');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2019-06-25','2019-12-31');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2020-01-01','2020-12-31');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2021-01-01','2021-12-31');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2022-01-01','2022-12-31');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2023-01-01','2023-12-31');" -d ${database_name} 
psql -c "SELECT my_function_name('target_table_name,'2024-01-01','2024-01-15');" -d ${database_name}