CREATE OR REPLACE procedure create_table_dateWise21()
LANGUAGE plpgsql
as $$
BEGIN
EXECUTE format('
CREATE TABLE IF NOT EXISTS test21 (
nodeip text,
interface text,
nodeip_interface text
)');
commit;
end;
$$;
if we ‘call create_table_dateWise21()’. It create only test21 table but i want every time new table with the same columns
Go to Source
Author: Aslam