Related

Create Database

psql

Create a new PostgreSQL database

Create User

psql

Create a new PostgreSQL user

Create Table

psql

Create a new PostgreSQL table

psql/create-function

Create Function

Create a new PostgreSQL function

function
create

Command

CREATE FUNCTION functionname(arguments) RETURNS return_type AS $$ BEGIN ... END; $$ LANGUAGE plpgsql;

Explanation

Creates a new function in the current database.

Examples

Create function to add two numbers

CREATE FUNCTION add_two_numbers(a int, b int) RETURNS int AS $$ BEGIN RETURN a + b; END; $$ LANGUAGE plpgsql;

More

Create Index

psql

Create a new PostgreSQL index

Create View

psql

Create a new PostgreSQL view

Drop Function

psql

Delete a PostgreSQL function