PostgreSQL

How-tos How to Find the Disk Size of a PostgreSQL Table and Its Indexes This article discusses how we can find the disk size of a PostgreSQL table and its indexes. Using the \l+ command, we can show the database sizes, and using \d+, we can view the … ↗ How-tos How to Escape a Single Quote in PostgreSQL This tutorial discusses how to escape a single quote in PostgreSQL. ↗ How-tos How to Connect to PostgreSQL in SSL Mode To encrypt the connection between client and the postgres server, we need to use the SSL mode in postgres. As, it's a secure database, to keep it that way we need to use the SSL … ↗ How-tos How to Replace Strings in PostgreSQL This tutorial discusses how to replace string using PostgreSQL replace() function. ↗ How-tos How to Select Top N Rows in PostgreSQL This tutorial walks you through different ways to get the top n rows in a PostgreSQL table. ↗ How-tos How to Generate a UUID for the Insert Statement in PostgreSQL UUID is a unique identifier id created by the RFC 4122. There are several versions of it. The latest one is the v4. It's a 32-digit hexadecimal code. We can use it as the primary … ↗ How-tos How to Check if a User-Defined Type Already Exists in PostgreSQL We can use a script to check whether or not the type already exists. Query over the pg_type can inform us whether the user-defined type exists or not. ↗ How-tos How to Add Primary Key to a PostgreSQL Table Only if It Does Not Exist Sometimes, we may forget to assign a primary key while executing the CREATE TABLE query. We can use the alter table query to assign the primary key in an existing table. ↗ How-tos How to Get Array Length in PostgreSQL This article discusses calculating the length of an array in PostgreSQL. ↗ How-tos How to Delete All Table Rows in PostgreSQL This article shows the method to delete all rows in a table in PostgreSQL. ↗ How-tos How to Check if PostgreSQL Is Installed on Linux This tutorial explains how to check whether we have installed PostgreSQL on Linux or not. ↗ How-tos How to Use Where Clause in the Date Field Using PostgreSQL This article demonstrates the use of where clause in the date type field using PostgreSQL. ↗ How-tos How to Upgrade the PostgreSQL Server Version Without Losing Any Data This tutorial describes the procedure to update the PostgreSQL server version without losing any data. ↗ How-tos How to Install PSQL Without Installing Full PostgreSQL The article demonstrates a procedure to install psql without installing the full PostgreSQL server using Homebrew services. ↗ How-tos How to Grant Privileges to the User in PostgreSQL This article explains how to grant privileges to the user in PostgreSQL. ↗ How-tos How to Add Days to Date in PostgreSQL This article illustrates how we can add several days to date while using PostgreSQL. ↗ How-tos How to Select From Dual in PostgreSQL This article discusses the dual table and the alternatives of selecting from dual in PostgreSQL. ↗ How-tos How to Run PostgreSQL in Memory Only This article discusses using a database in memory in PostgreSQL. ↗ How-tos How to Insert Current Timestamp in PostgreSQL This article shows the different ways to insert current timestamp in PostgreSQL. ↗ How-tos How to Convert From Unix Epoch to the Date in PostgreSQL This article mentions how to convert Unix epoch to the date in PostgreSQL. ↗ How-tos How to Add PostgreSQL Database as a Maven Dependency This article provides an in-depth approach on how to add the PostgreSQL database dependency to Maven. ↗ How-tos How to Differentiate Between Numeric and Decimal Data Types in PostgreSQL This tutorial guides the reader on the difference between numeric and decimal data types in the PostgreSQL database. ↗ How-tos How to Search Data Saved in Uppercase in PostgreSQL This tutorial demonstrates how to use a keyword written in lowercase to search for data saved in an uppercase form in PostgreSQL. ↗ How-tos How to PostgreSQL Database Encryption This article explains multiple ways to encrypt your data in PostgreSQL. ↗