/usr/share/postgresql/10/extension/hstore--1.1--1.2.sql is in postgresql-10 10.6-0ubuntu0.18.04.1.
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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | /* contrib/hstore/hstore--1.1--1.2.sql */
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
\echo Use "ALTER EXTENSION hstore UPDATE TO '1.2'" to load this file. \quit
-- A version of 1.1 was shipped with these objects mistakenly in 9.3.0.
-- Therefore we only add them if we detect that they aren't already there and
-- dependent on the extension.
DO LANGUAGE plpgsql
$$
BEGIN
PERFORM 1
FROM pg_proc p
JOIN pg_depend d
ON p.proname = 'hstore_to_json_loose'
AND d.classid = 'pg_proc'::regclass
AND d.objid = p.oid
AND d.refclassid = 'pg_extension'::regclass
JOIN pg_extension x
ON d.refobjid = x.oid
AND x.extname = 'hstore';
IF NOT FOUND
THEN
CREATE FUNCTION hstore_to_json(hstore)
RETURNS json
AS 'MODULE_PATHNAME', 'hstore_to_json'
LANGUAGE C IMMUTABLE STRICT;
CREATE CAST (hstore AS json)
WITH FUNCTION hstore_to_json(hstore);
CREATE FUNCTION hstore_to_json_loose(hstore)
RETURNS json
AS 'MODULE_PATHNAME', 'hstore_to_json_loose'
LANGUAGE C IMMUTABLE STRICT;
END IF;
END;
$$;
|