The provided version control system asks the user if they would like it enabled the first time the tab is clicked.
If the user agrees a table prefixed with pg_ is created in the database to store the version information.
CREATE TABLE pg_version_history
(
vh_id serial NOT NULL,
vh_modify_date timestamp NOT NULL,
vh_user_name varchar(35),
vh_user_fullname varchar(100),
vh_object_type int2 NOT NULL,
vh_object_name varchar(300) NOT NULL,
vh_body text,
vh_description text,
vh_object_oid int4,
vh_schema varchar(50),
CONSTRAINT pk_pg_version_history PRIMARY KEY (vh_id)
)
WITHOUT OIDS;
This version information is then available to all user who modify the function.
Versions may also be compared:
