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;

 

Share

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 NOT LIKE condition with multiple values in PostgreSQL?

[crayon-68bdf41ef2f65002441747/]  

7 years ago

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

[crayon-68bdf41ef3228494233826/]  

7 years ago

SELECT Null

[crayon-68bdf41ef33b9906883926/]  

7 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-68bdf41ef3576717820667/]  

7 years ago

WITH RECURSIVE

[crayon-68bdf41ef3660038955270/]  

7 years ago