Uuid is the abbreviation for “universal unique identifier”. It consists of 36 characters, a set of numbers and letters, and its most important feature …
Read More »Faruk Erdem
How to Change the Schema Name in 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 …
Read More »How To Insert Random Data In PostgreSQL
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 »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 »