PostgreSQL 8.0.0 ��ĵ��PostgreSQL �й� ��
Prev	Fast Backward	Chapter 50. BKI ��˽ӿ�	Fast Forward	Next

50.2. BKI��

open tablename

��һ��Ϊ tablename �ı�׼��һ��

close [tablename]

�ر��Ϊ tablename�� ı�� tablename ��û�д򿪣��һ��û�и�� tablename��ô��ǰ�򿪵ı��رա�

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

��һ�� tablename �ı��ֶ��Բ��и��

The following column types are supported directly by bootstrap.c ֱ��֧��ֶ��ͣ� bool��bytea��char ��1 �ֽڣ�� name��int2��int4�� regproc��regclass�� regtype��text��oid�� tid��xid�� cid��int2vector��oidvector�� _int4 ��飩��_text ��飩�� _aclitem��飩��ǿ��Դ��ֶεı� ��ֻ��ڴ�� pg_type ��˺��ʵļ�¼֮��С�

�� bootstrap��ô�ı�ֻ�ڴ��ϴ�� pg_class��pg_attribute ��ϵͳ��κζ�� ı��޷��ͨ�� SQL ��ʣ�ֱ��Щ��¼��Ӳ�취�� insert ����롣 ��ѡ��ڴ�� pg_class ��

�� shared_relation��ô��Ϊ�� without_oids��򽫻�� OID��

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

�� value1�� value2�� Ϊ�ֶ�ֵ�Լ� oid_value ��Ϊ�� OID��ʶ��򿪵ı��һ��¼�¼�� oid_value Ϊ�㣨0��ʡ��˸��Ӿ䣬��ôʹ��һ�� OID��

NULL ��Ĺؼ�� _null_��հ׵�ֵ��˫��

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

��һ�� tablename �ı�� amname ��ʷ��һ�� indexname �� ֶν� name1��name2 �ȣ��ʹ�õĲ��ֱ�� opclass1��opclass2 �ȡ� ��ᴴ��ļ��ǡ��ϵͳ��¼��ݲ��ᱻ��ʼ��

��

��ǰ��

50.2. BKI����

50.2. BKI��