PostgreSQL Tutorial

PostgreSQL Tutorial: GRANT

Summary: In this tutorial, you will learn how to use the PostgreSQL GRANT statement to grant privileges on database objects to a role.

Continue reading

PostgreSQL Tutorial: PostgreSQL Server and Database Objects

Summary: in this tutorial, you are going to get familiar with the most common server and database objects provided by PostgreSQL. It is important to understand those objects and their functionality so you do not miss out on the cool features that you may wish to have in the system.

Continue reading

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