Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Default a Column’s Value

Jim_KnicelyJim_Knicely Administrator
edited January 2019 in Tips from the Team

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.


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

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

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

Helpful Links:

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.