dblink/sql/dblink.sql

115 SELECT dblink_exec('ABORT');
142 SELECT dblink_exec('ABORT');
165 SELECT substr(dblink_exec(connection_parameters(),'INSERT INTO foo VALUES(10,''k'',''{"a10","b10","…
172 SELECT substr(dblink_exec('INSERT INTO foo VALUES(11,''l'',''{"a11","b11","c11"}'')'),1,6);
183 SELECT dblink_exec('UPDATE foo SET f3[2] = ''b99'' WHERE f1 = 11');
191 SELECT dblink_exec('UPDATE foobar SET f3[2] = ''b99'' WHERE f1 = 11',false);
194 SELECT dblink_exec('DELETE FROM foo WHERE f1 = 11');
245 SELECT dblink_exec('myconn','ABORT');
248 SELECT dblink_exec('myconn','BEGIN');
257 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
260 SELECT dblink_exec('myconn','COMMIT');
272 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
278 SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');
281 SELECT dblink_exec('myconn','ABORT');
302 SELECT dblink_exec('myconn','ABORT');
321 SELECT substr(dblink_exec('myconn','INSERT INTO foo VALUES(11,''l'',''{"a11","b11","c11"}'')'),1,6);
328 SELECT dblink_exec('myconn','UPDATE foo SET f3[2] = ''b99'' WHERE f1 = 11');
336 SELECT dblink_exec('myconn','DELETE FROM foo WHERE f1 = 11');
432 SELECT dblink_exec('LISTEN regression');
434 SELECT dblink_exec('LISTEN foobar');
436 SELECT dblink_exec('NOTIFY regression');
437 SELECT dblink_exec('NOTIFY foobar');
476 SELECT dblink_exec('myconn', 'SET datestyle = GERMAN, DMY;');
520 SELECT dblink_exec('myconn', 'SET intervalstyle = sql_standard;');
530 SELECT dblink_exec('myconn', 'SET datestyle = ISO, MDY;');
537 SELECT dblink_exec('myconn', 'SET datestyle = GERMAN, DMY;');