ADD new Column - pgSQL

ADD new Column – pgSQL

ALTER TABLE mytable ADD COLUMN mycolumn character varying(50);

1	ALTER TABLE mytable ADD COLUMN mycolumn character varying(50);

ALTER TABLE mytable ADD COLUMN mycolumn character varying(50) DEFAULT 'whatever' NOT NULL;

1	ALTER TABLE mytable ADD COLUMN mycolumn character varying(50) DEFAULT 'whatever' NOT NULL;