PostgreSQL

We may want to change the schema name because of some needs. For this we can use the following script. First, we list the schemes …

One of the useful data types of PostgreSQL is the inet data type. inet is used to define IPv4 and IPv6 addresses. The ip address …

  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-662d1da10e4eb475495517/]   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 …