{"id":18647,"date":"2021-02-17T08:07:40","date_gmt":"2021-02-17T08:07:40","guid":{"rendered":"https:\/\/dbtut.com\/?p=18647"},"modified":"2021-03-05T08:52:06","modified_gmt":"2021-03-05T08:52:06","slug":"postgresql-change-configuration-parameters","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/","title":{"rendered":"Postgresql change configuration parameters"},"content":{"rendered":"<p>This article contains information about change postgresql configuration in postgresql. If you find to learn more about postgresql.conf file you should read below articles.<\/p>\n<p><a href=\"https:\/\/dbtut.com\/index.php\/2021\/03\/03\/postgresql-conf-settings-in-postgresql\/\" target=\"_blank\" rel=\"noopener\">postgresql.conf settings in PostgreSQL<\/a><\/p>\n<h3>Postgresql change configuration parameters<\/h3>\n<p>We can change postgresql.conf parameter directy from postgresql.conf file or we can change same settings from postgresql.auto.conf file via ALTER system command.<\/p>\n<h4>Change postgresql.auto.conf file parameters via SQL<\/h4>\n<p>PostgreSQL provides three SQL commands for changing parameters.<\/p>\n<p><strong>Change postgresql configuration by using ALTER SYSTEM<\/strong><\/p>\n<p>Used to change cluster-level parameters, equivalent to editing postgresql.conf. We said that the changes made with this parameter are written to the postgresql.auto.conf file.<\/p>\n<p>Examples;<\/p>\n<pre class=\"lang:default decode:true \">ALTER SYSTEM SET wal_level = replica;\r\nALTER DATABASE test SET timezone = 'UTC-5';\r\nALTER SYSTEM RESET wal_level;\r\nALTER SYSTEM RESET ALL;<\/pre>\n<p><strong>Change postgresql configuration by using<\/strong> <strong>ALTER DATABASE<\/strong><\/p>\n<p>Global parameters are overridden on a database basis.<\/p>\n<p>Examples;<\/p>\n<pre class=\"lang:default decode:true \">ALTER DATABASE db_test SET escape_string_warning = off;\r\nALTER DATABASE db_test SET enable_indexscan TO off;\r\nALTER DATABASE test SET timezone = 'UTC-5';\r\nALTER DATABASE db_test RESET escape_string_warning;\r\nALTER DATABASE db_test RESET ALL;<\/pre>\n<p><strong>Change postgresql configuration by using ALTER ROLE<\/strong><\/p>\n<p>It allows passing user-specific parameters.<\/p>\n<p>Examples;<\/p>\n<pre class=\"lang:default decode:true \">ALTER ROLE test_user SET client_min_messages  = DEBUG;\r\nALTER ROLE test_user SET maintenance_work_mem = 100000;\r\nALTER ROLE test_user IN DATABASE test_db SET maintenance_work_mem = 100000;\r\nALTER USER test_user IN DATABASE test_db RESET maintenance_work_mem;\r\nALTER USER test_user IN DATABASE test_db RESET ALL;\r\nALTER USER test_user IN DATABASE test_db SET timezone = 'UTC-7';<\/pre>\n<p>The values set with ALTER DATABASE and ALTER ROLE are applied only when starting the new database session. They override values obtained from configuration files or the server command line and set defaults for the remainder of the session. Each parameter cannot be applied on database and session basis. Therefore, ALTER DATABASE and ALTER ROLE commands cannot be used for some parameters.<\/p>\n<p>&nbsp;<\/p>\n<p>When a client connects to the database, PostgreSQL provides two additional SQL commands (and equivalent function) to interact with session-local configuration settings:<\/p>\n<p><strong>SHOW command<\/strong> allows viewing the current value of all parameters. The corresponding function is current_setting.<\/p>\n<pre class=\"lang:default decode:true \">SHOW ALL;\r\nSHOW DateStyle;\r\nselect current_setting('datestyle');<\/pre>\n<p><strong>SET command<\/strong> allows to change the current value of parameters that can be set locally to a session; It has no effect on other sessions. The corresponding function is set_config.<\/p>\n<pre class=\"lang:default decode:true \">SET search_path TO my_schema, public;\r\nSET datestyle TO postgres, dm\r\nSET TIME ZONE 'PST8PDT';\r\nSET TIME ZONE 'Europe\/Rome';\r\nselect set_config('log_statement_stats', 'off', false);<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18647\" class=\"pvc_stats all  \" data-element-id=\"18647\" 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>This article contains information about change postgresql configuration in postgresql. If you find to learn more about postgresql.conf file you should read below articles. postgresql.conf settings in PostgreSQL Postgresql change configuration parameters We can change postgresql.conf parameter directy from postgresql.conf file or we can change same settings from postgresql.auto.conf file via ALTER system command. Change &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18647\" class=\"pvc_stats all  \" data-element-id=\"18647\" 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":926,"featured_media":18654,"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":[10368],"class_list":["post-18647","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-postgresql-change-configuration-parameters"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Postgresql change configuration parameters - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about changing postgresql configuration in 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\/2021\/02\/17\/postgresql-change-configuration-parameters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Postgresql change configuration parameters - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about changing postgresql configuration in postgresql.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-17T08:07:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-05T08:52:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"755\" \/>\n\t<meta property=\"og:image:height\" content=\"397\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mustafa Bekta\u015f Tepe\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mustafa Bekta\u015f Tepe\" \/>\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\/2021\/02\/17\/postgresql-change-configuration-parameters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\"},\"author\":{\"name\":\"Mustafa Bekta\u015f Tepe\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608\"},\"headline\":\"Postgresql change configuration parameters\",\"datePublished\":\"2021-02-17T08:07:40+00:00\",\"dateModified\":\"2021-03-05T08:52:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\"},\"wordCount\":277,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg\",\"keywords\":[\"Postgresql change configuration parameters\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\",\"name\":\"Postgresql change configuration parameters - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg\",\"datePublished\":\"2021-02-17T08:07:40+00:00\",\"dateModified\":\"2021-03-05T08:52:06+00:00\",\"description\":\"This article contains information about changing postgresql configuration in postgresql.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg\",\"width\":755,\"height\":397},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Postgresql change configuration parameters\"}]},{\"@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\/bf61379dc4b6cb1df9a84293fc5da608\",\"name\":\"Mustafa Bekta\u015f Tepe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g\",\"caption\":\"Mustafa Bekta\u015f Tepe\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/mustafabektas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Postgresql change configuration parameters - Database Tutorials","description":"This article contains information about changing postgresql configuration in 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\/2021\/02\/17\/postgresql-change-configuration-parameters\/","og_locale":"en_US","og_type":"article","og_title":"Postgresql change configuration parameters - Database Tutorials","og_description":"This article contains information about changing postgresql configuration in postgresql.","og_url":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/","og_site_name":"Database Tutorials","article_published_time":"2021-02-17T08:07:40+00:00","article_modified_time":"2021-03-05T08:52:06+00:00","og_image":[{"width":755,"height":397,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg","type":"image\/jpeg"}],"author":"Mustafa Bekta\u015f Tepe","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mustafa Bekta\u015f Tepe","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/"},"author":{"name":"Mustafa Bekta\u015f Tepe","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608"},"headline":"Postgresql change configuration parameters","datePublished":"2021-02-17T08:07:40+00:00","dateModified":"2021-03-05T08:52:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/"},"wordCount":277,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg","keywords":["Postgresql change configuration parameters"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/","url":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/","name":"Postgresql change configuration parameters - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg","datePublished":"2021-02-17T08:07:40+00:00","dateModified":"2021-03-05T08:52:06+00:00","description":"This article contains information about changing postgresql configuration in postgresql.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/changeconfigurationparameterspostgres.jpg","width":755,"height":397},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2021\/02\/17\/postgresql-change-configuration-parameters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Postgresql change configuration parameters"}]},{"@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\/bf61379dc4b6cb1df9a84293fc5da608","name":"Mustafa Bekta\u015f Tepe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g","caption":"Mustafa Bekta\u015f Tepe"},"url":"https:\/\/dbtut.com\/index.php\/author\/mustafabektas\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18647","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\/926"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=18647"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18647\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/18654"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=18647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=18647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=18647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}