CREATE OR REPLACE FUNCTION check_table_corrupt()
  RETURNS VOID AS
$BODY$
DECLARE

BEGIN

    FOR vTableName IN SELECT tablename FROM pg_catalog.pg_tables where schemaname = 'public' ORDER BY tablename LOOP
        BEGIN
            EXECUTE 'CREATE TABLE ' || vTableName || '_backup AS SELECT * FROM ' || vTableName;
            RAISE NOTICE 'SUCCESFULLY CREATED TABLE BACKUP FOR : %', vTableName;
        EXCEPTION WHEN OTHERS THEN
            RAISE NOTICE 'ERROR CREATED TABLE BACKUP FOR : %', vTableName;
    END LOOP;

END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;