Files
iot-dc3/dc3/dependencies/postgres/initdb/00-iot-dc3-extensions.sql

33 lines
1.1 KiB
SQL

/*
* Copyright 2016-present the IoT DC3 original author or authors.
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
-- ----------------------------
-- Database extensions
-- ----------------------------
CREATE
EXTENSION IF NOT EXISTS timescaledb;
CREATE
EXTENSION IF NOT EXISTS vector;
CREATE
EXTENSION IF NOT EXISTS age;
-- Validate that the AGE shared library can be loaded during bootstrap.
-- Application sessions that use Cypher should still LOAD age and include
-- ag_catalog in their search_path before issuing AGE queries.
LOAD
'age';