In some cases, we may want to increase the size of the database by inserting random data into the database. In the script below, we …

  You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different …

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

  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 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 …

  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 …

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 …

  In this article I will describe how to connect to remote PostgreSQL database with PostgreSQL dblink. Dblink usage is similar to other databases. but …