MIME-Version: 1.0
References: 
 <CA+M9Y+A7mUFRELeOu0g-3J+bgvf_wmuyhb+rE9X3KvLr7XQh9w@mail.gmail.com>
In-Reply-To: 
 <CA+M9Y+A7mUFRELeOu0g-3J+bgvf_wmuyhb+rE9X3KvLr7XQh9w@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Tue, 6 Aug 2024 16:24:57 +0500
Message-ID: 
 <CAAPsdheVt0wXNgNGTsP29udcbYe=htht5ZChgnW0ZxtHZzNKOA@mail.gmail.com>
Subject: Re: Pg_repack
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c089fe061f020be8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdheVt0wXNgNGTsP29udcbYe%3Dhtht5ZChgnW0ZxtHZzNKOA%40mail.gmail.com>
Precedence: bulk

--000000000000c089fe061f020be8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Sathish

It's better to script it using any scripting language e.g. SHELL Scripting
as PL/pgSQL etc don't allow accessing Utilities from stored procedures.

Thanks
Kashif Zeeshan

On Tue, Aug 6, 2024 at 4:10=E2=80=AFPM Sathish Reddy <
sathishreddy.postgresql@gmail.com> wrote:

> Hi
>   We planning to create store procedure (function) in postgres database t=
o
> run pg_repack on removing bloating of table or index by using within
> postgres instance.
>
>     Please help me on details on steps with example for same.
>
>
> Thanks
> Sathishreddy
>

--000000000000c089fe061f020be8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi Sathish</div><div><br></div><div>It&#39;s better t=
o script it using=C2=A0any scripting language e.g. SHELL Scripting as PL/pg=
SQL etc don&#39;t allow accessing Utilities=C2=A0from stored=C2=A0procedure=
s.</div><div><br></div><div>Thanks</div><div>Kashif Zeeshan</div><br><div c=
lass=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Aug 6, 2=
024 at 4:10=E2=80=AFPM Sathish Reddy &lt;<a href=3D"mailto:sathishreddy.pos=
tgresql@gmail.com">sathishreddy.postgresql@gmail.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><span=
 style=3D"font-size:12.8px">Hi=C2=A0</span><div dir=3D"auto" style=3D"font-=
size:12.8px">=C2=A0 We planning to create store procedure (function) in pos=
tgres database to run pg_repack on removing bloating of table or index by u=
sing within postgres instance.</div><div dir=3D"auto" style=3D"font-size:12=
.8px">=C2=A0=C2=A0</div><div dir=3D"auto" style=3D"font-size:12.8px">=C2=A0=
 =C2=A0 Please help me on details on steps with example for same.</div><div=
 dir=3D"auto" style=3D"font-size:12.8px"><br></div><div dir=3D"auto" style=
=3D"font-size:12.8px"><br></div><div dir=3D"auto" style=3D"font-size:12.8px=
">Thanks=C2=A0</div><div dir=3D"auto" style=3D"font-size:12.8px">Sathishred=
dy=C2=A0</div></div>
</blockquote></div></div>

--000000000000c089fe061f020be8--