Custom vacuum

This is a multi-part message in MIME format.

------=_NextPart_000_003B_01CB2821.175EC630
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I want perform VACUUM on specific tables. This tables are result of =
query in my database (select tablename from mytablesvacuum). I tryed use =
a cursor=20
on function, but i receive message that vacuun can't run in function.=20

Any idea to do this?

tks
F=E1bio Henrique Gibon
Comex System Consultoria
------=_NextPart_000_003B_01CB2821.175EC630
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252"> href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">

Re: Custom vacuum

--0016e6434ae0d9728f048be4c657
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/7/20 F=E1bio Gibon - Comex System

> I want perform VACUUM on specific tables. This tables are result of quer=
y
> in my database (select tablename from mytablesvacuum). I tryed use a curs=
or
> on function, but i receive message that vacuun can't run in function.
>
> Any idea to do this?
>
>

Try this:

psql -U postgres -A -t your_database_name -c "SELECT 'VACUUM
'||tablename||';' FROM mytablesvacuum" | psql -U postgres your_database_nam=
e


Best regards,
--=20
Fabr=EDzio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com

--0016e6434ae0d9728f048be4c657
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable