0
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.