quote.sql

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

create table quoteTBL (f text);

insert into quoteTBL values ('hello world');
insert into quoteTBL values ('hello '' world');
insert into quoteTBL values ('hello \' world');
insert into quoteTBL values ('hello \\ world');
insert into quoteTBL values ('hello \t world');
insert into quoteTBL values ('hello
world
with 
newlines
');
insert into quoteTBL values ('hello " world');
insert into quoteTBL values ('');
  -- bad escape sequence 
insert into quoteTBL values ('hello \y world');  
select * from quoteTBL;
drop table quoteTBL;