Postgres-XC 1.2.1 Documentation
PrevFast BackwardChapter 59. BKI Backend InterfaceFast ForwardNext

59.4. Example

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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

create test_table 420 (cola = int4, colb = text)
open test_table
insert OID=421 ( 1 "value1" )
insert OID=422 ( 2 _null_ )
close test_table

PrevHomeNext
Structure of the Bootstrap BKI FileUpHow the Planner Uses Statistics