/usr/share/postgresql/9.6/extension/pgmemcache--unpackaged--2.0.sql is in postgresql-9.6-pgmemcache 2.3.0-3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | -- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pgmemcache" to load this file. \quit
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_server_add(server_hostname text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_stats();
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_flush_all();
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_delete(key text, hold interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_delete(key text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_get(key text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_get(key bytea);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_get_multi(IN keys text[], OUT key text, OUT value text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_get_multi(IN keys bytea[], OUT key text, OUT value text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_set(key text, val text, expire timestamptz);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_set(key text, val text, expire interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_set(key text, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_set(key bytea, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_set(key text, val bytea);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_add(key text, val text, expire timestamptz);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_add(key text, val text, expire interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_add(key text, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_replace(key text, val text, expire timestamptz);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_replace(key text, val text, expire interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_replace(key text, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_append(key text, val text, expire timestamptz);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_append(key text, val text, expire interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_append(key text, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_prepend(key text, val text, expire timestamptz);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_prepend(key text, val text, expire interval);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_prepend(key text, val text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_incr(key text, increment int);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_incr(key text);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_decr(key text, decrement int);
ALTER EXTENSION pgmemcache ADD FUNCTION memcache_decr(key text);
|