Re: vacuumdb for schema only

2010/9/7 Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>

> Hi List,
> I would like to know if there is an option to run full vacuumdb for a
> specific schema only, I see there is option for tables or whole db .
>
>
No, but you can do like this using "psql" :

psql -U postgres -t -A -c "select 'VACUUM
'||table_schema||'.'||table_name||';' from information_schema.tables where
table_schema = 'public'" bdteste | psql -U postgres bdteste

The example above will run VACUUM to all tables in schema called 'public' in
'bdteste' database.

Best regards,

--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello