Hello,
Is it possible to create a new schema in a PostGres/PostGIS database using FME?
Thanks
+19- Contributor
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
+10- Contributor
takashi wrote:
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
+19- Contributor
david_r wrote:
@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.
1 person upvoted this
takashi wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.