-
Notifications
You must be signed in to change notification settings - Fork 39
/
sqlite_fdw--1.0--1.1.sql
35 lines (26 loc) · 1.06 KB
/
sqlite_fdw--1.0--1.1.sql
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
/* contrib/sqlite_fdw/sqlite_fdw--1.0--1.1.sql */
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
\echo Use "ALTER EXTENSION sqlite_fdw UPDATE TO '1.1'" to load this file. \quit
CREATE FUNCTION sqlite_fdw_get_connections (OUT server_name text,
OUT valid boolean)
RETURNS SETOF record
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT PARALLEL RESTRICTED;
CREATE FUNCTION sqlite_fdw_disconnect (text)
RETURNS bool
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT PARALLEL RESTRICTED;
COMMENT ON FUNCTION sqlite_fdw_disconnect(text)
IS 'closes a SQLite connection by name of FOREIGN SERVER';
CREATE FUNCTION sqlite_fdw_disconnect_all ()
RETURNS bool
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT PARALLEL RESTRICTED;
COMMENT ON FUNCTION sqlite_fdw_disconnect_all()
IS 'closes all opened SQLite connections';
COMMENT ON FUNCTION sqlite_fdw_handler()
IS 'SQLite foreign data wrapper handler';
COMMENT ON FUNCTION sqlite_fdw_validator(text[], oid)
IS 'SQLite foreign data wrapper options validator';
COMMENT ON FOREIGN DATA WRAPPER sqlite_fdw
IS 'SQLite foreign data wrapper';