{"id":56338,"date":"2024-07-01T21:01:58","date_gmt":"2024-07-01T21:01:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=56338"},"modified":"2024-07-01T21:04:54","modified_gmt":"2024-07-01T21:04:54","slug":"postgresql-ddl-triggerevent-trigger","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/","title":{"rendered":"PostgreSQL DDL Trigger\\Event Trigger"},"content":{"rendered":"

In today’s article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.<\/p>\n

Data Definition Language (DDL) tables are used to define the database structure or schema.<\/p>\n

Some of these are as follows.<\/p>\n

Operations such as CREATE, ALTER, DROP and TRUNCATE.<\/p>\n

Sometimes we want to keep a record of DDL operations.<\/p>\n

Therefore, we have to use operations such as triggers.<\/p>\n

First, we create the table where the ddl transactions will be kept.<\/p>\n

create table ddl_log (islem char(100),yap\u0131lantarih char(100),kullan\u0131c\u0131 char(100 ))<\/pre>\n
After creating our table, let’s create our function.<\/p>\n
CREATE OR REPLACE FUNCTION eventlog() RETURNS event_trigger LANGUAGE plpgsql AS $$\r\nBEGIN\r\n  INSERT INTO ddl_log VALUES (tg_tag, NOW(), current_user);\r\nEND;\r\n$$;<\/pre>\n
Let’s create our event trigger.<\/p>\n
CREATE EVENT TRIGGER ddllog ON ddl_command_end\r\n   EXECUTE FUNCTION eventlog();<\/pre>\n
Let’s create a function called deneme.<\/p>\n
create function deneme()\r\nreturns char(100)\r\nlanguage plpgsql\r\nas\r\n$$\r\nbegin\r\nraise info 'deneme ';\r\nend;\r\n$$;<\/pre>\n
We check the ddl_log table we created, is our record added?<\/p>\n
<\/p>\n
Let’s create a table for testing purposes.<\/p>\n
create table deneme1(a int)<\/pre>\n
When we look at our ddl_log table, we see that when and with which user the create table command was run is written to the table.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples. Data Definition Language (DDL) tables are used to define the database structure or schema. Some of these are as follows. Operations such as CREATE, ALTER, DROP and TRUNCATE. Sometimes we want to keep a record of DDL …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":56341,"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-56338","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL DDL Trigger\\Event Trigger - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.\" \/>\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\/07\/01\/postgresql-ddl-triggerevent-trigger\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL DDL Trigger\\Event Trigger - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-01T21:01:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-01T21:04:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png\" \/>\n\t<meta property=\"og:image:width\" content=\"827\" \/>\n\t<meta property=\"og:image:height\" content=\"322\" \/>\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\/07\/01\/postgresql-ddl-triggerevent-trigger\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL DDL Trigger\\\\Event Trigger\",\"datePublished\":\"2024-07-01T21:01:58+00:00\",\"dateModified\":\"2024-07-01T21:04:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\"},\"wordCount\":147,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\",\"name\":\"PostgreSQL DDL Trigger\\\\Event Trigger - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png\",\"datePublished\":\"2024-07-01T21:01:58+00:00\",\"dateModified\":\"2024-07-01T21:04:54+00:00\",\"description\":\"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png\",\"width\":827,\"height\":322},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL DDL Trigger\\\\Event 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 DDL Trigger\\Event Trigger - Database Tutorials","description":"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.","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\/07\/01\/postgresql-ddl-triggerevent-trigger\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL DDL Trigger\\Event Trigger - Database Tutorials","og_description":"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/","og_site_name":"Database Tutorials","article_published_time":"2024-07-01T21:01:58+00:00","article_modified_time":"2024-07-01T21:04:54+00:00","og_image":[{"width":827,"height":322,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.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\/07\/01\/postgresql-ddl-triggerevent-trigger\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL DDL Trigger\\Event Trigger","datePublished":"2024-07-01T21:01:58+00:00","dateModified":"2024-07-01T21:04:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/"},"wordCount":147,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/","url":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/","name":"PostgreSQL DDL Trigger\\Event Trigger - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png","datePublished":"2024-07-01T21:01:58+00:00","dateModified":"2024-07-01T21:04:54+00:00","description":"In today's article, we will explain PostgreSQL DDL Trigger and Event Trigger structures with the help of examples.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-01-235759.png","width":827,"height":322},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/01\/postgresql-ddl-triggerevent-trigger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL DDL Trigger\\Event 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\/56338","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=56338"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56338\/revisions"}],"predecessor-version":[{"id":56342,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56338\/revisions\/56342"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56341"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}