-
How to Rename a Database in PostgreSQL: A Beginner’s Guide
Hi! In this article i will show you how to rename a database in PostgreSQL. For those who does not have time to read our whole detailed article command template we use is: It’s not uncommon to encounter situations where you need to rename a database in PostgreSQL. Perhaps you’ve changed project details, need to…
-
How to: PostgreSQL Rename Table
Hi! Today, in this article we will cover PostgreSQL Rename Table topic. When we need to rename a table in PostgreSQL we can use alter table …. rename statment. Syntax of PostgreSQL Rename Table To rename a table we use alter table … rename statement in PostgreSQL. It shares the same syntax with other alter…
-
Postgres like Query Performance
Hello! In this article we are going to talk about postgres like query performance. Also we will talk about improving like query performance. To stay with me on the same page, you can prepare a world_cities table following my guide about importing csv file into Postgresql using dbeaver. How Do We Measure? Each query has…
-
How to Create Admin User in PostgreSQL
Hello! Today we are going to talk about how to create admin user in PostgreSQL. In most cases, i don’t like to use postgres user as administrator. Because the version you use might have a security vulnerability and postgres user is the first user attackers going to scan. As addition, you can disable ssh conncetion…
-
How to Create Database in Postgresql in Linux Terminal?
Hello! In this article we will talk about how to create a database in PostgreSQL in the Linux terminal. Psql is a terminal client we can use to manipulate database objects. For more information you can check Postgresql documentation for CREATE DATABASE statement. How to Create Database in Postgresql in Linux Terminal? First of all…
-
How to Check DB Locks in Postgres
Hello! I was afraid of locks when I started to manage databases. It affects the performance and reliability of the database. In this article, I will cover how to check db locks in PostgreSQL topic. How to Check DB Locks in Postgres? Locks are indirect indicators of database health. Locks don’t point out a database…
-
Postgres Migrate Database to new Server
Hello! Migrating a database between servers is a very common question. In this article we will talk about postgres migrate database to new server topic. Answer of this question depends on the size, load and critically of the database. Database migration is a very important topic. There are a lot of parameters effecting migration method,…
-
How to Create Role Postgres?
I understand the importance of providing detailed information on creating roles in Postgres to help those who may be familiar with other database engines. Let’s talk abour how to create role Postgres in this article. When it comes to database management systems, the concept of a “role” in Postgres can indeed be confusing for individuals…
-
How to Create View PostgreSQL?
Hello! Views are great for reporting purposes or refining access to sensitive data. In this article we will discuss how to create view PostgreSQL topic. Creating views in PostgreSQL can significantly enhance the manageability and security of your database by providing a virtual table representing a result set of a stored query. This feature is…
-
How to Check Which Version of Postgres is Running?
Hello! Today we will talk about how to check which version of Postgres is running? Checking PostgreSQL version is the first step of inspecting an environment, to understand characteristics, defects and buggy features. I have done many health checks for Db2, WebSphere, FileNet before, always, learning the version of running product was the first step.…