PostgreSQL supports various types of data that are stored in the database and processed using SQL. Different data types are used in a wide variety of situations: for optimal use of data types when describing table attributes, for processing data using standard functions, for creating logical constraints in accordance with the business logic of the project.

There is an interesting module in vtiger called Webforms. It can generate special html forms, which you can then easely insert into your site and receive leads directly to vtiger. Forms can be integrated with various modules - leads, contacts, counterparties, deals.

In practice, any developer or system administrator encounters a terrible problem - the database slows down. The server is running slowly, something strange is happening, users are complaining, the client is angry. It was not for nothing that I wrote that the problem is terrible, first of all because the solution here will not be obvious and it does not lie on the surface. Many parameters can affect database performance.

In this article, we will take a closer look at the data insertion process. Including how to avoid errors when inserting duplicate data. We will perform all operations on the PostgreSQL test database, you can download a dump of this database at the link

Recently, more and more people have to deal with PostgreSQL in their work. And comparing this database with others, you come to the conclusion that the syntax of SQL is slightly different from the generally accepted standards. Faced with such a problem, I decided to write a mini-cheat sheet for the most common commands that any developer will need.