Is it possible to create a PostGIS database with FME ?
Question
Create a database with FME?
+2This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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_tablespaceThen, in a second SQLExecutor, connect to my_database and execute:
CREATE EXTENSION IF NOT EXISTS postgis
SCHEMA publicSee also the docs:
https://www.postgresql.org/docs/current/sql-createdatabase.html
https://www.postgresql.org/docs/current/sql-createextension.html
+64
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_tablespaceThen, in a second SQLExecutor, connect to my_database and execute:
CREATE EXTENSION IF NOT EXISTS postgis
SCHEMA publicSee 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
+2Thanks @david_r ! I'll give it a try