I have a remote postgres / postgis db that I'd like to import data using .sql file resulting from an FME translation. Something like ogr's PGDump format using the COPY method
Kindest regards...
Question
Can I create PGDump file like ogr2ogr
This 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.
+7- Contributor
Hi @travisk,
why you don't write direct to postgres with the postgres or postgis writer in fmedesktop?
So, for our infrastructure, I've implemented some SystemCallers that call pg_dump and pg_restore. I think you can create your "custom SystemCallers" that call ogr2ogr script or commands.
Bye, regards
Hi @travisk,
why you don't write direct to postgres with the postgres or postgis writer in fmedesktop?
So, for our infrastructure, I've implemented some SystemCallers that call pg_dump and pg_restore. I think you can create your "custom SystemCallers" that call ogr2ogr script or commands.
Bye, regards
The database is remote and I have no direct connectivity from my workbench. My typical workflow is to use ogr2ogr to create a intermediate sql file and sneaker copy it to my db server then run pgsql dbname < myimport.sql to insert / update my tables. I could write a a simple text file that creates a table and performs a bunch of inserts or a bulk copy similar to ogr2ogr but I was hoping for a out of the box solution that could handle managing the feature type definition.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.