About the Examples Used in this Guide v12
The examples shown in this guide are illustrated using the PSQL program. The prompt that normally appears when using PSQL is omitted in these examples to provide extra clarity for the point being demonstrated.
Also note the following points:
During installation of the EDB Postgres Advanced Server the selection for configuration and defaults compatible with Oracle databases must be chosen in order to reproduce the same results as the examples shown in this guide. A default compatible configuration can be verified by issuing the following commands in PSQL and obtaining the same results as shown below.
The examples use the sample tables,
dept
,emp
, andjobhist
, created and loaded when Advanced Server is installed. Theemp
table is installed with triggers that must be disabled in order to reproduce the same results as shown in this guide. Log onto Advanced Server as theenterprisedb
superuser and disable the triggers by issuing the following command.The triggers on the
emp
table can later be re-activated with the following command.