1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
Below I have given a stored procedure that accepts parameters and will perform the column addition if column does not exist.
CREATE OR REPLACE PROCEDURE add_table_column(s_name varchar, t_name varchar, c_name varchar, c_type varchar)
LANGUAGE plpgsql
AS $$
BEGIN
IF (SELECT count(1) FROM pg_catalog.pg_table_def
WHERE schemaname = s_name
AND tablename = t_name
AND "column" = c_name
) = 0
THEN
execute 'ALTER TABLE '||s_name||'.'||t_name||' ADD COLUMN '||c_name||' '||c_type;
END IF;
END;
$$
;
create table public.tst (col1 numeric);
call add_table_column('public','tst','col2','numeric');
Hope this helps!
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
thank you Milind! This should work :)