Create a database with FME?

Is it possible to create a PostGIS database with FME ?

Page 1 / 1

Yes, but only manually. You can use a SQLCreator or SQLExecutor to do something like:

CREATE DATABASE my_database
  WITH OWNER = my_db_owner
       ENCODING = 'UTF8'
       TABLESPACE = my_tablespace

Then, in a second SQLExecutor, connect to my_database and execute:

CREATE EXTENSION IF NOT EXISTS postgis
  SCHEMA public

See also the docs:

Yes, but only manually. You can use a SQLCreator or SQLExecutor to do something like:

CREATE DATABASE my_database
  WITH OWNER = my_db_owner
       ENCODING = 'UTF8'
       TABLESPACE = my_tablespace

Then, in a second SQLExecutor, connect to my_database and execute:

CREATE EXTENSION IF NOT EXISTS postgis
  SCHEMA public

Sign up