File: pre_prepare.out

package info (click to toggle)
preprepare 0.7-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 168 kB
  • ctags: 36
  • sloc: ansic: 212; makefile: 55; sql: 37; sh: 21
file content (19 lines) | stat: -rw-r--r-- 453 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
CREATE SCHEMA pre_prepare;
SET preprepare.relation = 'pre_prepare.statements';
SET client_min_messages = warning;
CREATE TABLE pre_prepare.statements(name text primary key, statement text);
RESET client_min_messages;
INSERT INTO pre_prepare.statements VALUES ('test', 'prepare test as select 1');
SELECT prepare_all();
NOTICE:  Preparing statement name: test
 prepare_all 
-------------
 
(1 row)

EXECUTE test;
 ?column? 
----------
        1
(1 row)