A warm Hello to all the readers! I am back with a small tutorial on PostgreSQL. In this I’ll explain how to create roles and users in PostgreSQL database. User is a fundamental component of database. DB users are different from operating system users. Users are assigned permissions what database objects they can access. There Continue reading “How To Create Users and Roles in PostgreSQL”
Category Archives: Database
How to Find Size of PostgreSQL Databases
Hello to all the readers! Find size of Postgresql database One of my database was growing in size thereby consuming the disk. I got to know which database was taking how much of the disk space. And here is how to find out the size of each PostgreSQL database. The above SQL query just finds Continue reading “How to Find Size of PostgreSQL Databases”