sjis.out

关系型数据库 Postgresql 6.5.2

QUERY: drop table 寁嶼婡梡岅;
QUERY: create table 寁嶼婡梡岅 (梡岅 text, 暘椶僐乕僪 varchar, 旛峫1A偩傛 char(16));
QUERY: create index 寁嶼婡梡岅index1 on 寁嶼婡梡岅 using btree (梡岅);
QUERY: create index 寁嶼婡梡岅index2 on 寁嶼婡梡岅 using hash (暘椶僐乕僪);
QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僨傿僗僾儗僀','婡A01忋');
QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僌儔僼傿僢僋僗','暘B10拞');
QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僾儘僌儔儅乕','恖Z01壓');
QUERY: vacuum 寁嶼婡梡岅;
QUERY: select * from 寁嶼婡梡岅;
梡岅                      |暘椶僐乕僪|旛峫1a偩傛
--------------------------+----------+----------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          
(3 rows)

QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 = '恖Z01壓';
梡岅                    |暘椶僐乕僪|旛峫1a偩傛
------------------------+----------+----------
僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
(1 row)

QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 ~* '恖z01壓';
梡岅                    |暘椶僐乕僪|旛峫1a偩傛
------------------------+----------+----------
僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
(1 row)

QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z01_';
梡岅                    |暘椶僐乕僪|旛峫1a偩傛
------------------------+----------+----------
僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
(1 row)

QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z%';
梡岅                    |暘椶僐乕僪|旛峫1a偩傛
------------------------+----------+----------
僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
(1 row)

QUERY: select * from 寁嶼婡梡岅 where 梡岅 ~ '僐儞僺儏乕僞[僨僌]';
梡岅                      |暘椶僐乕僪|旛峫1a偩傛
--------------------------+----------+----------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
(2 rows)

QUERY: select * from 寁嶼婡梡岅 where 梡岅 ~* '僐儞僺儏乕僞[僨僌]';
梡岅                      |暘椶僐乕僪|旛峫1a偩傛
--------------------------+----------+----------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
(2 rows)

QUERY: select *,character_length(梡岅) from 寁嶼婡梡岅;
梡岅                      |暘椶僐乕僪|旛峫1a偩傛|length
--------------------------+----------+----------+------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |    12
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |    13
僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |    12
(3 rows)

QUERY: select *,octet_length(梡岅) from 寁嶼婡梡岅;
梡岅                      |暘椶僐乕僪|旛峫1a偩傛|octet_length
--------------------------+----------+----------+------------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |          24
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |          26
僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |          24
(3 rows)

QUERY: select *,position('僨' in 梡岅) from 寁嶼婡梡岅;
梡岅                      |暘椶僐乕僪|旛峫1a偩傛|strpos
--------------------------+----------+----------+------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |     7
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |     0
僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |     0
(3 rows)

QUERY: select *,substring(梡岅 from 10 for 4) from 寁嶼婡梡岅;
梡岅                      |暘椶僐乕僪|旛峫1a偩傛|substr  
--------------------------+----------+----------+--------
僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |僾儗僀  
僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |傿僢僋僗
僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |儔儅乕  
(3 rows)

QUERY: copy 寁嶼婡梡岅 to stdout;
僐儞僺儏乕僞僨傿僗僾儗僀	婡A01忋	\N
僐儞僺儏乕僞僌儔僼傿僢僋僗	暘B10拞	\N
僐儞僺儏乕僞僾儘僌儔儅乕	恖Z01壓	\N