Answers for "alter table add column if not exists postgres to "multiple" tables"

add column if not exists postgresql

ALTER TABLE table_name ADD COLUMN IF NOT EXISTS column_name INTEGER;

Posted by: Guest on February-17-2021

alter table add multiple columns postgresql

ALTER TABLE customer 
ADD COLUMN fax VARCHAR,
ADD COLUMN email VARCHAR;

Posted by: Guest on May-26-2020

Code answers related to "alter table add column if not exists postgres to "multiple" tables"