{"id":86,"date":"2016-07-26T15:56:23","date_gmt":"2016-07-26T13:56:23","guid":{"rendered":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/?p=86"},"modified":"2022-12-01T15:56:42","modified_gmt":"2022-12-01T14:56:42","slug":"postgres-template-loeschen","status":"publish","type":"post","link":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/?p=86","title":{"rendered":"Postgres Template l\u00f6schen"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In dem Datenbankmanagementsystem PostgreSql k\u00f6nnen Templates nicht direkt gel\u00f6scht werden. Um eine solche Vorlage zu l\u00f6schen, muss zuerst das entsprechende Kennzeichen mit folgendem Befehl (hier f\u00fcr das Template &#8218;template_postgis_20&#8216;)<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE pg_database SET datistemplate='false' WHERE datname='template_postgis_20';\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">zur\u00fcckgesetzt werden. Danach ist das L\u00f6schen problemlos m\u00f6glich.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In dem Datenbankmanagementsystem PostgreSql k\u00f6nnen Templates nicht direkt gel\u00f6scht werden. Um eine solche Vorlage zu l\u00f6schen, muss zuerst das entsprechende Kennzeichen mit folgendem Befehl (hier f\u00fcr das Template &#8218;template_postgis_20&#8216;) UPDATE pg_database SET datistemplate=&#8217;false&#8216; WHERE datname=&#8217;template_postgis_20&#8242;; zur\u00fcckgesetzt werden. Danach ist das L\u00f6schen problemlos m\u00f6glich.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=86"}],"version-history":[{"count":1,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/posts\/86\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=\/wp\/v2\/posts\/86\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schoenberg-solutions.de\/arndtblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}