PostgreSQL Tutorial

PostgreSQL Tutorial: REVOKE

Summary: In this tutorial, you will learn about the PostgreSQL REVOKE statement to remove privileges from a role.

Continue reading

PostgreSQL Tutorial: TRANSLATE Function

Summary: The PostgreSQL TRANSLATE() function performs several single-character, one-to-one translation in one operation.

Continue reading

PostgreSQL Tutorial: AGE Function: Calculate Ages

Summary: In this tutorial, you will learn how to use the PostgreSQL AGE() function to calculate ages.

Continue reading

PostgreSQL Tutorial: ASCII Function: Get ASCII code or Unicode Code Point of a Character

Summary: The PostgreSQL ASCII() function returns an ASCII code value of a character. In the case of UTF-8, the ASCII() function returns the Unicode code point of the character.

Continue reading

PostgreSQL Tutorial: CHR Function: Get Character Based on ASCII or Unicode Code Point

Summary: The PostgreSQL CHR() function converts an integer ASCII code to a character or a Unicode code point to a UTF8 character.

Continue reading

PostgreSQL Tutorial: CURRENT_DATE Function

Summary: The PostgreSQL CURRENT_DATE function returns the current date.

Continue reading

PostgreSQL Tutorial: CURRENT_TIME Function

Summary: The PostgreSQL CURRENT_TIME function returns the current time with time zone.

Continue reading

PostgreSQL Tutorial: EXTRACT Function

Summary: The PostgreSQL EXTRACT() function retrieves a field such as a year, month, and day from a date/time value.

Continue reading

PostgreSQL Tutorial: LEFT Function: Get First N Characters in a String

Summary: The PostgreSQL LEFT() function returns the first n characters in the string.

Continue reading

PostgreSQL Tutorial: LOCALTIME Function

Summary: The PostgreSQL LOCALTIME function returns the current time at which the current transaction starts.

Continue reading