PostgreSQL Tutorial: Reset Forgotten Password For postgres User
Summary: in this tutorial, we will show you step by step how to reset the password of the postgres user in PostgreSQL.
PostgreSQL Tutorial: CURRENT_TIMESTAMP Function
Summary: The PostgreSQL CURRENT_TIMESTAMP() function returns the current date and time with time zone, which is the time when the transaction starts.
PostgreSQL Tutorial: DATE_PART Function
Summary: In this tutorial, we will introduce you to the PostgreSQL DATE_PART() function that allows you to retrieve subfields e.g., year, month, week from a date or time value.
PostgreSQL Tutorial: DATE_TRUNC Function
Summary: This tutorial shows you how to use the PostgreSQL date_trunc() function to truncate a timestamp or interval to a specified level of precision.
PostgreSQL Tutorial: FORMAT Function
Summary: PostgreSQL FORMAT() function formats arguments based on a format string.
PostgreSQL Tutorial: NOW Function
Summary: This tutorial shows you how to use the PostgreSQL NOW() function to get the date and time with time zone.
PostgreSQL Tutorial: PL/pgSQL SELECT INTO Statement
Summary: in this tutorial, you will learn how to use the PL/pgSQL SELECT INTO statement to select data from the database and assign it to a variable.
PostgreSQL Tutorial: REGEXP_MATCHES Function
Summary: The PostgreSQL REGEXP_MATCHES() function matches a regular expression against a string and returns matched substrings.
PostgreSQL Tutorial: REGEXP_REPLACE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL REGEXP_REPLACE() function to replace strings that match a regular expression.
PostgreSQL Tutorial: Delete Duplicate Rows
Summary: in this tutorial, you will learn how to use various techniques to delete duplicate rows in PostgreSQL.