I created a prerequisite to call the PostgreSQL installer by command line with switches. Hopefully this works. Is there a better way to install it?
Once PostgreSQL is installed, I need to run a SQL script to create the database and tables. What is the best method for doing this since it appears InstallShield supports several SQL RDBMSs except PostgreSQL?
Unfortunately, InstallShield does not currently offer the built-in support for PostgreSQL.The work order #IOC-000071843 has been filed to take into consideration for a future release. For now, you need to write your own code for establishing a connection and executing your scripts against PostgreSQL. You should be able to find helpful sample code in this community forum like this.
