PostgreSQL 9.3.2ʸ��
前のページ	上に戻る	第 59章BKI�Хå��ɥ��󥿥ե��	次のページ

59.2. BKI��ޥ��

create tablename tableoid [bootstrap] [shared_relation] [without_oids] [rowtype_oid oid] (name1 = type1 [, name2 = type2, ...])

��̤�Ϳ��줿��ȡ�OID tableoid��tablename�Ȥ��ơ��֥��ޤ��

��󷿤�bootstrap.c��ľ�ܥ��ݡ��Ȥ��ޤ�� bool��bytea��char��1�Х��ȡˡ�name��int2��int4��regproc��regclass��regtype��text��oid��tid��xid��cid��int2vector��oidvector��_int4��ˡ�_text��ˡ�_oid��ˡ�_char��ˡ�_aclitem��ˡ� ��¾�η��ĥơ��֥��뤳�ȤϤǤ��ޤ��pg_type��λ��Ŭ�ڤʹ��ܤ��ޤǴ�λ��뤳�Ȥ��Ǥ��ޤ��󡣡ʤ��󷿤Τߥ֡��ȥ��ȥ�åפ��줿�ơ��֥�ǻ��Ѥ��ޤ��֡��ȥ��ȥ�åץ��ǡ��ʤ��Ȥ߹��߷��ޤ��Ȥ��ºݤ˰�̣��Ƥ��ޤ��

bootstrap��ꤵ�줿��硢�ơ��֥�ϥǥ��˺��ǡ�pg_class��pg_attribute�ʤɤˤ��ι��ܤ��Ͽ��ޤ�� äơ��ι��ܤ��insert��ޥ�ɤǡ˸��경��ޤǡ��̤�SQL��Ǥ��Υơ��֥�˥��Ǥ��ޤ�� Υ��ץ��pg_class�ʤɼ��Ȥ��뤿��˻��Ѥ��ޤ��

shared_relation��ꤵ�줿��硢�ơ��֥�Ϻ��ޤ�� without_oids��ꤵ��Ƥ��ʤ��¤�ơ��֥��OID��ޤ�� ơ��֥�ιԷ�OID��pg_type OID�ˤ�rowtype_oid��ǻ��Ǥ��ޤ�� ꤵ��ʤ��С�OID�ϼ�ưŪ��ޤ�� bootstrap ��ꤵ��Ƥ��С�rowtype_oid��Ω��ޤ��󡣤��ʸ�񲽤Τ��ˤȤ⤫��ϤǤ��ޤ��

open tablename

�ǡ��뤿��tablename��̾��դ��줿�ơ��֥�򳫤��ޤ�� ߳��Ƥ��ơ��֥��Ĥ��ޤ��

close [tablename]

��Ƥ��ơ��֥��Ĥ��ޤ��ơ��֥�̾��͡��ˡ�Ǹ��ǽ�Ǥ��ɬ��Ϥ��ޤ��

insert [OID = oid_value] ( value1 value2 ... )

value1��value2�ʤɤ��ͤȤ��ơ�oid_value��OID�Ȥ��Ƥ��ơ��֥�˹Ԥ��ޤ�� ⤷oid_value��0�ˡ��⤷��϶礬��ά��졢�ơ��֥뤬OID��ͭ��Ƥ��С��ͭ��OID��Ƥ��ޤ��

NULL�ͤ��̤ʥ���ɡ�_null_�ˤ�äƻ��Ǥ��ޤ�� ޤ��ͤ��Ű��ǰϤޤʤ��Фʤ�ޤ��

declare [unique] index indexname indexoid on tablename using amname ( opclass1 name1 [, ...] )

amname��᥽�åɤ��Ѥ��ơ�tablename��̾�դ��줿�ơ��֥��ˡ�OID indexoid��ͭ��롢indexname�Ȥ��̾��Υ��ǥå��ޤ�� ǥå��դ��ե��ɤϡ�name1��name2�ʤɡ��ƻ��Ѥ��黻�ҥ��饹��opclass1��opclass2�ʤɤȤ��줾��ƤФ�ޤ�� Υ��ǥå��ե��Ϻ��졢Ŭ�ڤʥ��ܤ��ޤ��Υ��ޥ�ɤǤϥ��ǥå��Ƥν��Ԥ��ޤ��

declare toast toasttableoid toastindexoid on tablename

tablename�Ȥ��̾��Υơ��֥��Ѥ�TOAST�ơ��֥��ޤ�� TOAST�ơ��֥��OID�Ȥ��toasttableoid��Ƥ�졢��Υ��ǥå��OID�Ȥ��toastindexoid��Ƥ��ޤ�� declare index��Ʊ�͡��ǥå��κ��ٱ䤵��ޤ��

build indices

��줿��ǥå��ޤ��

前のページ	ホーム	次のページ
BKI�ե��	上に戻る	BKI�ե��Υ֡��ȥ��ȥ�åפι��

59.2. BKI���ޥ��

59.2. BKI��ޥ��