PostgreSQL

  In PostgreSQL, views are logical tables. By turning queries into views we can use complex queries with a simple select statement. For example, if …

  Stored Procedure and Function concepts in PostgreSQL are not the same as in other relational databases. Functions are used like stored procedures. In some …

  When there is an error in a database system, the first thing we do is look at the logs. In this article, I will …

  In a Cluster you can list all the databases and their sizes withe below script. I prefer one application db for a cluster generally. …

  In this article we will examine how to give permission to a user in PostgreSQL. You should click on the Postgres menu item for …

In this article I will share a few scripts in postgres databases that I think will help you manage your users. The easiest way to …

  In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script. [crayon-67d38d433ecd9430403331/]   …

We find the bin directory of PostgreSQL using the command below. [crayon-67d38d433ef00980376230/]   You can see this directory in the white box in the screen …

  If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on …

If you increase the value of the MAX_Connections parameter in the postgresql.conf file, you can get this error while starting the PostgreSQL service. You should …