2010/7/20 Fábio Gibon - Comex System <gi...@comexsystem.com.br> > 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 > 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_name Best regards, -- Fabrízio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com
