<p>The database schemas of osmosis and osm2pgsql are not compatible. VIEWs will not really help in this situation. If you are mainly after updates, then <a href="https://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.47#--write-pgsql-change_.28--wpc.29" rel="nofollow">osmosis can do that for you</a> with your existing database.</p>
<p>On a general note: this is more a question for the <a href="https://lists.openstreetmap.org/listinfo/dev" rel="nofollow">mailing list</a> as it would help to understand better what you have and what you are trying to achieve.</p>

<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/958?email_source=notifications&email_token=AA6353QC6EOOWTSUSRXWUBTQMW7E3A5CNFSM4I45L4N2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAHVVWI#issuecomment-537877209">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353WUPMT5SODGIGGUXD3QMW7E3ANCNFSM4I45L4NQ">mute the thread</a>.<img src="https://github.com/notifications/beacon/AA6353XGZ3MBJ5SICA7GPV3QMW7E3A5CNFSM4I45L4N2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAHVVWI.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/958?email_source=notifications\u0026email_token=AA6353QC6EOOWTSUSRXWUBTQMW7E3A5CNFSM4I45L4N2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAHVVWI#issuecomment-537877209",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/958?email_source=notifications\u0026email_token=AA6353QC6EOOWTSUSRXWUBTQMW7E3A5CNFSM4I45L4N2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAHVVWI#issuecomment-537877209",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>