To create the Perceptive Content INOW Database, complete the following steps.
Log in to the postgres database as the postgres user.
Execute the PostgreSQL version of the full DDL script: SunflowerPG.sql.
Note: You must execute thePerceptive Content DDL
scriptsfrom the command line using thePSQL utility.Specific psql commands
within the script will not work with GUI tools, such as pgAdmin
III.
EXAMPLE CONNECT STRING:
psql -h <IP_ADDRESS or localhost> -d postgres -U postgres -p 5432
EXAMPLE OF EXECUTING A SCRIPT WITHIN PSQL:
\i C:/DDL/7.3.0/ddl/SunflowerPG.sql
\i 'C:/DDL/7.3.0/ddl/SunflowerPG.sql'