blob: 0040bebb9bb4efb913c77350158a49d4ca88358d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
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;
|
