Other Functions

1min

Besides the timestamp, string, and numeric functions, we also provide other functions that can be used to support the use of our database. The functions are as follows:
Functions
Description
﻿CURRENT_SCHEMA()﻿﻿﻿
It returns the schema's name first in the search path.
﻿CURRENT_DATABASE()﻿
It returns the current database's name. 
﻿NULLIF()﻿
It replaces a given value with null if it matches a specific criterion. 
﻿COALESCE()﻿
It returns the first argument that is not null, while the remaining arguments from the first non-null argument are not evaluated.
﻿pg_total_relation_size()﻿
It retrieves the size of a table. 
﻿has_schema_privilege()﻿
It checks whether the current user has specific privileges on a schema. 
﻿pg_get_expr()﻿
It retrieves the internal form of an individual expression, such as the default value for a column.
﻿pg_typeof()﻿
It retrieves the data type of any given value. 
﻿

Updated 13 Nov 2023

Did this page help you?

JSON_ARRAY_EXTRACT

CURRENT_SCHEMA

Functions	Description
CURRENT_SCHEMA()	It returns the schema's name first in the search path.
CURRENT_DATABASE()	It returns the current database's name.
NULLIF()	It replaces a given value with null if it matches a specific criterion.
COALESCE()	It returns the first argument that is not null, while the remaining arguments from the first non-null argument are not evaluated.
pg_total_relation_size()	It retrieves the size of a table.
has_schema_privilege()	It checks whether the current user has specific privileges on a schema.
pg_get_expr()	It retrieves the internal form of an individual expression, such as the default value for a column.
pg_typeof()	It retrieves the data type of any given value.