...

#!/bin/bash

DBNAME="ddata"
VCOMMAND="VACUUM ANALYZE"

psql -tc "select '$VCOMMAND' || ' pg_catalog.' || relname || ';' from pg_class a,pg_namespace b where a.relnamespace=b.oid and b.nspname= 'pg_catalog' and a.relkind='r'" $DBNAME | psql -a $DBNAME

About this Wiki

How to get permission to edit

• Create a Confluence account if you don't already have one.
• Sign up for the user mailing list by sending a message to user-subscribe@hawq.incubator.apache.org.
• Send a message to user@hawq.incubator.apache.org:
  • Request write access to the Apache HAWQ project wiki: https://cwiki.apache.org/confluence/display/HAWQ
  • Provide your Confluence username.