I am looking to write to a postgres hstore column and seeing if their is a way to use a postgres writer with its 1000 transactions at a time to write to postgres table with a hstore column over using a 1 at a time sql-executor? I have 5 attributes to go into the hstore.
Solved
Can I use a postgres writer over a sqlexecutor to write to a postgres hstore column?
Best answer by takashi
Hi @kouri1986, yes, you can use the PostgreSQL writer to write a string with "hstore" format (e.g. 'a=>1,b=>2,c=>3') into an existing "hstore" type column if you set "text" as its data type in the User Attributes tab of the writer feature type.
However, "hstore" type columns cannot be created through the User Attributes configuration in the writer feature type. If you need to newly create the destination table containing an "hstore" column at run-time of the workspace rather than writing into an existing table, you will have to execute a SQL statement to create the table before starting to write records, with the SQLCreator/Executor or the "SQL to Run Before Write" parameter in the PostgreSQL writer.
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.
- Best Answer
Hi @kouri1986, yes, you can use the PostgreSQL writer to write a string with "hstore" format (e.g. 'a=>1,b=>2,c=>3') into an existing "hstore" type column if you set "text" as its data type in the User Attributes tab of the writer feature type.
However, "hstore" type columns cannot be created through the User Attributes configuration in the writer feature type. If you need to newly create the destination table containing an "hstore" column at run-time of the workspace rather than writing into an existing table, you will have to execute a SQL statement to create the table before starting to write records, with the SQLCreator/Executor or the "SQL to Run Before Write" parameter in the PostgreSQL writer.