Skip to main content
  • EN

Is it possible to create a PostGIS database with FME ?

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:

https://www.postgresql.org/docs/current/sql-createdatabase.html

https://www.postgresql.org/docs/current/sql-createextension.html

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:

https://www.postgresql.org/docs/current/sql-createdatabase.html

https://www.postgresql.org/docs/current/sql-createextension.html

You beat me again! :p

Thanks @david_r ! I'll give it a try

Reply


Community Stats

30,109
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.