Create and apply the SQL script

Submitted by abe on Thu, 08/05/2021 - 16:56
Description

The last step simply consists in creating a SQL file with the result of the regex substitution and apply it.
Create a new SQL file and copy / paste the content of the regex substitution function Apply the script on assertion-manager database with plsql :

psql -U gazelle -d assertion-manager < ~/yourPageUpdateFileName.sql

The assertion-manager database has a caching system. You may have to wait 3 minutes before seeing the changes on the pages numbers.

Specification status
Draft
Status
Available
Priority
Not prioritized
Is specific to a project ?
No