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

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

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

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

  You can use the following command to see the list of tablespaces created. [crayon-67218c9891787798932911/]   You can also use the following script to list …

  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 …