quote.sql.out

来自「关系型数据库 Postgresql 6.5.2」· OUT 代码 · 共 33 行

QUERY: create table quoteTBL (f text);
QUERY: insert into quoteTBL values ('hello world');
QUERY: insert into quoteTBL values ('hello '' world');
QUERY: insert into quoteTBL values ('hello \' world');
QUERY: insert into quoteTBL values ('hello \\ world');
QUERY: insert into quoteTBL values ('hello \t world');
QUERY: insert into quoteTBL values ('hello
world
with
newlines
');
QUERY: insert into quoteTBL values ('hello " world');
QUERY: insert into quoteTBL values ('');
QUERY:   -- bad escape sequence
insert into quoteTBL values ('hello \y world');
WARN:Bad escape sequence, s[i] = 121
QUERY: select * from quoteTBL;
f                           
--------------------------- 
hello world                 
hello ' world               
hello ' world               
hello \ world               
hello 	 world               
hello
world
with
newlines
  
hello " world               
                            
QUERY: drop table quoteTBL;