PostgreSQL

How-tos How to Upsert (Insert on Duplicate Update, Merge) in PostgreSQL With EXCLUDE Values This article shows ways to use the EXCLUDED table values in upsert in PostgreSQL. ↗ How-tos How to Concatenate Columns in PostgreSQL Using Select This article describes how to concatenate columns in PostgreSQL using Select method. ↗ How-tos How to Extract Day of Week From Date Field in PostgreSQL This article explains how to extract the respective day of the week from the date field in PostgreSQL. ↗ How-tos How to Insert on Duplicate Update in PostgreSQL This article explains how to perform an Insert on Duplicate Update in PostgreSQL. ↗ How-tos How to Use NOT IN With Subquery in PostgreSQL This article describes how to use NOT IN in PostgreSQL. ↗ How-tos How to Compare Dates in Datetime Fields in PostgreSQL This article describes how to compare two DATETIME fields in PostgreSQL. ↗ How-tos How to Use Variables in PostgreSQL You might need to use variables in PostgreSQL. You can declare your variables using DECLARE in the PL/SQL. ↗ How-tos How to Use Loop in PostgreSQL In PL/SQL, you might need to use the loop in Postgres. We can use the FOR and WHILE statements to create a loop. ↗ How-tos How to Show Connections in PostgreSQL This article shows how to list active connections on PostgreSQL. ↗ How-tos How to Run SQL File in PSQL This article explains how to run a SQL file direct from terminal/command-line or psql shell. For that, you need to specify the hostname, port, username, and database name. ↗ How-tos How to Locate Configuration Files in PostgreSQL on Ubuntu This article shows how to locate the configuration files for PostgreSQL database on Ubuntu. ↗ How-tos How to Left Join Lateral in PostgreSQL This article is about the left join lateral in PostgreSQL. ↗ How-tos How to Cast String to Date DD/MM/YYYY in PostgreSQL This article shows how we can retrieve dates using a desired format in PostgreSQL. ↗ How-tos How to Round an Average to 2 Decimal Places in PostgreSQL This article describes how to round an average in PostgreSQL to 2 decimal places. ↗ How-tos How to Exit From the Command Line Utility in PostgreSQL This article describes how to exit from the Psql command line utility in PostgreSQL. ↗ How-tos How to Save PL/pgSQL Output From PostgreSQL to CSV This article describes how to save the PL/pgSQL output from PostgreSQL to a CSV file. ↗ How-tos How to Rename a Table Inside a Schema in PostgreSQL This article describes renaming a table inside a schema in PostgreSQL. ↗ How-tos How to Create a Pivot Table in PostgreSQL This article describes how to create a pivot table in PostgreSQL. ↗ How-tos How to Comment Characters in PostgreSQL This article explains us about the process of commenting characters in PostgreSQL. ↗ How-tos How to Create Role or User if It Does Not Exist in PostgreSQL This article teaches how to create a PostgreSQL role for the first time. ↗ How-tos How to Configure PostgreSQL in Linux This article teaches how to configure and use PostgreSQL for the first time in Linux. ↗ How-tos How to PostgreSQL DATE_TRUNC() Function Using the DATE_TRUNC() function you can define the precision of datetime in Postgres. ↗ How-tos How to Update Data in the JSON Field in PostgreSQL This article discusses how to update a JSON field in Postgres. Using JSONB_SET(), you can modify the existing JSON key-value. ↗ How-tos How to Install the Client Tools for PostgreSQL on Windows This article will teach the reader how to install the client tools for PostgreSQL database to access any remote database. ↗