PostgreSQL provides us with so many features which include a wide range of data types. The timestamp is a such datatype in PostgreSQL which is used most often for storing the DateTime values. In this tutorial, we will see detailed information about the timestamp datatype with examples. So, let’s get started! Also Read: PostgreSQL Interval …
In the previous tutorial, we have seen the date/time datatypes which also include the interval type. However, because interval type itself is a vast topic, everything could not be covered in a single tutorial. Therefore, we will learn about interval type in this tutorial. So, let’s get started! Also Read: PostgreSQL Integer Types: SMALLINT, INT, …
PostgreSQL is one of the best databases that provide a wide number of functionalities to deal with date/time values. It provides more features for the date/time type than the SQL standard requires. In this tutorial, we will check all the aspects of the date/time type in PostgreSQL with examples. So, let’s get started! Also Read: …
In this tutorial, we will be learning integer types in PostgreSQL which includes SMALLINT, INTEGER and BIGINT. We will go through detailed information about each type and then will see examples. So, let’s dive into it. Also Read: PostgreSQL – Data Types Introduction to Integer Types As said, PostgreSQL provides us with three integer types- …
PostgreSQL provides us with a wide number of data types for storing different kinds of values. However, data generated from the applications is majorly often in string format. However, these string values can also differ and only a single datatype doesn’t fit all the time for storing them. Therefore PostgreSQL provides us with three character …
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 …