二进制数据类型(binary data types) 日期/时间类型(date/time types) 布尔类型(boolean type) 枚举类型(enumerated types) 几何类型(geometric types) 文本搜索类型(text search types) JSON 类型(JSON types) 数组类型(Array types) 组合类型(Composite types)
8.4. Binary Data Types The bytea data type allows storage of binary strings; see Table 8-6. ... 18.10. Client Connection Defaults 18.10.1. Statement Behavior bytea_output (enum) Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditi...
Network Address Types -https://www.postgresql.org/docs/10/static/datatype-net-types.html 10、二进制字符串类型 Bit String Types -https://www.postgresql.org/docs/10/static/datatype-bit.html 10、网络地址类型 Network Address Types -https://www.postgresql.org/docs/10/static/datatype-net-types....
Category - Binary Data Types Category - Date/Time Types Category - Boolean Type Category - Enumerated Type Unlike other types, Enumerated Types need to be created using CREATE TYPE command. This type is used to store a static, ordered set of values, for example compass directions,i.e. NORTH...
bit binary bit [ (n) ] fixed-length bit string:定长位串 bit varying varbinary bit varying [ (n) ] varbit variable-length bit string:变长位串 boolean bit boolean bool logical boolean (true/false):布尔值 box rectangular box on a plane bytea binary data ("byte array") cha...
BINARY(Types.BINARY), VARBINARY(Types.VARBINARY), LONGVARBINARY(Types.LONGVARBINARY), NULL(Types.NULL), OTHER(Types.OTHER), BLOB(Types.BLOB), CLOB(Types.CLOB), BOOLEAN(Types.BOOLEAN), CURSOR(-10), // Oracle UNDEFINED(Integer.MIN_VALUE + 1000), ...
*/ bool typisdefined; char typdelim; /* delimiter for arrays of this type */ Oid typrelid; /* 0 if not a composite type */ Oid typelem; Oid typarray; regproc typinput; /* text format (required) */ regproc typoutput; regproc typreceive; /* binary format (optional) */ regproc...
{ "invalid_binary_representation", ERRCODE_INVALID_BINARY_REPRESENTATION }, { "bad_copy_file_format", ERRCODE_BAD_COPY_FILE_FORMAT }, { "untranslatable_character", ERRCODE_UNTRANSLATABLE_CHARACTER }, { "not_an_xml_document", ERRCODE_NOT_AN_XML_DOCUMENT }, { "invalid_xml_document", ERRCODE_...
It uses the OGC well-known binary (WKB) and well-known text (WKT) representations of geometry. PostGIS has two spatial type options: geometry and geography. To use them, you must install PostGIS to your PostgreSQL database cluster, and use the PostGIS template database to create the data...
Initdb 的过程主要是执行 initdb binary,解析 编译阶段生成的postgres.bki文件,初始化template1,template0以及postgres这三个数据库。 需要注意的是实际执行时对这三个数据库的初始化还有$PGHOME/share目录下的一些其他文件:shell PostgreSQL.description PostgreSQL.shdescription system_views.sql snowball_create.sql Postg...