At 13.34 18/04/2005, you wrote:
CREATE OR REPLACE FUNCTION reindex_database RETURNS VOID AS '
DECLARE
row RECORD;
tquery TEXT;
BEGIN
FOR row IN EXECUTE 'select pg_tables.schemaname || ''.'' || pg_tables.tablename as tablename from pg_tables where upper(pg_tables.tableowner) <> ''POSTGRES'' '
LOOP
tquery := 'REINDEX TABLE ' || row.tablename;
RAISE NOTICE 'Reindexing: %', tquery;
EXECUTE tquery;
END LOOP;
RETURN;
END;
' LANGUAGE plpgsql;