PostgreSQL – How to call a function

In postgresql database, functions are called from within a select statement as shown below:

SELECT function_name(function_arg1, function_arg2,...);

Example: Below is the syntax to call a function named “full_name” which accepts 2 string parameters for first_name and last_name.

SELECT full_name('first_name','last_name');

See also  PostgreSQL - Move table from one schema to another