Postgresql 中文操作指南

75.6. BKI Example #

以下命令序列将创建具有 OID 420 的表 test_table,分别具有类型为 oidint4text 的三列 oidcolacolb,并将两行插入到表中:

The following sequence of commands will create the table test_table with OID 420, having three columns oid, cola and colb of type oid, int4 and text, respectively, and insert two rows into the table:

create test_table 420 (oid = oid, cola = int4, colb = text)
open test_table
insert ( 421 1 'value 1' )
insert ( 422 2 _null_ )
close test_table