"xyz", false]', '$[*].string()') → ["1.23", "xyz", "false"] jsonb_path_query('"2023-08-15"', '$.datetime().string()') → "2023-08-15" value . double() → number Approximate floating-point number converted "18:40:00"] string . date() → date Date value converted from a string jsonb_path_query('"2023-08-15"', '$.date()') → "2023-08-15" string . time() → time without time zone Time without time zone value converted Timestamp without time zone value converted from a string jsonb_path_query('"2023-08-15 12:34:56"', '$.timestamp()') → "2023-08-15T12:34:56" string . timestamp(precision) → timestamp without time zone

"xyz", false]', '$[*].string()') → ["1.23", "xyz", "false"] jsonb_path_query('"2023-08-15"', '$.datetime().string()') → "2023-08-15" value . double() → number Approximate floating-point number converted "18:40:00"] string . date() → date Date value converted from a string jsonb_path_query('"2023-08-15"', '$.date()') → "2023-08-15" string . time() → time without time zone Time without time zone value converted Timestamp without time zone value converted from a string jsonb_path_query('"2023-08-15 12:34:56"', '$.timestamp()') → "2023-08-15T12:34:56" string . timestamp(precision) → timestamp without time zone

PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 PostgreSQL Client Applications ..................................................................... 2023 clusterdb ....................................................................................... ------ * * testlo.c * test using large objects with libpq * * Portions Copyright (c) 1996-2023, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of

PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 Large Objects * testlo.c * test using large objects with libpq * * Portions Copyright (c) 1996-2023, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of that the OPTIONS clause is a PostgreSQL extension. See Also CREATE FOREIGN TABLE, CREATE SERVER 2023 INSERT INSERT — create new rows in a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ]

阅读/链接/打印/转载/引用/分发/再创作 此文档，无 需任何附加条件 若您 阅读/链接/打印/转载/引用/分发/再创作 本文档，则说明接受以上2个条 款。 作者：李茂福 更新日期：2023-12-27 ★第1章、安装postgresql # yum install postgresql-server -y # EL8安装光盘AppSteam里自带有10

PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 RELEASE SAVEPOINT ................................................................................. 2023 RESET ........................................................................................... SAVEPOINT ......................................................................................... 2023 RESET ...........................................................................................

PostgreSQL Global Development Group Copyright © 1996-2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996-2023 by the PostgreSQL Global Development Group. Postgres95 pg_resetwal ............................................................................................. 2023 pg_rewind ....................................................................................... ................................................................................................. 2023 pg_rewind .......................................................................................

PostgreSQL Global Development Group Copyright © 1996-2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996-2023 by the PostgreSQL Global Development Group. Postgres95 ternal string representa- tion. If this field is null, the transition state value starts out null. 2023 System Catalogs New aggregate functions are registered with the CREATE AGGREGATE command. See Sec- discussion and patch review, so each item is truly a community effort. E.1. Release 11.22 Release date: 2023-11-09 This release contains a variety of fixes from 11.21. For information about new features in

PostgreSQL Global Development Group Copyright © 1996-2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996-2023 by the PostgreSQL Global Development Group. Postgres95 standards-compatible, but de- pending on the history of the objects in the dump, might not restore properly. 2023 pg_restore -? --help Show help about pg_restore command line arguments, and exit. pg_restore also discussion and patch review, so each item is truly a community effort. E.1. Release 11.22 Release date: 2023-11-09 This release contains a variety of fixes from 11.21. For information about new features in

PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 -7 The time zone 7 hours west from UTC (equivalent to PDT). Positive values are east from UTC. 2023 SET INTERVAL '-08:00' HOUR TO MINUTE The time zone 8 hours west from UTC (equivalent to PST). discussion and patch review, so each item is truly a community effort. E.1. Release 14.10 Release date: 2023-11-09 This release contains a variety of fixes from 14.9. For information about new features in major