{"id":9307,"date":"2023-02-13T13:19:32","date_gmt":"2023-02-13T05:19:32","guid":{"rendered":"http:\/\/123.57.164.21\/?p=9307"},"modified":"2023-02-13T13:20:15","modified_gmt":"2023-02-13T05:20:15","slug":"postgresql-sequence-nextval-in-schema","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=9307","title":{"rendered":"Postgresql sequence nextval in schema"},"content":{"rendered":"\n<p><strong>\u95ee\u9898\uff1a<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-1024x754.png\" alt=\"\" class=\"wp-image-9308\" width=\"527\" height=\"387\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-1024x754.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-300x221.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-768x565.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-830x611.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-230x169.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-350x258.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13-480x353.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2023\/02\/\u56fe\u7247-13.png 1378w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/figure><\/div>\n\n\n\n<p>\u89e3\u51b3\uff1a<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u521b\u5efaSEQUENCE\nCREATE SEQUENCE ita_db.SEQ_ABC\n\tINCREMENT BY 1\n\tMINVALUE 1\n\tMAXVALUE 9999999999\n\tSTART WITH 1\n\tNO CYCLE\n\tCACHE 1;\n\n\/\/ \u4f7f\u7528\u7684\u4f8b\u5b50\nCREATE TABLE ita_db.TABLE_TEST (\n\tTEST_USER_ID BIGINT DEFAULT nextval ('\"ita_db\".SEQ_ABC')  NOT NULL,\n\tCRE_USER_ID VARCHAR(20)  NOT NULL,\n\tCRE_TMSTMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n\tUPD_USER_ID VARCHAR(20)  NOT NULL,\n\tUPD_TMSTMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP\n\t, CONSTRAINT DOMESTIC_ACCOM_CODE_MST_PK PRIMARY KEY (\n\t\tTEST_USER_ID\n\t)\n);<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\uff1a \u89e3\u51b3\uff1a<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/9307"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9307"}],"version-history":[{"count":2,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/9307\/revisions"}],"predecessor-version":[{"id":9310,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/9307\/revisions\/9310"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}