Version Control

Top  Previous  Next

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: