Re: [Openvas-discuss] OpenVAS9 Postgres Scap/Cert Data updates

2017-04-18 Thread martin holzer
It should be much easier by using postgres 9.5+ https://hashrocket.com/blog/posts/upsert-records-with-postgresql-9-5 Am 18.04.2017 10:04 AM schrieb "Roger Davies" : > Hi > > Just wondering if someone has a Postgres equivalent of > greenbonde-scapdata-sync and

[Openvas-discuss] OpenVAS9 Postgres Scap/Cert Data updates

2017-04-18 Thread Roger Davies
Hi Just wondering if someone has a Postgres equivalent of greenbonde-scapdata-sync and greenbone-certdata-sync. The xsl SQL uses 'INSERT OR REPLACE" which is sqllite specific, so I get an error when running them. Can't seem to find anything online. Thanks Roger