Hello,
Is it possible to create a new schema in a PostGres/PostGIS database using FME?
Thanks
Question
Creating new schema in a PostGres/PostGIS databse
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.
Hi @jackyd, yes, you can create a new schema with a SQL statement. e.g.
create schema my_schema
Note: The execution will fail if the schema exists in the database already, but the error can be ignored if you add a hyphen to the head of the statement, like this.
-create schema my_schema
+16- Supporter
Hi @jackyd, yes, you can create a new schema with a SQL statement. e.g.
create schema my_schema
Note: The execution will fail if the schema exists in the database already, but the error can be ignored if you add a hyphen to the head of the statement, like this.
-create schema my_schemaThank you so much @takashi this just what i need.
@takashi, I've never seen that hyphen trick, is it documented somewhere?
You can also do it like this, which may be slightly more understandable when you stumble upon it later:
CREATE SCHEMA IF NOT EXISTS schema_nameDocumentation here: https://www.postgresql.org/docs/9.3/static/sql-createschema.html
@takashi, I've never seen that hyphen trick, is it documented somewhere?
You can also do it like this, which may be slightly more understandable when you stumble upon it later:
CREATE SCHEMA IF NOT EXISTS schema_nameDocumentation here: https://www.postgresql.org/docs/9.3/static/sql-createschema.html
"An individual statement may be preceded with a hyphen, indicating that errors should be ignored."
It's convenient in some cases.
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
Hi @david_r, the hyphen trick is an FME specification that is documented in the SQLExecutor help.
"An individual statement may be preceded with a hyphen, indicating that errors should be ignored."
It's convenient in some cases.