Categories: Snippets

ADD new Column – pgSQL

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

 

Recent Posts

Generate Slug URL in MySQL

A slug is a short name using human-readable keywords to identify a web page. For…

7 years ago

How to use SQL LIKE condition with multiple values in PostgreSQL?

[crayon-692ebeb59832c763402751/]  

7 years ago

SELECT Null

[crayon-692ebeb598530862619465/]  

7 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-692ebeb5985fe592895568/]  

7 years ago

WITH RECURSIVE

[crayon-692ebeb5986bf774026013/]  

7 years ago