Skip to content

Instantly share code, notes, and snippets.

@mattmc3

mattmc3/alter_table.sql

Created February 21, 2025 00:35
Show Gist options
  • Save mattmc3/687484bc39512ef736927269784e1f72 to your computer and use it in GitHub Desktop.
Save mattmc3/687484bc39512ef736927269784e1f72 to your computer and use it in GitHub Desktop.
Download ZIP
Add audit fields to pg table
Raw
alter_table.sql
ALTER TABLE public.mytable
ADD COLUMN add_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN add_user VARCHAR(255) NOT NULL DEFAULT current_user,
ADD COLUMN change_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN change_user VARCHAR(255) NOT NULL DEFAULT current_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment