<p>Hi <a href="https://github.com/pnorman" class="user-mention">@pnorman</a> , sorry about my non-contextual copy/pasted examples  (I am in holidays and not at my work computer), but the generic example was didactic... To contextualize with real tables  ideal is a consensual <em>big picture</em> of the "default" and "most used" output structures, that I suggesting in <a href="https://github.com/openstreetmap/osm2pgsql/issues/671" class="issue-link js-issue-link" data-url="https://github.com/openstreetmap/osm2pgsql/issues/671" data-id="199936754" data-error-text="Failed to load issue title" data-permission-text="Issue title is private">#671</a></p>
<hr>
<blockquote>
<p>is what I do with hstore, and then it gets cast with the COPY command. ...</p>
</blockquote>
<p>We all can do <em>cast</em> with <code>hstore_to_jsonb_loose()</code> and work with PL/pgSQL functions, shell scripts, etc. But this proposal is to simplify this task and standardise for all <em>osm2pgsql</em> users a reliable JSONb adaptation.</p>
<p><strong>... Let's split and simplify  <em>this issue</em></strong>,</p>
<ul>
<li>
<p>suggestion 1: simplify consumption of OSM data ...  ClearTables  is great! migrating this part of the issue to <a href="https://github.com/ClearTables/ClearTables/issues/98">ClearTables/issues/98</a></p>
</li>
<li>
<p>suggestion 2: a new option to use JSONb instead hstore... See  <a href="https://github.com/openstreetmap/osm2pgsql/issues/672" class="issue-link js-issue-link" data-url="https://github.com/openstreetmap/osm2pgsql/issues/672" data-id="199956167" data-error-text="Failed to load issue title" data-permission-text="Issue title is private">#672</a>.</p>
</li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-271745550">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7tmDuWUjpatHlH7B1Yb6dLB-ZLQPks5rRCe_gaJpZM4HiUpY">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AD2-7rt0Y1-pftugVH3EijIJaZzY9-Ibks5rRCe_gaJpZM4HiUpY.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-271745550"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/osm2pgsql","title":"openstreetmap/osm2pgsql","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/osm2pgsql"}},"updates":{"snippets":[{"icon":"PERSON","message":"@ppKrauss in #533: Hi @pnorman , sorry about my non-contextual copy/pasted examples  (I am in holidays and not at my work computer), but the generic example was didactic... To contextualize with real tables  ideal is a consensual *big picture* of the \"default\" and \"most used\" output structures, that I suggesting in #671\r\n\r\n-----\r\n\r\n\u003e is what I do with hstore, and then it gets cast with the COPY command. ...\r\n\r\nWe all can do *cast* with `hstore_to_jsonb_loose()` and work with PL/pgSQL functions, shell scripts, etc. But this proposal is to simplify this task and standardise for all *osm2pgsql* users a reliable JSONb adaptation. \r\n\r\n**... Let's split and simplify  _this issue_**,\r\n\r\n* suggestion 1: simplify consumption of OSM data ...  ClearTables  is great! migrating this part of the issue to [ClearTables/issues/98](https://github.com/ClearTables/ClearTables/issues/98)\r\n\r\n* suggestion 2: a new option to use JSONb instead hstore... See  #672.\r\n\r\n"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-271745550"}}}</script>