Hi, On 18.04.2017 10:03, Roger Davies wrote: > 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.
most likely because both scripts and the .xls files are already supporting Postgresql since quite some time and doesn't use INSERT OR REPLACE when running Postgresql: https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020637.html https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020601.html So the question is why your environment is not using the Postgres compatible .xls files Regards, -- Christian Fischer | PGP Key: 0x54F3CE5B76C597AD Greenbone Networks GmbH | http://greenbone.net Neumarkt 12, 49074 Osnabrück, Germany | AG Osnabrück, HR B 202460 Geschäftsführer: Lukas Grunwald, Dr. Jan-Oliver Wagner _______________________________________________ Openvas-discuss mailing list [email protected] https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
