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…

5 years ago

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

[crayon-662fb20c39f06481235277/]  

6 years ago

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

[crayon-662fb20c3a090540562181/]  

6 years ago

SELECT Null

[crayon-662fb20c3a205889023411/]  

6 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-662fb20c3a356632990661/]  

6 years ago

WITH RECURSIVE

[crayon-662fb20c3a4a4019044587/]  

6 years ago