PostgreSQL

  You can use the following queries to monitor the performance of the database or to find and kill queries that cause lock. The following …

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-607db4f9e2032094118725/]   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 …