PostgreSQL

In PostgreSQL we have 2 functions to split a string according to a certain character; regexp_split_to_array and regexp_split_to_table. regexp_split_to_array : It splits the string according to regular expression and returns its parts in an …

  In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-6003b4131cbe3069750505/]   Then we create our function, [crayon-6003b4131cbea441944691/]   …

  In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data Wrapper Between PostgreSQL and Oracle …

  Postgresql is one of the RDMS databases presented in simple form. Therefore, we need to install the extension to use dblink, Foreign Data Wrapper, and so on. Foreign Data …

  If you don’t use PG ADMIN or any other similar application and you want to see the data type in the columns of the table you created, the command …

SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server on this site. In this …

  You may receive an error as follows when you try to install a different extension package that is not in Postgresql’s repo. To solve this problem, we need to …

  One of the features facilitating the management of PostgreSQL is that it hosts its basic document. We can easily learn a brief description of a configuration, what values it …

First we go to https://yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will install PostgreSQL 10 in our example, we will click on 10. Then right …

  With PostgreSQL, it is very easy to manage the case “update if there is a record, if not, add”. In traditional methods, we first check whether a record with …