Thanks. I'm trying to automate the database set up of a web application that uses PostgreSQL, so basically wrapping the following steps into a program:
- drop database if exists ...
- drop role ...
- create role ...
- create database ...
- some other database stuff
The DropDB method may work. But ExecuteDirect's documentation states that it will use the "default" transaction. Anyhow, I will try it and if it fails then try the postgres unit next.