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 …
Read More »Faruk Erdem
How to Change User Name in PostgreSQL
You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different …
Read More »How To Find and Kill Long Running Queries In 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 …
Read More »How to Install Postgresql Sample Database
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 …
Read More »Foreign Data Wrapper Between PostgreSQL and MSSQL
In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …
Read More »Postgresql Foreign Data Wrapper
Postgresql is one of the RDMS databases presented in simple form. Therefore, we need to install the extension to use dblink, Foreign Data Wrapper, …
Read More »How to List Table Columns and Data Types On Postgresql
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 …
Read More »Solution of Makefile54 Error On PostgreSQL
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 …
Read More »How To Install PostgreSQL On centos/redhat
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 …
Read More »PostgreSQL DBLINK
In this article I will describe how to connect to remote PostgreSQL database with PostgreSQL dblink. Dblink usage is similar to other databases. but …
Read More »