<div dir="ltr">Hi, All,<div><br></div><div>Are there examples of using <span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">ALTER INDEX [ IF EXISTS ] </span><tt class="gmail-REPLACEABLE gmail-c2" style="color:inherit;font-size:0.9rem;box-sizing:border-box;font-weight:900;font-style:italic;border-radius:0.25rem;margin:0.6rem 0px">name</tt><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"> SET ( </span><tt class="gmail-REPLACEABLE gmail-c2" style="color:inherit;font-size:0.9rem;box-sizing:border-box;font-weight:900;font-style:italic;border-radius:0.25rem;margin:0.6rem 0px">storage_parameter</tt><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"> = </span><tt class="gmail-REPLACEABLE gmail-c2" style="color:inherit;font-size:0.9rem;box-sizing:border-box;font-weight:900;font-style:italic;border-radius:0.25rem;margin:0.6rem 0px">value</tt><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"> [, ... ] )?</span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"><br></span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">Ideally, I would like to try to do the following:</span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"><br></span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">1. Assign a value to a string variable</span></div><div><font color="#0d0a0b" face="monospace, monospace"><span style="font-size:14.4px">2. Concatenate the string variable with today's date</span></font></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">3. Rename the index to this new value of the variable</span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"><br></span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">Can we do this in postgresql?</span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"><br></span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">Regards,</span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px"><br></span></div><div><span style="background-color:rgb(248,249,250);color:rgb(13,10,11);font-family:monospace,monospace;font-size:14.4px">Shao </span></div></div>