Default a Column’s Value

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
edited October 30 in Vertica Tips

You can specify a table column's default value using a DEFAULT expression. Vertica evaluates the DEFAULT expression and sets the column on load operations, if the operation omits a value for the column.

Examples:

dbadmin=> CREATE TABLE a (b INT, c TIMESTAMP DEFAULT sysdate);
CREATE TABLE

dbadmin=> INSERT INTO a (b) SELECT 1;
OUTPUT
--------
      1
(1 row)

dbadmin=> SELECT * FROM a;
b |             c
---+----------------------------
1 | 2018-10-29 03:42:33.793011
(1 row)

Helpful Links:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/column-constraint.htm

Have fun!

Sign In or Register to comment.