dblink/sql/dblink.sql

153 SELECT dblink_exec('ABORT');
180 SELECT dblink_exec('ABORT');
203 SELECT substr(dblink_exec(connection_parameters(),'INSERT INTO foo VALUES(10,''k'',''{"a10","b10","…
210 SELECT substr(dblink_exec('INSERT INTO foo VALUES(11,''l'',''{"a11","b11","c11"}'')'),1,6);
221 SELECT dblink_exec('UPDATE foo SET f3[2] = ''b99'' WHERE f1 = 11');
229 SELECT dblink_exec('UPDATE foobar SET f3[2] = ''b99'' WHERE f1 = 11',false);
232 SELECT dblink_exec('DELETE FROM foo WHERE f1 = 11');
283 SELECT dblink_exec('myconn','ABORT');
286 SELECT dblink_exec('myconn','BEGIN');
295 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
298 SELECT dblink_exec('myconn','COMMIT');
310 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
316 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
319 SELECT dblink_exec('myconn','ABORT');
340 SELECT dblink_exec('myconn','ABORT');
359 SELECT substr(dblink_exec('myconn','INSERT INTO foo VALUES(11,''l'',''{"a11","b11","c11"}'')'),1,6);
366 SELECT dblink_exec('myconn','UPDATE foo SET f3[2] = ''b99'' WHERE f1 = 11');
374 SELECT dblink_exec('myconn','DELETE FROM foo WHERE f1 = 11');
470 SELECT dblink_exec('LISTEN regression');
472 SELECT dblink_exec('LISTEN foobar');
474 SELECT dblink_exec('NOTIFY regression');
475 SELECT dblink_exec('NOTIFY foobar');
514 SELECT dblink_exec('myconn', 'SET datestyle = GERMAN, DMY;');
558 SELECT dblink_exec('myconn', 'SET intervalstyle = sql_standard;');
568 SELECT dblink_exec('myconn', 'SET datestyle = ISO, MDY;');
575 SELECT dblink_exec('myconn', 'SET datestyle = GERMAN, DMY;');