Skip to main content
Question

Create a database with FME?

  • February 27, 2019
  • 3 replies
  • 50 views

harmen_kampinga
Forum|alt.badge.img+2

Is it possible to create a PostGIS database with FME ?

3 replies

david_r
Celebrity
  • February 27, 2019

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


nielsgerrits
VIP
Forum|alt.badge.img+54
david_r wrote:

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


harmen_kampinga
Forum|alt.badge.img+2

Thanks @david_r ! I'll give it a try


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings