Built-In Functions Of PostgreSQL

PostgreSQL built-in functions, also called as Aggregate functions, are used for performing processing on string or numeric data. Following is the list of all general purpose PostgreSQL built-in functions:

Functions	Description
COUNT	·         COUNT aggregate function is used to count the number of rows in a database table.
MAX	MAX aggregate function allows us to select the highest (maximum) value for a certain column.
MIN	MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
AVG	·         AVG aggregate function selects the average value for certain table column.
SUM	·         SUM aggregate function allows selecting the total for a numeric column.
ARRAY	ARRAY aggregate function puts input values, including nulls, concatenated into an array.
Numeric	Complete list of PostgreSQL functions required to manipulate numbers in SQL.
String	·         Complete list of PostgreSQL functions required to manipulate strings in PostgreSQL.