Hi! I would also expect you to be able to make a Stored Procedure executing the same command, although I never tried it myself.
Bèrto On 8 September 2010 03:17, Fabrízio de Royes Mello <[email protected]>wrote: > > 2010/9/7 Isabella Ghiurea <[email protected]> > > 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 > > -- ============================== Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les droits du peuple, l'insurrection est, pour le peuple et pour chaque portion du peuple, le plus sacré des droits et le plus indispensable des devoirs.
