Dynamic Table Creation #psql #postgres

dynamic_table_create.sql

DO
$$
BEGIN
EXECUTE format('CREATE TABLE %I AS SELECT * FROM backup', 'backup_' || to_char(CURRENT_DATE,'yyyy-mm-dd'));
END;
$$ LANGUAGE plpgsql;


CREATE OR REPLACE FUNCTION fn_hello(v_table text)
returns void
AS $$

BEGIN
  EXECUTE format('create table rollback.%I (id int, name text)', v_table || '_' ||  to_char(CURRENT_DATE, 'yyyymmdd'));
END;

$$
LANGUAGE plpgsql;