PostgreSQL

PostgreSQL Elephant Logo

70.6. BKI Example

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

Prev Up Next

70.5. Structure of the Bootstrap BKI File

Home

Chapter 71. How the Planner Uses Statistics

Copyright © 1996-2023 The PostgreSQL Global Development Group