sjis.sql

关系型数据库 Postgresql 6.5.2

drop table 寁嶼婡梡岅;
create table 寁嶼婡梡岅 (梡岅 text, 暘椶僐乕僪 varchar, 旛峫1A偩傛 char(16));
create index 寁嶼婡梡岅index1 on 寁嶼婡梡岅 using btree (梡岅);
create index 寁嶼婡梡岅index2 on 寁嶼婡梡岅 using hash (暘椶僐乕僪);
insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僨傿僗僾儗僀','婡A01忋');
insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僌儔僼傿僢僋僗','暘B10拞');
insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僾儘僌儔儅乕','恖Z01壓');
vacuum 寁嶼婡梡岅;
select * from 寁嶼婡梡岅;
select * from 寁嶼婡梡岅 where 暘椶僐乕僪 = '恖Z01壓';
select * from 寁嶼婡梡岅 where 暘椶僐乕僪 ~* '恖z01壓';
select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z01_';
select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z%';
select * from 寁嶼婡梡岅 where 梡岅 ~ '僐儞僺儏乕僞[僨僌]';
select * from 寁嶼婡梡岅 where 梡岅 ~* '僐儞僺儏乕僞[僨僌]';
select *,character_length(梡岅) from 寁嶼婡梡岅;
select *,octet_length(梡岅) from 寁嶼婡梡岅;
select *,position('僨' in 梡岅) from 寁嶼婡梡岅;
select *,substring(梡岅 from 10 for 4) from 寁嶼婡梡岅;
copy 寁嶼婡梡岅 to stdout;