PostgreSQL

How-tos How to Find and Delete Duplicate Records in a Database in PostgreSQL This article shows how to find duplicate records in a database and then delete them 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 Insert or Update if Exists in PostgreSQL In Postgres, there's a method called UPSERT which inserts a row if it's not present in the table. Else, it just updates the field of the row. ↗ 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 Transpose Columns to Rows in PostgreSQL This article describes the method to transpose columns to rows in 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 Check if PostgreSQL Server Is Running on macOS This article mentions several BASH commands to check for the status of 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. ↗ How-tos How to PostgreSQL - Check Date and Time Relative to Today This article demonstrates how to check the current date and time relative to today. ↗ How-tos How to Log All PostgreSQL Queries This article demonstrates how to log all PostgreSQL queries. It also shows how to alter configuration files. ↗ How-tos How to Install and Troubleshoot the ODBC Driver for PostgreSQL This article discusses how a user can install and set up a Postgres ODBC driver along with common problems users may face. ↗ How-tos How to Drop Not Null Constraint in PostgreSQL This article discusses how to drop not null constraint in different ways. ↗ How-tos How to Create a Read Only User in PostgreSQL This tutorial demonstrates creating a read-only user in PostgreSQL. ↗