74.6. BKI Example
The following sequence of commands will create the tabletest_table
with OID 420, having three columnsoid
,cola
andcolb
of typeoid
,int4
andtext
, respectively, and insert two rows into the table:
create test_table 420 (oid = oid, cola = int4, colb = text)open test_tableinsert ( 421 1 'value 1' )insert ( 422 2 _null_ )close test_table