1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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!
beantwortet vor 2 Jahren
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
thank you Milind! This should work :)