Change ${quote_pgsql to quote ' as '' instead of \' because of a
[users/jgh/exim.git] / test / scripts / 9200-PostgreSQL / 9200
1 # pgsql lookups - expects specific data
2 exim -d-all+lookup -be
3 ${lookup pgsql {select name from them where id='ph10';}}
4 ${lookup pgsql {select name from them where id='ph10';}}
5 ${lookup pgsql {select name from them where id='xxxx';}}
6 ${lookup pgsql {select name from them where id='nothing';}}
7 ${lookup pgsql {select id,name from them where id='nothing';}}
8 ${lookup pgsql {delete from them where id='nonexist';}}
9 ${lookup pgsql {select * from them where id='quote2';}}
10 ${lookup pgsql {select * from them where id='newline';}}
11 ${lookup pgsql {select * from them where id='tab';}}
12 ${lookup pgsql {select * from them where name='${quote_pgsql:'stquot}';}}
13 ****
14 exim -d -bh 10.0.0.0
15 mail from:<a@b>
16 rcpt to:<c@d>
17 rcpt to:<c@d>
18 quit
19 ****
20 exim -odi -d CALLER
21 Test message
22 .
23 ****
24 exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be
25 ${lookup pgsql {select name from them where id='CALLER';}}
26 ****