calling vacuum from a script

From: Janet Jacobsen <jsjacobsen(at)lbl(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: calling vacuum from a script
Date: 2010-06-23 03:44:51
Message-ID: AANLkTimXVEZlropPnH3qmXhqPem7nv83GgnEgJ5jr0yj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. Is it possible to vacuum a table (vacuum full analyze)
from a script. Currently I run the Postgres client and then
run vacuum, but I'd like to automate the vacuum by calling
it from a (Perl) script.

Thanks,
Janet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janet Jacobsen 2010-06-23 03:52:15 best way to check pgdump
Previous Message Sam Wun 2010-06-23 03:17:06 Re: how to create an admin user for restore database.