{"id":56234,"date":"2024-06-08T21:12:28","date_gmt":"2024-06-08T21:12:28","guid":{"rendered":"https:\/\/dbtut.com\/?p=56234"},"modified":"2024-06-08T21:25:25","modified_gmt":"2024-06-08T21:25:25","slug":"postgresql-insert-trigger","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/","title":{"rendered":"PostgreSQL INSERT TRIGGER"},"content":{"rendered":"

In this article, what is INSERT TRIGGER and how to use it? I will talk about this.<\/p>\n

First of all, we need to create a function or procedure before creating a trigger.<\/p>\n

The purpose of doing this is that we will be performing the operation within the create trigger command using that function.<\/p>\n

I think it will be better understood by making an example of the insert trigger.<\/p>\n

When the insertion operation of the veliler table is done, we will make a trigger that writes the id, adi, soyadi columns in which parents table and which user made this insertion, when he did it and what action he did, to the parents audit table.<\/p>\n

First, we create a table named Veliler_audit, which will keep the log of insertions.<\/p>\n

CREATE TABLE \"Veliler_Audit\"\r\n(\r\n\"Velilerid\" INT NOT NULL,\r\n\"\u0130sim\" VARCHAR(20) NOT NULL,\r\n\"Soyisim\" VARCHAR(20) NOT NULL,\r\n\"UserName\" VARCHAR(20) NOT NULL,\r\n\"Tarih\" VARCHAR(20) NOT NULL,\r\n\"\u0130\u015flem\"  VARCHAR(20) NOT NULL\r\n);<\/pre>\n
After creating our table, we need to create a function as follows to add our data to the parents_audit table.<\/p>\n
Here, in the returns section, you can see that we used the Returns trigger command.<\/p>\n
The reason for this is because this function will be used in the trigger.<\/p>\n
CREATE OR REPLACE FUNCTION veliler_insert_trigger_fnc()\r\n  RETURNS trigger AS\r\n$$\r\nBEGIN\r\n    INSERT INTO \"Veliler_Audit\" ( \"Velilerid\", \"\u0130sim\", \"Soyisim\",\"UserName\" ,\"Tarih\",\"\u0130\u015flem\")       VALUES(NEW.\"no\",NEW.\"adi\",NEW.\"soyadi\",current_user,current_date,'\u0130nsertt');\r\nRETURN NEW;\r\nEND;\r\n$$\r\nLANGUAGE 'plpgsql';<\/pre>\n
After creating our function, we create the trigger we specified as follows.<\/p>\n
CREATE TRIGGER veliler_insert_trigger\r\nAFTER INSERT\r\nON \"veliler\"\r\nFOR EACH ROW\r\nEXECUTE PROCEDURE veliler_insert_trigger_fnc();<\/pre>\n
Let’s add data to the Veliler table.<\/p>\n
INSERT INTO public.veliler(\r\nno, adi, soyadi, evtelefon)\r\nVALUES (15, 'f', 'a', 053212);<\/pre>\n
We added our data and let’s check if data has been added to our veliler_Audit table.<\/p>\n
<\/p>\n
\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function or procedure before creating a trigger. The purpose of doing this is that we will be performing the operation within the create trigger command using that function. I think …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":56236,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-56234","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL INSERT TRIGGER - Database Tutorials<\/title>\n<meta name=\"description\" content=\"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL INSERT TRIGGER - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-08T21:12:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-08T21:25:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png\" \/>\n\t<meta property=\"og:image:width\" content=\"712\" \/>\n\t<meta property=\"og:image:height\" content=\"335\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL INSERT TRIGGER\",\"datePublished\":\"2024-06-08T21:12:28+00:00\",\"dateModified\":\"2024-06-08T21:25:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\"},\"wordCount\":218,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\",\"name\":\"PostgreSQL INSERT TRIGGER - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png\",\"datePublished\":\"2024-06-08T21:12:28+00:00\",\"dateModified\":\"2024-06-08T21:25:25+00:00\",\"description\":\"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png\",\"width\":712,\"height\":335},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL INSERT TRIGGER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL INSERT TRIGGER - Database Tutorials","description":"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL INSERT TRIGGER - Database Tutorials","og_description":"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function","og_url":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/","og_site_name":"Database Tutorials","article_published_time":"2024-06-08T21:12:28+00:00","article_modified_time":"2024-06-08T21:25:25+00:00","og_image":[{"width":712,"height":335,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL INSERT TRIGGER","datePublished":"2024-06-08T21:12:28+00:00","dateModified":"2024-06-08T21:25:25+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/"},"wordCount":218,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/","url":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/","name":"PostgreSQL INSERT TRIGGER - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png","datePublished":"2024-06-08T21:12:28+00:00","dateModified":"2024-06-08T21:25:25+00:00","description":"n this article, what is INSERT TRIGGER and how to use it? I will talk about this. First of all, we need to create a function","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/06\/Ekran-goruntusu-2024-06-09-001034.png","width":712,"height":335},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/06\/08\/postgresql-insert-trigger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL INSERT TRIGGER"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=56234"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56234\/revisions"}],"predecessor-version":[{"id":56237,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56234\/revisions\/56237"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56236"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}