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…

6 years ago

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

[crayon-67a34e94ce3c4001998869/]  

6 years ago

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

[crayon-67a34e94ce53e693561069/]  

6 years ago

SELECT Null

[crayon-67a34e94ce718366776756/]  

6 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-67a34e94ce8a5682381892/]  

6 years ago

WITH RECURSIVE

[crayon-67a34e94ce97f591649210/]  

6 years ago