File: pre_prepare.sql

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 (12 lines) | stat: -rw-r--r-- 337 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
 
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();

EXECUTE test;