{"id":3540,"date":"2020-02-28T17:11:32","date_gmt":"2020-02-28T16:11:32","guid":{"rendered":"https:\/\/solidt.eu\/site\/?p=3540"},"modified":"2020-02-28T17:11:33","modified_gmt":"2020-02-28T16:11:33","slug":"postgresql-guids","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/postgresql-guids\/","title":{"rendered":"PostgreSQL guids"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- enable guids:\nCREATE EXTENSION \"uuid-ossp\";\n-- generate a GUID\nSELECT uuid_generate_v4();<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO \"GeregistreerdPallet\" (\"Oid\", \"TijdGeregistreerd\", \"Eindbestemming\", \"LeveringId\", \"Status\")\nVALUES (uuid_generate_v4()::TEXT, CURRENT_TIMESTAMP, 1, '5ceb1e17-f5ed-4794-b6d9-2a5023acde82', 0)<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3540","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/3540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=3540"}],"version-history":[{"count":1,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/3540\/revisions"}],"predecessor-version":[{"id":3541,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/3540\/revisions\/3541"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=3540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=3540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=3540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}