{"id":54329,"date":"2023-04-11T17:56:21","date_gmt":"2023-04-11T17:56:21","guid":{"rendered":"https:\/\/dbtut.com\/?p=54329"},"modified":"2023-04-11T17:58:30","modified_gmt":"2023-04-11T17:58:30","slug":"select-into-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/","title":{"rendered":"Select Into In PostgreSQL"},"content":{"rendered":"<p>In today&#8217;s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.<\/p>\n<p>Let&#8217;s get to know the subject better with a few examples:<\/p>\n<p>First, we switch to the database as follows.<\/p>\n<pre class=\"lang:default decode:true \">\\c pagila\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/pagila1.png\" \/><\/p>\n<p>If you get the message as above, it means you are connected to the database.<\/p>\n<p>If you are connected on pgadmin, you can right-click on the tables under the pagila database, type query tools from the menu that opens, and view the commands below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into1.png\" \/><\/p>\n<p>You can request the tables in the pagila database with the \\dt+ command.<\/p>\n<p>Let&#8217;s list those in the California region in the Address column and see how many people there are.<\/p>\n<pre class=\"lang:default decode:true \">Select*from address where district='California';\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into2.png\" \/><\/p>\n<p id=\"qDbLZTM\">As a result of the table, we see that there are 9 records and let&#8217;s create them in a different table called California with the SELECT INTO command.<\/p>\n<pre class=\"lang:default decode:true \">select* into california from address where district='California';\r\n<\/pre>\n<p>As a result of the above command, we see that 9 records are affected as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into3.png\" \/><\/p>\n<p id=\"tpcWIFy\">Let&#8217;s see our table by listing it with the \\dt column.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into4.png\" \/><\/p>\n<p id=\"qndntGP\">Our table has been created, let&#8217;s see the data with the select clause.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into5.png\" \/><\/p>\n<p id=\"RVfOPzw\">The same operations are valid on the temp table, but the temp table is temporary.<\/p>\n<p>You can transfer your table to temp as follows.<\/p>\n<pre class=\"lang:default decode:true \">select* into temp table  california from address where district='California';\r\n<\/pre>\n<p>Let&#8217;s list our tables and see if our Temp table is created.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into7.png\" \/><\/p>\n<p id=\"IcbbsSP\">We can see that our california table is created under the pg_temp_4 schema.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/into8.png\" \/><\/p>\n<p id=\"OsYoQpQ\">You can use the select into statement when the table is not created and you want to create only certain columns or all columns and transfer them to the new table.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54329\" class=\"pvc_stats all  \" data-element-id=\"54329\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this. Let&#8217;s get to know the subject better with a few examples: First, we switch to the database as follows. \\c pagila If you get the message as above, it means you are connected to the database. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54329\" class=\"pvc_stats all  \" data-element-id=\"54329\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":54338,"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-54329","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Select Into In PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.\" \/>\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\/2023\/04\/11\/select-into-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Select Into In PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-11T17:56:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-11T17:58:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png\" \/>\n\t<meta property=\"og:image:width\" content=\"606\" \/>\n\t<meta property=\"og:image:height\" content=\"316\" \/>\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=\"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\/2023\/04\/11\/select-into-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Select Into In PostgreSQL\",\"datePublished\":\"2023-04-11T17:56:21+00:00\",\"dateModified\":\"2023-04-11T17:58:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\"},\"wordCount\":264,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\",\"name\":\"Select Into In PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png\",\"datePublished\":\"2023-04-11T17:56:21+00:00\",\"dateModified\":\"2023-04-11T17:58:30+00:00\",\"description\":\"In today's article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png\",\"width\":606,\"height\":316},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Select Into In 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\/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":"Select Into In PostgreSQL - Database Tutorials","description":"In today's article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.","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\/2023\/04\/11\/select-into-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Select Into In PostgreSQL - Database Tutorials","og_description":"In today's article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2023-04-11T17:56:21+00:00","article_modified_time":"2023-04-11T17:58:30+00:00","og_image":[{"width":606,"height":316,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Select Into In PostgreSQL","datePublished":"2023-04-11T17:56:21+00:00","dateModified":"2023-04-11T17:58:30+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/"},"wordCount":264,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/","name":"Select Into In PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png","datePublished":"2023-04-11T17:56:21+00:00","dateModified":"2023-04-11T17:58:30+00:00","description":"In today's article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-11-205448.png","width":606,"height":316},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/11\/select-into-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Select Into In 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\/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\/54329","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=54329"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54329\/revisions"}],"predecessor-version":[{"id":54340,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54329\/revisions\/54340"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54338"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}