PostgreSQL

We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I start the upgrade process, I want to make the following critical …

  In Postgresql, sometimes we need a sample database when we test. We can use pagila in postgresql.org for this. You can follow the steps …

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 …

  In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-67d38d4303957561159526/]   Then we …

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

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

  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 …

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 …

  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 …

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