[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Examples of use of ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter = value [,
From:       Shaozhong SHI <shishaozhong () gmail ! com>
Date:       2020-04-07 12:32:24
Message-ID: CA+i5JwbFZZMtzOcjk-npF4VcR0V90yy0oBYe86-8mOGRuZMxqg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi, All,

Are there examples of using ALTER INDEX [ IF EXISTS ] name SET (
storage_parameter = value [, ... ] )?

Ideally, I would like to try to do the following:

1. Assign a value to a string variable
2. Concatenate the string variable with today's date
3. Rename the index to this new value of the variable

Can we do this in postgresql?

Regards,

Shao

[Attachment #5 (text/html)]

<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&#39;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>


[Attachment #6 (text/plain)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]