default
.rst
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
upsert_timestamp_columns(schema_name text, table_name text, updated_at_only boolean DEFAULT false)
Parameters
Name
Type
Mode
schema_name
text
IN
table_name
text
IN
updated_at_only
boolean
IN
Definition
begin if updated_at_only then execute format('alter table %I.%I add column if not exists updated_at timestamp default now()', schema_name, table_name); else execute format('alter table %I.%I add column if not exists updated_at timestamp default now()', schema_name, table_name); execute format('alter table %I.%I add column if not exists updated_by text', schema_name, table_name); execute format('alter table %I.%I add column if not exists created_at timestamp default now()', schema_name, table_name); execute format('alter table %I.%I add column if not exists created_by text', schema_name, table_name); end if; end;