Data Science & PostgreSQL
CYBERTEC is your professional partner for Data Science and PostgreSQL. From machine learning, artificial intelligence and big data to PostgreSQL support, consulting and training.
PostgreSQL Services
CYBERTEC Training and Courses
Products & Tools
Based on multiple years of experience with PostgreSQL we developed a variety of applications and successfully integrated them into existing systems.
We Want to Make You Happy!
News From the CYBERTEC Blog
WITH HOLD cursors and transactions in PostgreSQL
© Laurenz Albe 2021 Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions interact and how WITH HOLD can work around their limitations. We will also see the dangers involved and how to properly use WITH HOLD cursors in a PL/pgSQL procedure. Cursors in PostgreSQL […]
SHOW TABLES in PostgreSQL: what’s wrong with it?
In this article, I will answer the questions: why isn’t there a SHOW TABLES command in PostgreSQL, when will SHOW TABLES in PostgreSQL be available, and how do I list tables with native PostgreSQL methods? Why isn’t there a SHOW TABLES command in PostgreSQL? People who come from MySQL are always asking the same question: […]
OpenStreetMap service by CYBERTEC
In response to repetitive customer requests seeking spatial datasets based on OpenStreetMap service, CYBERTEC decided to start an initiative to address this demand. In short, CYBERTEC implemented a download OpenStreetMap service, which periodically generates extracts of OpenStreetMap data in various flavors, outputted as sql dump to streamline and simplify its usage. Extracts cover a particular […]