Creating PostgreSQL Tables

A script has been added for creating Postgres tables.

Procedure

  1. Create a tablespace for the Order Capture System database by running the following script: $OM_HOME/db/postgreSQL/oms/dbscripts/create_tablespace.sql.
  2. Create the database user for Order Capture System by running the following script: $OM_HOME/db/postgreSQL/oms/dbscripts/create_user.sql.
  3. Run the following script: $OM_HOME/db/PostgreSQL/ocs/ocs_schema_ddl.sql
    Or you can copy ocs_schema_ddl.sql to $OM_HOME/db/postgreSQL/oms/dbscripts and run setup.sh or setup.cmd from $OM_HOME/db/postgreSQL/oms/.