Postgresql is one of the RDMS databases presented in simple form. Therefore, we need to install the extension to use dblink, Foreign Data Wrapper, and so on. Foreign Data …

  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 table you created, the command …

  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 this problem, we need to …

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 click on 10. Then right …

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

  You can use the between command (including the first and last value) to read the data between the two values in the table in the database. The syntax of …

  Sometimes we may want to create the same table in a database without the data in it by using a different name or we want to create the table …

  You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql and connect to Psql again. …

  You can use the following command to see the list of tablespaces created. [crayon-5fc305e751852527811342/]   You can also use the following script to list the objects in the tablespace. …

  We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there are several methods that we …