File: 00_setup.sql

package info (click to toggle)
powa-archivist 5.1.1-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 2,224 kB
  • sloc: sql: 40,620; ansic: 495; makefile: 34; sh: 4
file content (9 lines) | stat: -rw-r--r-- 300 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
 
--Setup extension
CREATE SCHEMA "PGSS";
CREATE EXTENSION pg_stat_statements WITH SCHEMA "PGSS";
CREATE EXTENSION btree_gist;
CREATE SCHEMA "PoWA";
CREATE EXTENSION powa WITH SCHEMA "PoWA";

-- Test created ojects
SELECT * FROM "PoWA".powa_functions ORDER BY name, operation, priority, function_name;