The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Default a Column’s Value

Jim_KnicelyJim_Knicely Administrator
edited January 31 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.

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.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/column-constraint.htm

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.