{"id":1317,"date":"2018-08-06T19:33:04","date_gmt":"2018-08-06T19:33:04","guid":{"rendered":"http:\/\/dbtut.com\/?p=1317"},"modified":"2018-11-09T13:36:12","modified_gmt":"2018-11-09T13:36:12","slug":"how-to-create-a-trigger-on-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/","title":{"rendered":"How To Create a Trigger On PostgreSQL"},"content":{"rendered":"

 <\/p>\n

With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER).<\/p>\n

Or you can trigger another event after it happens (AFTER TRIGGER).<\/p>\n

Or you can replace this event with another event before the event occurs (INSTEAD OF TRIGGER).<\/p>\n

Let’s make some examples of the trigger types we mentioned above.<\/p>\n

First, create a few tables with the help of the following scripts and add some records to the trigger_example table.<\/p>\n

CREATE TABLE trigger_example (name VARCHAR(50));\r\nCREATE TABLE trigger_example_deleted (name VARCHAR(50));\r\nCREATE TABLE trigger_example_inserted (name VARCHAR(50));\r\nCREATE TABLE trigger_example_updated (newname VARCHAR(50), oldname VARCHAR(50));\r\nINSERT INTO trigger_example (name) VALUES('Nurullah CAKIR'),('Keanu Reaves');<\/pre>\n
<\/p>\n
 <\/p>\n
BEFORE TRIGGER:<\/h3>\n
Let’s move on by making an example.<\/p>\n
We will create a before trigger.<\/p>\n
This trigger will transfer the new and old state of that record to the trigger_example_updated table before a record’s value changes in the trigger_example table.<\/p>\n
First, we create a procedure to use in trigger.<\/p>\n
CREATE OR REPLACE FUNCTION update_function()RETURNS trigger AS $xx$\r\nBEGIN\r\n\u00a0INSERT INTO trigger_example_updated(newname,oldname)\r\n\u00a0VALUES(NEW.name,OLD.name);\r\n\u00a0RETURN NEW;\r\nEND;\r\n$xx$ LANGUAGE plpgsql;<\/pre>\n
<\/p>\n
 <\/p>\n
Then we create the before trigger as follows.<\/p>\n
CREATE TRIGGER Before_Example\r\n\u00a0\u00a0\u00a0 BEFORE UPDATE ON trigger_example\r\n\u00a0\u00a0\u00a0 FOR EACH ROW\r\n\u00a0\u00a0\u00a0 WHEN (OLD.name <> NEW.name)\r\n\u00a0\u00a0\u00a0 EXECUTE PROCEDURE update_function();<\/pre>\n
<\/p>\n
 <\/p>\n
Lets <\/span>update a record to test the trigger.<\/span><\/p>\n
UPDATE trigger_example SET name='Nuru Cakir' WHERE name='Nurullah CAKIR';<\/pre>\n
 <\/p>\n
As you can see, the trigger works successfully.<\/p>\n
<\/p>\n
 <\/p>\n
AFTER TRIGGER:<\/h3>\n
In this trigger type, the trigger is triggered after the event occurs.<\/p>\n
This is the only difference from Before Trigger.<\/p>\n
You can repeat the example we made for before trigger for after trigger.<\/p>\n
 <\/p>\n
INSTEAD OF TRIGGER:<\/h3>\n
In this trigger type, we trigger another event instead of an actual event.<\/p>\n
Create a procedure as follows.<\/p>\n
<\/p>\n
 <\/p>\n
Later, when we want to create the INSTEAD OF Trigger, we will get an error as below.<\/p>\n
As you can see, we can not create an INSTEAD OF Trigger for tables.<\/p>\n
CREATE TRIGGER InsteadOf_Example\r\n\u00a0\u00a0\u00a0 INSTEAD OF INSERT ON trigger_example\r\n\u00a0\u00a0\u00a0 FOR EACH ROW\r\n\u00a0\u00a0\u00a0 EXECUTE PROCEDURE insteadof_function();<\/pre>\n
 <\/p>\n
ERROR:\u00a0 “trigger_example” is a table<\/em><\/p>\n
DETAIL:\u00a0 Tables cannot have INSTEAD OF triggers.<\/em><\/p>\n
<\/p>\n
 <\/p>\n
Lets create a view as follows.<\/p>\n
CREATE VIEW trigger_example_view AS\r\nSELECT name FROM trigger_example;<\/pre>\n
<\/p>\n
 <\/p>\n
Recreate the INSTEAD OF Trigger on this view in the following way.<\/p>\n
You may want to look at the following articles about Views.<\/p>\n
“How To Create a View On PostgreSQL<\/a>“,<\/p>\n
“How To Create a Materialized View On PostgreSQL<\/a>“,<\/p>\n
“How To Create a Recursive View On PostgreSQL<\/a>“,<\/p>\n
“How To Create an Updateable View On PostgreSQL<\/a>“,<\/p>\n
“How To Create an Updateable View WITH CHECK CONSTRAINT On PostgreSQL<\/a>”<\/p>\n
 <\/p>\n
CREATE TRIGGER InsteadOf_Example\r\n\u00a0\u00a0\u00a0 INSTEAD OF INSERT ON trigger_example_view\r\n\u00a0\u00a0\u00a0 FOR EACH ROW\r\n\u00a0\u00a0\u00a0 EXECUTE PROCEDURE insteadof_function();<\/pre>\n
<\/p>\n
 <\/p>\n
Let’s test the INSTEAD OF Trigger in the following way.<\/p>\n
It worked as you see it.<\/p>\n
INSERT INTO trigger_example_view (name) VALUES('InsteadOfExamples');\r\nSELECT * FROM trigger_example;\r\nSELECT * FROM trigger_example_inserted;<\/pre>\n
<\/p>\n
 <\/p>\n
I get the following table from postgresql.org.<\/p>\n
I think its useful.<\/p>\n
The following table summarizes which types of triggers may be used on tables, views, and foreign tables:<\/p>\n
\n\n\n\n\n\n\n\n\n\n
\n
When<\/span><\/p>\n<\/td>\n
\n
Event<\/span><\/p>\n<\/td>\n
\n
Row-level<\/span><\/p>\n<\/td>\n
\n
Statement-level<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
BEFORE<\/p>\n<\/td>\n
\n
INSERT<\/span>\/<\/span>UPDATE<\/span>\/<\/span>DELETE<\/span><\/p>\n<\/td>\n
\n
Tables and foreign tables<\/p>\n<\/td>\n
\n
Tables, views, and foreign tables<\/p>\n<\/td>\n<\/tr>\n
\n
\n<\/td>\n
\n
TRUNCATE<\/p>\n<\/td>\n
\n
\u2014<\/p>\n<\/td>\n
\n
Tables<\/p>\n<\/td>\n<\/tr>\n
\n
AFTER<\/p>\n<\/td>\n
\n
INSERT<\/span>\/<\/span>UPDATE<\/span>\/<\/span>DELETE<\/span><\/p>\n<\/td>\n
\n
Tables and foreign tables<\/p>\n<\/td>\n
\n
Tables, views, and foreign tables<\/p>\n<\/td>\n<\/tr>\n
\n
\n<\/td>\n
\n
TRUNCATE<\/p>\n<\/td>\n
\n
\u2014<\/p>\n<\/td>\n
\n
Tables<\/p>\n<\/td>\n<\/tr>\n
\n
INSTEAD OF<\/p>\n<\/td>\n
\n
INSERT<\/span>\/<\/span>UPDATE<\/span>\/<\/span>DELETE<\/span><\/p>\n<\/td>\n
\n
Views<\/p>\n<\/td>\n
\n
\u2014<\/p>\n<\/td>\n<\/tr>\n
\n
\n<\/td>\n
\n
TRUNCATE<\/p>\n<\/td>\n
\n
\u2014<\/p>\n<\/td>\n
\n
\u2014<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER). Or you can trigger another event after it happens (AFTER TRIGGER). Or you can replace this event with another event before the event occurs (INSTEAD OF TRIGGER). Let’s make some examples of the trigger types we mentioned above. …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"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-1317","post","type-post","status-publish","format-standard","","category-postgres"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":462,"today_views":0},"yoast_head":"\nHow To Create a Trigger On PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create a Trigger On PostgreSQL\" \/>\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\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create a Trigger On PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create a Trigger On PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-06T19:33:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T13:36:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create a Trigger On PostgreSQL\",\"datePublished\":\"2018-08-06T19:33:04+00:00\",\"dateModified\":\"2018-11-09T13:36:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\"},\"wordCount\":432,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\",\"name\":\"How To Create a Trigger On PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png\",\"datePublished\":\"2018-08-06T19:33:04+00:00\",\"dateModified\":\"2018-11-09T13:36:12+00:00\",\"description\":\"How To Create a Trigger On PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create a Trigger On PostgreSQL\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create a Trigger On PostgreSQL - Database Tutorials","description":"How To Create a Trigger On PostgreSQL","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\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How To Create a Trigger On PostgreSQL - Database Tutorials","og_description":"How To Create a Trigger On PostgreSQL","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-06T19:33:04+00:00","article_modified_time":"2018-11-09T13:36:12+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create a Trigger On PostgreSQL","datePublished":"2018-08-06T19:33:04+00:00","dateModified":"2018-11-09T13:36:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/"},"wordCount":432,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/","name":"How To Create a Trigger On PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png","datePublished":"2018-08-06T19:33:04+00:00","dateModified":"2018-11-09T13:36:12+00:00","description":"How To Create a Trigger On PostgreSQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/487.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/06\/how-to-create-a-trigger-on-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create a Trigger On PostgreSQL"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1317","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1317"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}