Add default values for columns

[zipperer]

e.g. in mailing_list

country defaults to USA add_date defaults to NOW() / today modification_date defaults to NOW() / today

[zipperer]

add_date defaults to NOW() / today modification_date defaults to NOW() / today

We did an example of this in this issue

[zipperer]

country defaults to USA

I have provided a TEXT column with a default value

CREATE TABLE table_with_default_values (
  int_with_default_value INT DEFAULT 514,
  text_with_default_value TEXT DEFAULT 'USA'
);

INSERT INTO table_with_default_values (int_with_default_value) VALUES (2);
-- table includes row with int_with_default_value = 2 and text_with_default_value = 'USA'

INSERT INTO table_with_default_values (text_with_default_value) VALUES ('CAN');
-- table includes row with int_with_default_value = 514 and text_with_default_value = 'CAN'

[zipperer]

postgres documentation for default values

[zipperer]

I close this issue because we have used steps like these. See #35