PostgreSQL Create Table With Dynamic Table Name

Fazlı Akça - Nov 7 '23 - - Dev Community
DO
$$
BEGIN
    EXECUTE 'create table zz_find_entity'  ||  TO_CHAR(CURRENT_TIMESTAMP,'YYYYMMDD_HH24MISS') || ' AS  select * from find_entity';
END
$$;

Enter fullscreen mode Exit fullscreen mode
. . . . . . . .
Terabox Video Player