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

  Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …

  Sometimes the standard installation is not sufficient for the extension package you want to install. The reason for this is that the extension has …

  When you run the make command when installing Oracle_fdw, you may encounter the error as follows. The reason for this error is that the …

  Uuid is the abbreviation for “universal unique identifier”. It consists of 36 characters, a set of numbers and letters, and its most important feature …

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 …

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 …