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-trigger

Create Trigger

Create a new PostgreSQL trigger

trigger
create

Command

CREATE TRIGGER trigger_name AFTER INSERT ON tablename FOR EACH ROW EXECUTE FUNCTION function_name();

Explanation

Creates a new trigger in the current database.

Examples

Create trigger for insert operation

CREATE TRIGGER trigger_name AFTER INSERT ON tablename FOR EACH ROW EXECUTE FUNCTION function_name();

More

Create Index

psql

Create a new PostgreSQL index

Create View

psql

Create a new PostgreSQL view

Create Function

psql

Create a new PostgreSQL function