File: pre_prepare.sql

package info (click to toggle)
preprepare 0.9-10
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 172 kB
  • sloc: ansic: 216; makefile: 40; sql: 37; sh: 10
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;