{"id":2697,"date":"2025-03-12T23:52:18","date_gmt":"2025-03-12T15:52:18","guid":{"rendered":"https:\/\/www.laixuexila.com\/?p=2697"},"modified":"2025-03-12T23:52:18","modified_gmt":"2025-03-12T15:52:18","slug":"postgresql-%e6%97%b6%e9%97%b4-%e6%97%a5%e6%9c%9f%e5%87%bd%e6%95%b0%e5%92%8c%e6%93%8d%e4%bd%9c%e7%ac%a6%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/www.laixuexila.com\/index.php\/2025\/03\/12\/postgresql-%e6%97%b6%e9%97%b4-%e6%97%a5%e6%9c%9f%e5%87%bd%e6%95%b0%e5%92%8c%e6%93%8d%e4%bd%9c%e7%ac%a6%e8%af%a6%e8%a7%a3\/","title":{"rendered":"PostgreSQL \u65f6\u95f4\/\u65e5\u671f\u51fd\u6570\u548c\u64cd\u4f5c\u7b26\u8be6\u89e3"},"content":{"rendered":"\n<p>PostgreSQL \u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u65e5\u671f\u548c\u65f6\u95f4\u51fd\u6570\u53ca\u64cd\u4f5c\u7b26\uff0c\u7528\u4e8e\u5904\u7406\u548c\u64cd\u4f5c\u65e5\u671f\u3001\u65f6\u95f4\u3001\u65f6\u95f4\u6233\u7b49\u6570\u636e\u7c7b\u578b\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528\u8fd9\u4e9b\u51fd\u6570\u548c\u64cd\u4f5c\u7b26\u6267\u884c\u5404\u79cd\u5e38\u89c1\u7684\u65e5\u671f\u548c\u65f6\u95f4\u8ba1\u7b97\u4efb\u52a1\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. PostgreSQL \u65e5\u671f\/\u65f6\u95f4\u6570\u636e\u7c7b\u578b<\/strong><\/h2>\n\n\n\n<p>\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u4e86\u89e3 PostgreSQL \u652f\u6301\u7684\u4e3b\u8981\u65e5\u671f\u548c\u65f6\u95f4\u6570\u636e\u7c7b\u578b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>DATE<\/code>\uff1a\u8868\u793a\u65e5\u671f\uff0c\u683c\u5f0f\u4e3a <code>YYYY-MM-DD<\/code>\u3002<\/li>\n\n\n\n<li><code>TIME<\/code>\uff1a\u8868\u793a\u65f6\u95f4\uff0c\u683c\u5f0f\u4e3a <code>HH:MI:SS<\/code>\u3002<\/li>\n\n\n\n<li><code>TIMESTAMP<\/code>\uff1a\u8868\u793a\u65e5\u671f\u548c\u65f6\u95f4\uff0c\u683c\u5f0f\u4e3a <code>YYYY-MM-DD HH:MI:SS<\/code>\u3002<\/li>\n\n\n\n<li><code>TIMESTAMPTZ<\/code>\uff1a\u8868\u793a\u5e26\u65f6\u533a\u7684\u65f6\u95f4\u6233\uff0c\u683c\u5f0f\u4e3a <code>YYYY-MM-DD HH:MI:SS+TZ<\/code>\u3002<\/li>\n\n\n\n<li><code>INTERVAL<\/code>\uff1a\u8868\u793a\u65f6\u95f4\u95f4\u9694\uff0c\u5982 <code>1 day<\/code>, <code>2 hours<\/code>\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. \u5e38\u89c1\u65e5\u671f\/\u65f6\u95f4\u51fd\u6570<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.1 \u83b7\u53d6\u5f53\u524d\u65e5\u671f\u548c\u65f6\u95f4<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>CURRENT_DATE<\/code>\uff1a\u8fd4\u56de\u5f53\u524d\u7684\u65e5\u671f\u3002<\/li>\n\n\n\n<li><code>CURRENT_TIME<\/code>\uff1a\u8fd4\u56de\u5f53\u524d\u7684\u65f6\u95f4\u3002<\/li>\n\n\n\n<li><code>CURRENT_TIMESTAMP<\/code>\uff1a\u8fd4\u56de\u5f53\u524d\u7684\u65f6\u95f4\u6233\uff08\u5305\u62ec\u65e5\u671f\u548c\u65f6\u95f4\uff09\u3002<\/li>\n\n\n\n<li><code>NOW()<\/code>\uff1a\u4e0e <code>CURRENT_TIMESTAMP<\/code> \u7b49\u6548\uff0c\u8fd4\u56de\u5f53\u524d\u7684\u65f6\u95f4\u6233\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u83b7\u53d6\u5f53\u524d\u65e5\u671f\u548c\u65f6\u95f4<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT CURRENT_DATE;        -- \u8fd4\u56de\u5f53\u524d\u65e5\u671f\nSELECT CURRENT_TIME;        -- \u8fd4\u56de\u5f53\u524d\u65f6\u95f4\nSELECT CURRENT_TIMESTAMP;   -- \u8fd4\u56de\u5f53\u524d\u65f6\u95f4\u6233\nSELECT NOW();               -- \u8fd4\u56de\u5f53\u524d\u65f6\u95f4\u6233<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.2 \u63d0\u53d6\u65e5\u671f\/\u65f6\u95f4\u90e8\u5206<\/strong><\/h3>\n\n\n\n<p>PostgreSQL \u63d0\u4f9b\u4e86 <code>EXTRACT<\/code> \u51fd\u6570\uff0c\u53ef\u4ee5\u4ece\u65f6\u95f4\u6233\u4e2d\u63d0\u53d6\u7279\u5b9a\u7684\u90e8\u5206\uff08\u5982\u5e74\u3001\u6708\u3001\u65e5\u3001\u5c0f\u65f6\u7b49\uff09\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>EXTRACT(field FROM source)<\/code>\uff1a\u63d0\u53d6\u65f6\u95f4\u6233\u4e2d\u7684\u67d0\u4e2a\u5b57\u6bb5\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u63d0\u53d6\u5e74\u3001\u6708\u3001\u65e5<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT EXTRACT(YEAR FROM CURRENT_DATE);      -- \u63d0\u53d6\u5f53\u524d\u5e74\u4efd\nSELECT EXTRACT(MONTH FROM CURRENT_DATE);     -- \u63d0\u53d6\u5f53\u524d\u6708\u4efd\nSELECT EXTRACT(DAY FROM CURRENT_DATE);       -- \u63d0\u53d6\u5f53\u524d\u65e5\u671f<\/code><\/pre>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u63d0\u53d6\u65f6\u95f4\u90e8\u5206<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT EXTRACT(HOUR FROM CURRENT_TIME);     -- \u63d0\u53d6\u5c0f\u65f6\nSELECT EXTRACT(MINUTE FROM CURRENT_TIME);   -- \u63d0\u53d6\u5206\u949f\nSELECT EXTRACT(SECOND FROM CURRENT_TIME);   -- \u63d0\u53d6\u79d2<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.3 \u83b7\u53d6\u5f53\u524d\u65e5\u671f\/\u65f6\u95f4\u7684\u683c\u5f0f\u5316\u8f93\u51fa<\/strong><\/h3>\n\n\n\n<p>\u4f7f\u7528 <code>TO_CHAR()<\/code> \u51fd\u6570\u5c06\u65e5\u671f\/\u65f6\u95f4\u8f6c\u6362\u4e3a\u7279\u5b9a\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u683c\u5f0f\u5316\u8f93\u51fa<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS');  -- \u683c\u5f0f\u5316\u65f6\u95f4\u6233\nSELECT TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD');                    -- \u683c\u5f0f\u5316\u65e5\u671f\nSELECT TO_CHAR(CURRENT_TIME, 'HH24:MI:SS');                    -- \u683c\u5f0f\u5316\u65f6\u95f4<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.4 \u8ba1\u7b97\u65e5\u671f\/\u65f6\u95f4\u5dee\uff08INTERVAL\uff09<\/strong><\/h3>\n\n\n\n<p>\u4f7f\u7528 <code>-<\/code> \u8fd0\u7b97\u7b26\u53ef\u4ee5\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\/\u65f6\u95f4\u4e4b\u95f4\u7684\u5dee\u5f02\uff0c\u7ed3\u679c\u662f <code>INTERVAL<\/code> \u7c7b\u578b\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u65e5\u671f\/\u65f6\u95f4\u5dee\u8ba1\u7b97<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT CURRENT_TIMESTAMP - '2025-03-01 10:00:00'::timestamp;  -- \u8ba1\u7b97\u65f6\u95f4\u6233\u5dee\u5f02\nSELECT '2025-03-01'::date - '2025-02-01'::date;  -- \u8ba1\u7b97\u65e5\u671f\u5dee\u5f02<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.5 \u65e5\u671f\u52a0\u51cf<\/strong><\/h3>\n\n\n\n<p>\u4f60\u53ef\u4ee5\u4f7f\u7528 <code>+<\/code> \u6216 <code>-<\/code> \u64cd\u4f5c\u7b26\uff0c\u6216\u8005\u4f7f\u7528 <code>INTERVAL<\/code> \u7c7b\u578b\u8fdb\u884c\u65e5\u671f\u548c\u65f6\u95f4\u7684\u52a0\u51cf\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u65e5\u671f\u52a0\u51cf<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT CURRENT_DATE + INTERVAL '1 day';      -- \u5f53\u524d\u65e5\u671f\u52a0\u4e00\u5929\nSELECT CURRENT_DATE - INTERVAL '1 month';    -- \u5f53\u524d\u65e5\u671f\u51cf\u53bb\u4e00\u4e2a\u6708\nSELECT CURRENT_TIMESTAMP + INTERVAL '5 hours'; -- \u5f53\u524d\u65f6\u95f4\u6233\u52a0\u4e94\u5c0f\u65f6<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. \u65e5\u671f\/\u65f6\u95f4\u64cd\u4f5c\u7b26<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3.1 \u65e5\u671f\/\u65f6\u95f4\u6bd4\u8f83\u64cd\u4f5c\u7b26<\/strong><\/h3>\n\n\n\n<p>PostgreSQL \u652f\u6301\u591a\u79cd\u7528\u4e8e\u65e5\u671f\/\u65f6\u95f4\u6bd4\u8f83\u7684\u64cd\u4f5c\u7b26\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>=<\/code>\uff1a\u7b49\u4e8e<\/li>\n\n\n\n<li><code>!=<\/code> \u6216 <code>&lt;><\/code>\uff1a\u4e0d\u7b49\u4e8e<\/li>\n\n\n\n<li><code>><\/code>\uff1a\u5927\u4e8e<\/li>\n\n\n\n<li><code>&lt;<\/code>\uff1a\u5c0f\u4e8e<\/li>\n\n\n\n<li><code>>=<\/code>\uff1a\u5927\u4e8e\u6216\u7b49\u4e8e<\/li>\n\n\n\n<li><code>&lt;=<\/code>\uff1a\u5c0f\u4e8e\u6216\u7b49\u4e8e<\/li>\n<\/ul>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u65e5\u671f\u6bd4\u8f83<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT '2025-03-12'::date = CURRENT_DATE;     -- \u5224\u65ad\u65e5\u671f\u662f\u5426\u76f8\u7b49\nSELECT '2025-03-12'::date &gt; CURRENT_DATE;     -- \u5224\u65ad\u65e5\u671f\u662f\u5426\u5927\u4e8e\u5f53\u524d\u65e5\u671f\nSELECT '2025-03-12'::date &lt;= '2025-03-15'::date;  -- \u5224\u65ad\u65e5\u671f\u662f\u5426\u5c0f\u4e8e\u7b49\u4e8e\u67d0\u4e2a\u65e5\u671f<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3.2 \u65e5\u671f\/\u65f6\u95f4\u95f4\u9694\u64cd\u4f5c\u7b26<\/strong><\/h3>\n\n\n\n<p>PostgreSQL \u63d0\u4f9b\u4e86\u591a\u79cd\u64cd\u4f5c\u7b26\u6765\u8fdb\u884c\u65e5\u671f\/\u65f6\u95f4\u7684\u52a0\u51cf\u3002\u4e3b\u8981\u662f <code>+<\/code> \u548c <code>-<\/code> \u8fd0\u7b97\u7b26\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>+<\/code>\uff1a\u5c06\u65f6\u95f4\u95f4\u9694\u6dfb\u52a0\u5230\u65e5\u671f\u6216\u65f6\u95f4<\/li>\n\n\n\n<li><code>-<\/code>\uff1a\u5c06\u65f6\u95f4\u95f4\u9694\u4ece\u65e5\u671f\u6216\u65f6\u95f4\u4e2d\u51cf\u53bb<\/li>\n<\/ul>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u65e5\u671f\u548c\u65f6\u95f4\u7684\u52a0\u51cf<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT '2025-03-12'::date + INTERVAL '10 days';    -- \u5c06 10 \u5929\u52a0\u5230\u65e5\u671f\nSELECT '2025-03-12'::date - INTERVAL '10 days';    -- \u4ece\u65e5\u671f\u51cf\u53bb 10 \u5929\nSELECT CURRENT_TIMESTAMP + INTERVAL '1 hour';      -- \u5f53\u524d\u65f6\u95f4\u52a0 1 \u5c0f\u65f6<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3.3 \u8ba1\u7b97\u4e24\u4e2a\u65f6\u95f4\u70b9\u7684\u5dee\u503c<\/strong><\/h3>\n\n\n\n<p>\u4f7f\u7528 <code>-<\/code> \u8fd0\u7b97\u7b26\u53ef\u4ee5\u8ba1\u7b97\u4e24\u4e2a\u65f6\u95f4\u70b9\u7684\u5dee\u503c\uff0c\u8fd4\u56de\u4e00\u4e2a <code>INTERVAL<\/code>\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u8ba1\u7b97\u65f6\u95f4\u5dee<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT CURRENT_TIMESTAMP - '2025-03-01 10:00:00'::timestamp;  -- \u8ba1\u7b97\u65f6\u95f4\u6233\u5dee\u5f02\nSELECT '2025-03-12'::date - '2025-02-12'::date;  -- \u8ba1\u7b97\u65e5\u671f\u5dee\u5f02<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. \u65f6\u95f4\u6233\u548c\u65f6\u533a\u5904\u7406<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4.1 \u4f7f\u7528\u65f6\u533a<\/strong><\/h3>\n\n\n\n<p>PostgreSQL \u5141\u8bb8\u4f7f\u7528\u65f6\u533a\u8fdb\u884c\u65e5\u671f\u548c\u65f6\u95f4\u7684\u5904\u7406\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>TIMESTAMPTZ<\/code>\uff1a\u5e26\u65f6\u533a\u7684\u65f6\u95f4\u6233\u3002<\/li>\n\n\n\n<li><code>SET TIMEZONE<\/code>\uff1a\u8bbe\u7f6e\u5f53\u524d\u4f1a\u8bdd\u7684\u65f6\u533a\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u4f7f\u7528\u65f6\u533a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET TIMEZONE = 'UTC';       -- \u8bbe\u7f6e\u65f6\u533a\u4e3a UTC\nSELECT CURRENT_TIMESTAMP;   -- \u8fd4\u56de UTC \u65f6\u95f4\u6233\nSELECT CURRENT_TIMESTAMP AT TIME ZONE 'US\/Eastern';  -- \u8f6c\u6362\u4e3a\u7f8e\u56fd\u4e1c\u90e8\u65f6\u533a<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4.2 \u8f6c\u6362\u65f6\u533a<\/strong><\/h3>\n\n\n\n<p>PostgreSQL \u5141\u8bb8\u5728\u4e0d\u540c\u7684\u65f6\u533a\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\uff1a<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u65f6\u533a\u8f6c\u6362<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT CURRENT_TIMESTAMP AT TIME ZONE 'UTC';  -- \u8f6c\u6362\u4e3a UTC \u65f6\u95f4\nSELECT '2025-03-12 12:00:00'::timestamp AT TIME ZONE 'America\/New_York';  -- \u8f6c\u6362\u4e3a\u7ebd\u7ea6\u65f6\u533a<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. \u5e38\u89c1\u7684\u65e5\u671f\/\u65f6\u95f4\u51fd\u6570<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>5.1 <code>DATE_TRUNC<\/code> \u51fd\u6570<\/strong><\/h3>\n\n\n\n<p><code>DATE_TRUNC<\/code> \u7528\u4e8e\u622a\u65ad\u65f6\u95f4\u6233\u5230\u6307\u5b9a\u7684\u7c92\u5ea6\uff08\u5982\u5c0f\u65f6\u3001\u5929\u3001\u6708\u7b49\uff09\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u622a\u65ad\u65f6\u95f4\u6233<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DATE_TRUNC('hour', CURRENT_TIMESTAMP);   -- \u622a\u65ad\u5230\u5c0f\u65f6\nSELECT DATE_TRUNC('day', CURRENT_TIMESTAMP);    -- \u622a\u65ad\u5230\u5929\nSELECT DATE_TRUNC('month', CURRENT_TIMESTAMP);  -- \u622a\u65ad\u5230\u6708<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>5.2 <code>AGE<\/code> \u51fd\u6570<\/strong><\/h3>\n\n\n\n<p><code>AGE<\/code> \u51fd\u6570\u7528\u4e8e\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\/\u65f6\u95f4\u4e4b\u95f4\u7684\u5dee\u5f02\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2a <code>INTERVAL<\/code>\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u8ba1\u7b97\u5e74\u9f84<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT AGE('2025-03-12'::date, '1990-01-01'::date);  -- \u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u7684\u5e74\u9f84\u5dee<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u603b\u7ed3<\/strong><\/h2>\n\n\n\n<p>PostgreSQL \u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u65e5\u671f\u548c\u65f6\u95f4\u51fd\u6570\u53ca\u64cd\u4f5c\u7b26\uff0c\u53ef\u4ee5\u7075\u6d3b\u5730\u5904\u7406\u65e5\u671f\u3001\u65f6\u95f4\u3001\u65f6\u95f4\u6233\u7b49\u6570\u636e\u7c7b\u578b\u7684\u8ba1\u7b97\u548c\u8f6c\u6362\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528\u8fd9\u4e9b\u51fd\u6570\u6765\u83b7\u53d6\u5f53\u524d\u65e5\u671f\u548c\u65f6\u95f4\uff0c\u6267\u884c\u65e5\u671f\u8ba1\u7b97\uff0c\u683c\u5f0f\u5316\u65e5\u671f\uff0c\u6bd4\u8f83\u65e5\u671f\u7b49\u3002\u7406\u89e3\u8fd9\u4e9b\u51fd\u6570\u548c\u64cd\u4f5c\u7b26\uff0c\u5c06\u5e2e\u52a9\u4f60\u9ad8\u6548\u5730\u8fdb\u884c\u65e5\u671f\u548c\u65f6\u95f4\u76f8\u5173\u7684\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p>\u66f4\u591a\u8be6\u7ec6\u5185\u5bb9\u8bf7\u5173\u6ce8\u5176\u4ed6\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u65e5\u671f\u548c\u65f6\u95f4\u51fd\u6570\u53ca\u64cd\u4f5c\u7b26\uff0c\u7528\u4e8e\u5904\u7406\u548c\u64cd\u4f5c\u65e5\u671f\u3001\u65f6\u95f4\u3001\u65f6\u95f4\u6233\u7b49\u6570\u636e\u7c7b\u578b\u3002\u4f60\u53ef\u4ee5\u4f7f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2698,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[78],"tags":[],"class_list":["post-2697","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/posts\/2697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/comments?post=2697"}],"version-history":[{"count":1,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/posts\/2697\/revisions"}],"predecessor-version":[{"id":2699,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/posts\/2697\/revisions\/2699"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/media\/2698"}],"wp:attachment":[{"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/media?parent=2697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/categories?post=2697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.laixuexila.com\/index.php\/wp-json\/wp\/v2\/tags?post=2697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}