You can specify a table column’s default value using a DEFAULT expression. If the operation omits a value for the column, Vertica evaluates the DEFAULT expression and sets the column on load operations.
Example:
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/latest/HTML/index.htm#Authoring/SQLReferenceManual/Statements/column-constraint.htm
Have fun!
About the Author
Phil Molea
Sr. Information Developer, Vertica
Phil developed technical documentation in the areas of security and diagnostics for the Vertica Analytics Platform that enabled companies to extract value from their data at the speed and scale they need to thrive in today’s economy.
(Sadly, Phil passed away recently. He will be missed.)
