MySQL Examples and Tutorials
In this tutorial, we will learn about the BOOLEAN type in PostgreSQL. Unlike the BOOLEAN type in MySQL, which is just a synonym for the TINYINT(1), PostgreSQL provides the BOOLEAN type as per the SQL standards. Moreover, it offers you more options for the BOOLEAN type, which is interesting to learn. So without wasting time, …
PostgreSQL has a bunch of GUI tools for the management and administration of databases and tables. However, you may require to learn psql commands to interact with the PostgreSQL server. Therefore, we will see how can we list all databases and tables in PostgreSQL using the psql shell. So, let’s get started! Also read: PostgreSQL …
PostgreSQL – Show All Databases and Tables Using PSQL Read More »
PostgreSQL is an open-source relational database management system that supports various numeric data types. In this tutorial, we will focus on the NUMERIC data type in PostgreSQL and its use cases, including a real-world example to demonstrate its usage. So without further ado, let’s get started! Also read: PostgreSQL – Data Types Introduction to NUMERIC …
In this tutorial, we will see how we can delete a database using the PostgreSQL DROP DATABASE command. Moreover, we will also see how to delete a database using pgAdmin4 which is a GUI tool for PostgreSQL. So without further ado, let’s get started! Also read: PostgreSQL – Alter Database with Examples Introduction to DROP …
In this tutorial, we will see the ALTER DATABASE command in PostgreSQL with some examples. Note that, the ALTER DATABASE and the ALTER TABLE are two different commands in PostgreSQL, do not get confused. So, without wasting the time, let’s get started! Also read: PostgreSQL – How to Create a Database Introduction to ALTER DATABASE …
Creating a database in PostgreSQL is not a big deal. You can create a database in postgresql using either a command line interface or a GUI-based tool such as pgAdmin. In this tutorial, we will see both methods of creating a database. So, let’s get started! Create Database Using PSQL – CLI Tool PSQL is …
In this tutorial, we will learn how can we load a sample database in PostgreSQL. There are two methods you can import a sample database, either using a command line client or GUI software. So, let’s get started! Prerequisites After installation of any DBMS on the local system, it is very important to have a …
PostgreSQL is a powerful, open-source relational database management system that supports a wide range of data types. In this article, we will discuss some of the most commonly used data types in PostgreSQL and how they can be used effectively in your database. Introduction to PostgreSQL Data types Postgresql, you can say, is an ocean …
In this tutorial, we will see how we can resolve the error “FATAL: Peer authentication failed for user *” in PostgreSQL. It is super simple to resolve this issue which takes a maximum of ten minutes. So without wasting time, let’s get started! Reason Behind the Peer authentication failed Error First of all, it is …
Solved: FATAL: Peer authentication failed for user “postgres” Error Read More »
PostgreSQL pgadmin4 is one of the most popular and widely used graphical user interface programs to manage postgres databases. To simply explain, pgAdmin is for PostgreSQL just like the phpMyAdmin is for MySQL and MariaDB. In this tutorial, we will learn to install and configure the pgAdmin4 on ubuntu version 22.04. Note that, this might …