pax_global_header00006660000000000000000000000064133002346310014505gustar00rootroot0000000000000052 comment=d22a36234403d9ccc6c4dbe018c9fd9f2950b3b2 pgsql.vim-2.1.1/000077500000000000000000000000001330023463100134265ustar00rootroot00000000000000pgsql.vim-2.1.1/README.md000066400000000000000000000045321330023463100147110ustar00rootroot00000000000000# Vim PostgreSQL syntax plugin ![pgsql syntax highlighting](https://raw.github.com/lifepillar/Resources/master/pgsql/pgsql.png) This plugin provides syntax highlighting and auto-completion support for PostgreSQL version 9.6 or above and for some of its extensions, including: - PL/pgSQL; - [PostGIS](http://postgis.net) (including PostGIS Topology); - [pgRouting](http://pgrouting.org); - [pgTap](http://pgtap.org). Besides, syntax highlighting for any language may be activated inside functions (see below). # Installation If your Vim supports packages (`echo has('packages')` prints `1`), I strongly recommend that you use them. Just clone this repo inside `pack/*/start`, e.g., cd ~/.vim git clone https://github.com/lifepillar/pgsql.vim.git pack/bundle/start/pgsql Otherwise, if you don't have a preferred installation method, I recommend installing [Pathogen](https://github.com/tpope/vim-pathogen), and then simply copy and paste: cd ~/.vim/bundle git clone https://github.com/lifepillar/pgsql.vim.git # Usage **For thorough documentation, see `:h pgsql.txt`.** Files with a `.pgsql` suffix are highlighted out of the box. If you want to highlight `.sql` files using this plugin by default, add this to your `.vimrc` (see `:h ft_sql.txt`): let g:sql_type_default = 'pgsql' Alternatively, after loading a `.sql` file use this command: :SQLSetType pgsql.vim To set the file type in new buffers use: :let b:sql_type_override='pgsql' | set ft=sql Code between `$pgsql$` or `$$` pairs is treated as PL/pgSQL and highlighted accordingly: ![PL/pgSQL snippet](https://raw.github.com/lifepillar/Resources/master/pgsql/plpgsql.png) You may set `g:pgsql_pl` to a list of file types to be used in user-defined functions. For example, after setting: let g:pgsql_pl = ['python'] code between `$python$` pairs will be highlighted as Python: ![PL/Pythonu snippet](https://raw.github.com/lifepillar/Resources/master/pgsql/plpython.png) # Hacking The syntax file is generated automatically. If you want to hack it, edit `src/pgsql.sql`, then execute: ```sh cd src make install ``` This will update `syntax/pgsql.vim`. The script has been tested in macOS, but it should work on any *nix system. # Acknowledgments This plugin was originally based on code from [space::tekk](https://github.com/spacetekk/pgsql.vim) (and completely rewritten). pgsql.vim-2.1.1/doc/000077500000000000000000000000001330023463100141735ustar00rootroot00000000000000pgsql.vim-2.1.1/doc/pgsql.txt000066400000000000000000000101021330023463100160540ustar00rootroot00000000000000*pgsql.txt* Syntax highlighting for PostgreSQL files Author: Lifepillar License: Public Domain _ ~ | | ~ ____ ____ ___ ____| | ~ | _ \ / _ |/___)/ _ | | ~ | |_| ( (_| |___ | |_| | | ~ | __/ \___ (___/ \__ |\_) ~ |_| (_____| |_| ~ The best PostgreSQL plugin for Vim! ==================================================================== CONTENTS *pgsql-contents* 1. Syntax highlighting .. |pgsql-syntax| 2. Customization ........ |pgsql-customization| 3. Autocompletion ....... |pgsql-autocompletion| 4. Contributing ......... |pgsql-contributing| 5. Credits .............. |pgsql-credits| ==================================================================== Section 1: Syntax highlighting *pgsql-syntax* Files with a .`pgsql` suffix are highlighted out of the box. If you want to highlight `.sql` files using this plugin by default, add this to your `.vimrc` (see |ft_sql.txt|): let g:sql_type_default = 'pgsql' Alternatively, after loading a `.sql` file use this command: :SQLSetType pgsql.vim To set the file type in new buffers use: :let b:sql_type_override='pgsql' | set ft=sql Identifiers starting with an underscore are highlighted as variables. It is recommended to adopt the convention of prefixing function parameters and local variables with `_`. Code between `$pgsql$` or `$$` pairs is interpreted as PL/pgSQL and highlighted accordingly. To use any other language, such as PL/Perl, PL/Python, PL/R, and so on, see |pgsql-customization|. Text enclosed between `$HERE$` pairs is highlighted as a (multi-line) string. ==================================================================== Section 2: Customization *pgsql-customization* To enable embedded syntax highlighting inside the body of user-defined functions for languages other than PL/pgSQL, you should set `g:pgsql_pl` accordingly. The value of the variable is a List of file types. For example, to use PL/Python and PL/R, you should define: let g:pgsql_pl = ['python', 'r'] After that, code between `$python$` pairs will be highlighted as Python, and code between `$r$` pairs will be highlighted as R. There is also a buffer-local variable called `b:pgsql_pl` to override the global settings in a single buffer. Support for the most common PostgreSQL extensions is enabled by default. You may set |g:pgsql_disabled_extensions| to a |List| of unwanted extensions. Highlight group definitions may be changed in your `vimrc`, too. For example: hi! link sqlKeyword Keyword See the source code for the available highlight groups. ==================================================================== Section 3: Autocompletion *pgsql-autocompletion* This plugin just defines a new dialect for Vim's SQL plugin. As such, it inherits the static and dynamic completion methods of that plugin (see |sql-completion|). So, for example, by default you may use `f` to complete function names, `T` to complete types, and so on. See |ft_sql.txt| for thorough documentation about SQL support in Vim. As far as I know, YouCompleteMe does not support SQL. If you use YouCompleteMe you may want to disable it for SQL buffers. Add this to `.vim/after/ftplugin/sql.vim`: if exists('g:ycm_filetype_blacklist') call extend(g:ycm_filetype_blacklist, { 'sql': 1 }) endif Of course, I recommend using my own MUcomplete plugin over YCM ;) ==================================================================== Section 4: Contributing *pgsql-contributing* For bug reports and feature requests please use: https://github.com/lifepillar/pgsql.vim/issues Pull requests are welcome, too! ==================================================================== Section 5: Credits *pgsql-credits* This plugin was originally a fork of space::tekk's https://github.com/spacetekk/pgsql.vim pgsql.vim-2.1.1/doc/tags000066400000000000000000000004731330023463100150600ustar00rootroot00000000000000pgsql-autocompletion pgsql.txt /*pgsql-autocompletion* pgsql-contents pgsql.txt /*pgsql-contents* pgsql-contributing pgsql.txt /*pgsql-contributing* pgsql-credits pgsql.txt /*pgsql-credits* pgsql-customization pgsql.txt /*pgsql-customization* pgsql-syntax pgsql.txt /*pgsql-syntax* pgsql.txt pgsql.txt /*pgsql.txt* pgsql.vim-2.1.1/ftdetect/000077500000000000000000000000001330023463100152305ustar00rootroot00000000000000pgsql.vim-2.1.1/ftdetect/pgsql.vim000066400000000000000000000001211330023463100170650ustar00rootroot00000000000000au BufNewFile,BufRead *.pgsql let b:sql_type_override='pgsql' | setfiletype sql pgsql.vim-2.1.1/indent/000077500000000000000000000000001330023463100147075ustar00rootroot00000000000000pgsql.vim-2.1.1/indent/pgsql.vim000066400000000000000000000276341330023463100165660ustar00rootroot00000000000000" Vim indent file " Language: SQL " Author: David Fishburn " Maintainer: Lifepillar " Notes: " Adapted from Vim's default indentation for SQL. " " Only load this indent file when no other was loaded. if exists("b:did_indent") finish endif let b:did_indent = 1 let b:current_indent = "pgsql" setlocal indentkeys-=0{ setlocal indentkeys-=0} setlocal indentkeys-=: setlocal indentkeys-=0# setlocal indentkeys-=e " This indicates formatting should take place when one of these " expressions is used. These expressions would normally be something " you would type at the BEGINNING of a line " SQL is generally case insensitive, so this files assumes that " These keywords are something that would trigger an indent LEFT, not " an indent right, since the SQLBlockStart is used for those keywords setlocal indentkeys+==~end,=~else,=~elseif,=~elsif,0=~when,0=) " GetSQLIndent is executed whenever one of the expressions " in the indentkeys is typed setlocal indentexpr=GetSQLIndent() " Only define the functions once. if exists("*GetSQLIndent") finish endif let s:keepcpo= &cpo set cpo&vim " List of all the statements that start a new block. " These are typically words that start a line. " IS is excluded, since it is difficult to determine when the " ending block is (especially for procedures/functions). let s:SQLBlockStart = '^\s*\%('. \ 'if\|else\|elseif\|elsif\|'. \ 'while\|loop\|do\|for\|'. \ 'declare\|begin\|'. \ 'case\|when\|merge\|exception'. \ '\)\>' let s:SQLBlockEnd = '^\s*\(end\)\>' " The indent level is also based on unmatched paranethesis " If a line has an extra "(" increase the indent " If a line has an extra ")" decrease the indent function! s:CountUnbalancedParan( line, paran_to_check ) let l = a:line let lp = substitute(l, '[^(]', '', 'g') let l = a:line let rp = substitute(l, '[^)]', '', 'g') if a:paran_to_check =~ ')' " echom 'CountUnbalancedParan ) returning: ' . " \ (strlen(rp) - strlen(lp)) return (strlen(rp) - strlen(lp)) elseif a:paran_to_check =~ '(' " echom 'CountUnbalancedParan ( returning: ' . " \ (strlen(lp) - strlen(rp)) return (strlen(lp) - strlen(rp)) else " echom 'CountUnbalancedParan unknown paran to check: ' . " \ a:paran_to_check return 0 endif endfunction " Unindent commands based on previous indent level function! s:CheckToIgnoreRightParan( prev_lnum, num_levels ) let lnum = a:prev_lnum let line = getline(lnum) let ends = 0 let num_right_paran = a:num_levels let ignore_paran = 0 let vircol = 1 while num_right_paran > 0 silent! exec 'norm! '.lnum."G\".vircol."\" let right_paran = search( ')', 'W' ) if right_paran != lnum " This should not happen since there should be at least " num_right_paran matches for this line break endif let vircol = virtcol(".") " if getline(".") =~ '^)' let matching_paran = searchpair('(', '', ')', 'bW', \ 's:IsColComment(line("."), col("."))') if matching_paran < 1 " No match found " echom 'CTIRP - no match found, ignoring' break endif if matching_paran == lnum " This was not an unmatched parantenses, start the search again " again after this column " echom 'CTIRP - same line match, ignoring' continue endif " echom 'CTIRP - match: ' . line(".") . ' ' . getline(".") if getline(matching_paran) =~? '\(if\|while\)\>' " echom 'CTIRP - if/while ignored: ' . line(".") . ' ' . getline(".") let ignore_paran = ignore_paran + 1 endif " One match found, decrease and check for further matches let num_right_paran = num_right_paran - 1 endwhile " Fallback - just move back one " return a:prev_indent - &sw return ignore_paran endfunction " Based on the keyword provided, loop through previous non empty " non comment lines to find the statement that initated the keyword. " Return its indent level " CASE .. " WHEN ... " Should return indent level of CASE " EXCEPTION .. " WHEN ... " something; " WHEN ... " Should return indent level of exception. function! s:GetStmtStarterIndent( keyword, curr_lnum ) let lnum = a:curr_lnum " Default - reduce indent by 1 let ind = indent(a:curr_lnum) - &sw if a:keyword =~? 'end' exec 'normal! ^' let stmts = '^\s*\%('. \ '\\|' . \ '\%(\%(\\)\|' . \ '\%(\%(\\)\|' . \ '\%(\%(\\)\|' . \ '\%(\%(\\)'. \ '\)' let matching_lnum = searchpair(stmts, '', '\\zs', 'bW', \ 's:IsColComment(line("."), col(".")) == 1') exec 'normal! $' if matching_lnum > 0 && matching_lnum < a:curr_lnum let ind = indent(matching_lnum) endif elseif a:keyword =~? 'when' exec 'normal! ^' let matching_lnum = searchpair( \ '\%(\\|\\|\', \ '', \ '\%(\%(\\)\|\%(\\)\)', \ 'bW', \ 's:IsColComment(line("."), col(".")) == 1') exec 'normal! $' if matching_lnum > 0 && matching_lnum < a:curr_lnum let ind = indent(matching_lnum) else let ind = indent(a:curr_lnum) endif endif return ind endfunction " Check if the line is a comment function! s:IsLineComment(lnum) let rc = synIDattr( \ synID(a:lnum, \ match(getline(a:lnum), '\S')+1, 0) \ , "name") \ =~? "comment" return rc endfunction " Check if the column is a comment function! s:IsColComment(lnum, cnum) let rc = synIDattr(synID(a:lnum, a:cnum, 0), "name") \ =~? "comment" return rc endfunction " Instead of returning a column position, return " an appropriate value as a factor of shiftwidth. function! s:ModuloIndent(ind) let ind = a:ind if ind > 0 let modulo = ind % &shiftwidth if modulo > 0 let ind = ind - modulo endif endif return ind endfunction " Find correct indent of a new line based upon the previous line function! GetSQLIndent() let lnum = v:lnum let ind = indent(lnum) " If the current line is a comment, leave the indent as is " Comment out this additional check since it affects the " indenting of =, and will not reindent comments as it should " if s:IsLineComment(lnum) == 1 " return ind " endif " Get previous non-blank line let prevlnum = prevnonblank(lnum - 1) if prevlnum <= 0 return ind endif if s:IsLineComment(prevlnum) == 1 if getline(v:lnum) =~ '^\s*\*' let ind = s:ModuloIndent(indent(prevlnum)) return ind + 1 endif " If the previous line is a comment, then return -1 " to tell Vim to use the formatoptions setting to determine " the indent to use " But only if the next line is blank. This would be true if " the user is typing, but it would not be true if the user " is reindenting the file if getline(v:lnum) =~ '^\s*$' return -1 endif endif " echom 'PREVIOUS INDENT: ' . indent(prevlnum) . ' LINE: ' . getline(prevlnum) " This is the line you just hit return on, it is not the current line " which is new and empty " Based on this line, we can determine how much to indent the new " line " Get default indent (from prev. line) let ind = indent(prevlnum) let prevline = getline(prevlnum) " Now check what's on the previous line to determine if the indent " should be changed, for example IF, BEGIN, should increase the indent " where END IF, END, should decrease the indent. if prevline =~? s:SQLBlockStart " Move indent in let ind = ind + &sw " echom 'prevl - SQLBlockStart - indent ' . ind . ' line: ' . prevline elseif prevline =~ '[()]' if prevline =~ '(' let num_unmatched_left = s:CountUnbalancedParan( prevline, '(' ) else let num_unmatched_left = 0 endif if prevline =~ ')' let num_unmatched_right = s:CountUnbalancedParan( prevline, ')' ) else let num_unmatched_right = 0 " let num_unmatched_right = s:CountUnbalancedParan( prevline, ')' ) endif if num_unmatched_left > 0 " There is a open left paranethesis " increase indent let ind = ind + ( &sw * num_unmatched_left ) elseif num_unmatched_right > 0 " if it is an unbalanced paranethesis only unindent if " it was part of a command (ie create table(..) ) " instead of part of an if (ie if (....) then) which should " maintain the indent level let ignore = s:CheckToIgnoreRightParan( prevlnum, num_unmatched_right ) " echom 'prevl - ) unbalanced - CTIRP - ignore: ' . ignore if prevline =~ '^\s*)' let ignore = ignore + 1 " echom 'prevl - begins ) unbalanced ignore: ' . ignore endif if (num_unmatched_right - ignore) > 0 let ind = ind - ( &sw * (num_unmatched_right - ignore) ) endif endif endif " echom 'CURRENT INDENT: ' . ind . ' LINE: ' . getline(v:lnum) " This is a new blank line since we just typed a carriage return " Check current line; search for simplistic matching start-of-block let line = getline(v:lnum) if line =~? '^\s*els' " Any line when you type else will automatically back up one " ident level (ie else, elseif, elsif) let ind = ind - &sw " echom 'curr - else - indent ' . ind elseif line =~? '^\s*end\>' let ind = s:GetStmtStarterIndent('end', v:lnum) " General case for end " let ind = ind - &sw " echom 'curr - end - indent ' . ind elseif line =~? '^\s*when\>' let ind = s:GetStmtStarterIndent('when', v:lnum) " If the WHEN clause is used with a MERGE or EXCEPTION " clause, do not change the indent level, since these " statements do not have a corresponding END statement. " if stmt_starter =~? 'case' " let ind = ind - &sw " endif " elseif line =~ '^\s*)\s*;\?\s*$' " elseif line =~ '^\s*)' elseif line =~ '^\s*)' let num_unmatched_right = s:CountUnbalancedParan( line, ')' ) let ignore = s:CheckToIgnoreRightParan( v:lnum, num_unmatched_right ) " If the line ends in a ), then reduce the indent " This catches items like: " CREATE TABLE T1( " c1 int, " c2 int " ); " But we do not want to unindent a line like: " IF ( c1 = 1 " AND c2 = 3 ) THEN " let num_unmatched_right = s:CountUnbalancedParan( line, ')' ) " if num_unmatched_right > 0 " elseif strpart( line, strlen(line)-1, 1 ) =~ ')' " let ind = ind - &sw if line =~ '^\s*)' " let ignore = ignore + 1 " echom 'curr - begins ) unbalanced ignore: ' . ignore endif if (num_unmatched_right - ignore) > 0 let ind = ind - ( &sw * (num_unmatched_right - ignore) ) endif " endif endif " echom 'final - indent ' . ind return s:ModuloIndent(ind) endfunction " Restore: let &cpo= s:keepcpo unlet s:keepcpo " vim: ts=4 fdm=marker sw=4 pgsql.vim-2.1.1/src/000077500000000000000000000000001330023463100142155ustar00rootroot00000000000000pgsql.vim-2.1.1/src/.gitignore000066400000000000000000000000401330023463100161770ustar00rootroot00000000000000createdb errcodes.txt pgsql.vim pgsql.vim-2.1.1/src/Makefile000066400000000000000000000021001330023463100156460ustar00rootroot00000000000000PSQLBIN := psql DBUSER := postgres DBNAME := vim_pgsql_syntax COMMON := common.sql SRCFILE := pgsql.sql SYNFILE := pgsql.vim TESTFILE := test.sql KEYWORDS := keywords.sql DESTDIR := ../syntax PSQL := PGOPTIONS='--client-min-messages=warning' $(PSQLBIN) -X --pset pager=off --quiet -v ON_ERROR_STOP=1 -U $(DBUSER) .PHONY: all all: $(SYNFILE) $(KEYWORDS) createdb: @- $(PSQL) -tc "select 1 from pg_database where datname = '$(DBNAME)'" | grep -q 1 || $(PSQL) -c "create database $(DBNAME)" touch createdb .PHONY: dropdb dropdb: @- dropdb $(DBNAME) 2>/dev/null || true @- $(RM) createdb errcodes.txt: curl -fsSL https://rawgit.com/postgres/postgres/master/src/backend/utils/errcodes.txt >errcodes.txt $(SYNFILE): createdb errcodes.txt $(COMMON) $(SRCFILE) @ $(PSQL) -d $(DBNAME) -f $(SRCFILE) $(KEYWORDS): $(TESTFILE) $(COMMON) @ $(PSQL) -d $(DBNAME) -f $< .PHONY: install install: $(SYNFILE) $(KEYWORDS) cp $< $(DESTDIR)/$(SYNFILE) .PHONY: clean clean: @- $(RM) $(SYNFILE) .PHONY: distclean distclean: clean dropdb @- $(RM) errcodes.txt @- $(RM) keywords.sql pgsql.vim-2.1.1/src/common.sql000066400000000000000000000207031330023463100162300ustar00rootroot00000000000000start transaction; set local client_min_messages to 'warning'; set local schema 'public'; select 'Populating the schema...'; drop table if exists errcodes; create table errcodes ( "errcode" text primary key ); \copy errcodes from program 'cat errcodes.txt | awk -F "[ ]+" ''{ if ($1 != "#" && $4 != "-" && $4 != "") { print $4 } }'' | sort | uniq' create or replace function legacy_extension_names() returns table (extname name) language sql immutable as $$ values ('plpythonu'::name), ('plpython2u'::name), ('hstore_plpythonu'::name), ('hstore_plpython2u'::name), ('ltree_plpythonu'::name), ('ltree_plpython2u'::name); $$; create or replace function extension_names() returns table ( extname name, extversion text ) language sql stable set search_path to "pg_catalog" as $$ select name, default_version from pg_available_extensions() where name not in ( -- Extensions to skip 'citus', 'plr' -- Not available for PostgreSQL 9.6 or later? ) and name not in (select extname::name from public.legacy_extension_names()); $$; create or replace function recommended_extensions() returns table (extname text) language sql immutable as $$ values ('pgrouting'), ('pgtap'), ('pldbgapi'), ('postgis'), ('postgis_topology'); $$; create or replace function create_extensions() returns setof void language plpgsql volatile set search_path to "public", "pg_catalog" set client_min_messages to 'error' as $$ declare _fn name; begin for _fn in select extname from extension_names() loop execute format('create extension if not exists "%s" cascade', _fn); end loop; return; end; $$; -- Among the keywords, we distinguish those corresponding to 'statements', as -- other SQL syntax types do. create or replace function get_statements() returns table (stm text) language sql immutable as $$ values ('create'), ('select'), ('abort'), ('alter'), ('analyze'), ('begin'), ('checkpoint'), ('close'), ('cluster'), ('comment'), ('commit'), ('constraints'), ('copy'), ('deallocate'), ('declare'), ('delete'), ('discard'), ('do'), ('drop'), ('end'), ('execute'), ('explain'), ('fetch'), ('grant'), ('import'), ('insert'), ('label'), ('listen'), ('load'), ('lock'), ('move'), ('notify'), ('prepare'), ('prepared'), ('reassign'), ('reindex'), ('refresh'), ('release'), ('reset'), ('revoke'), ('rollback'), ('savepoint'), ('security'), ('select'), ('set'), ('show'), ('start'), ('transaction'), ('truncate'), ('unlisten'), ('update'), ('vacuum'), ('values'), ('work'); $$; create or replace function get_builtin_functions() returns table (synfunction text) language sql stable set search_path to "information_schema" as $$ select distinct routine_name::text from routines where specific_schema = 'pg_catalog'; $$; create or replace function get_catalog_tables() returns table (table_name text) language sql stable set search_path to "information_schema" as $$ select table_name::text from tables where table_catalog = 'vim_pgsql_syntax' -- database name and table_name not like '\_%' and table_schema in ('pg_catalog', 'information_schema'); $$; create or replace function get_operators() returns table(keyword text) language sql stable set search_path to "pg_catalog", "public" as $$ -- Query adapted from \doS select distinct o.oprname::text as keyword from pg_catalog.pg_operator o left join pg_catalog.pg_namespace n on n.oid = o.oprnamespace where pg_catalog.pg_operator_is_visible(o.oid) order by keyword; $$; create or replace function get_types() returns table ("type" text) language sql stable set search_path to "pg_catalog", "public" as $$ select distinct typname::text from pg_type where typname not like '\_%' and typname not like 'pg_toast_%' and typname not in ('any', 'name', 'pg_buffercache', 'pg_stat_statements', 'trigger', 'unknown') and typname not in (select get_catalog_tables()); $$; -- Keywords that cannot be extracted from system catalogs (AFAIK) create or replace function get_additional_types() returns table ("type" text) language sql immutable as $$ -- Serial types are not true types, but merely a notational convenience for creating unique identifier columns. -- See https://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-SERIAL values ('smallserial'), ('serial'), ('bigserial'), ('serial2'), ('serial4'), ('serial8'), ('array'), ('bigint'), ('bit'), ('boolean'), ('char'), ('character'), ('cube'), ('decimal'), ('double'), ('int'), ('integer'), ('interval'), ('numeric'), ('precision'), ('real'), ('smallint'), ('text'), ('timestamp'), ('varchar'), ('varying'), ('xml'), ('zone'); $$; -- Built-in keywords (except statements and types) create or replace function get_keywords() returns table (keyword text) language sql stable set search_path to "public", "pg_catalog" as $$ select word from pg_get_keywords() except (select stm from get_statements() union select "type" from get_types() union select "type" from get_additional_types()); $$; create or replace function get_legacy_extension_objects(_extname name) returns table ( synclass text, synkeyword text ) language plpgsql immutable as $$ begin case _extname when 'plpythonu' then return query values ('function', 'plpython_call_handler'), ('function', 'plpython_inline_handler'), ('function', 'plpython_validator'); when 'plpython2u' then return query values ('function', 'plpython2_call_handler'), ('function', 'plpython2_inline_handler'), ('function', 'plpython2_validator'); when 'hstore_plpythonu' then return query values ('function', 'hstore_to_plpython'), ('function', 'plpython_to_hstore'); when 'hstore_plpython2u' then return query values ('function', 'hstore_to_plpython2'), ('function', 'plpython2_to_hstore'); when 'ltree_plpythonu' then return query values ('function', 'ltree_to_plpython'); when 'ltree_plpython2u' then return query values ('function', 'ltree_to_plpython2'); else raise exception 'Unknown legacy extension %', _extname; end case; end; $$; -- Get the list of functions, tables, types and views installed by a given extension. -- Query adapted from psql (\set ECHO_HIDDEN ON and \dx+ to see the query). create or replace function get_extension_objects(_extname name) returns table ( synclass text, synkeyword text ) language sql stable set search_path to "pg_catalog" as $$ select distinct regexp_replace(pg_catalog.pg_describe_object(classid, objid, 0), '^(function|table|type|view).*', '\1') as synclass, regexp_replace(pg_catalog.pg_describe_object(classid, objid, 0), '^(function|table|type|view)\s+([^\(]+).*', '\2') as synkeyword from pg_depend where refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass and refobjid = (select e.oid from pg_extension e where e.extname ~ format('^(%s)$', _extname)) and deptype = 'e' and pg_describe_object(classid, objid, 0) ~* '^(function|table|type|view)\s+[^_]' and not pg_describe_object(classid, objid, 0) ~* '\w+\.\_'; -- Do not match things like 'public._some_func()'; $$; -- Constants that cannot be extracted from system catalogs create or replace function get_additional_constants() returns table (keyword text) language sql immutable as $$ values ('pg_catalog'), ('information_schema'); $$; create or replace function get_errcodes() returns table (errcode text) language sql stable set search_path to "public" as $$ select "errcode" from errcodes; $$; create or replace function preflight_requirements() returns setof void language plpgsql stable set search_path to "public" as $$ declare _missing text; begin -- Refute to execute if db does not have the right name if current_database() <> 'vim_pgsql_syntax' then raise exception 'ERROR: Wrong database name!'; end if; -- Print a warning if a recommended extension is missing for _missing in select extname from recommended_extensions() except select extname::text from extension_names() loop raise warning '% is missing. No syntax items will be generated for it.', _missing; end loop; return; end; $$; select preflight_requirements(); select 'Creating extensions...'; select create_extensions(); commit; pgsql.vim-2.1.1/src/keywords.sql000066400000000000000000003277501330023463100166230ustar00rootroot00000000000000-- Statements abort alter analyze begin checkpoint close cluster comment commit constraints copy create deallocate declare delete discard do drop end execute explain fetch grant import insert label listen load lock move notify prepare prepared reassign refresh reindex release reset revoke rollback savepoint security select select set show start transaction truncate unlisten update vacuum values work -- Types abstime aclitem addbandarg addr addr_gid_seq addrfeat addrfeat_gid_seq agg_count agg_samealignment anyarray anyelement anyenum anynonarray anyrange bg bg_gid_seq bit bool box box2d box2df box3d bpchar breakpoint bytea cardinal_number char character_data chkpass cid cidr circle citext county county_gid_seq county_lookup countysub_lookup cousub cousub_gid_seq cstring cube date daterange dblink_pkey_results direction_lookup ean13 earth edges edges_gid_seq errcodes event_trigger faces faces_gid_seq fdw_handler featnames featnames_gid_seq float4 float8 frame gbtreekey16 gbtreekey32 gbtreekey4 gbtreekey8 gbtreekey_var geocode_settings geocode_settings_default geography geography_columns geometry geometry_columns geometry_dump geomval getfaceedges_returntype ghstore gidx gtrgm gtsvector hstore index_am_handler inet int2 int2vector int4 int4range int8 int8range intbig_gkey internal interval isbn isbn13 ismn ismn13 issn issn13 json jsonb language_handler layer line lo loader_lookuptables loader_platform loader_variables lquery lseg ltree ltree_gist ltxtquery macaddr macaddr8 money norm_addy numeric numrange oid oidvector opaque pagc_gaz pagc_gaz_id_seq pagc_lex pagc_lex_id_seq pagc_rules pagc_rules_id_seq path pg_all_foreign_keys pg_ddl_command pg_dependencies pg_lsn pg_ndistinct pg_node_tree pgis_abs pgr_costresult pgr_costresult3 pgr_geomresult place place_gid_seq place_lookup point polygon proxyinfo query_int rastbandarg raster raster_columns raster_overviews reclassarg record refcursor regclass regconfig regdictionary regnamespace regoper regoperator regproc regprocedure regrole regtype reltime secondary_unit_lookup seg smgr spatial_ref_sys spheroid sql_identifier state state_gid_seq state_lookup stdaddr street_type_lookup summarystats tabblock tabblock_gid_seq tablefunc_crosstab_2 tablefunc_crosstab_3 tablefunc_crosstab_4 tap_funky targetinfo text tid time time_stamp timestamp timestamptz timetz tinterval topoelement topoelementarray topogeometry topology topology_id_seq tract tract_gid_seq tsm_handler tsquery tsrange tstzrange tsvector txid_snapshot unionarg upc us_gaz us_gaz_id_seq us_lex us_lex_id_seq us_rules us_rules_id_seq uuid valid_detail validatetopology_returntype var varbit varchar void xid xml yes_or_no zcta5 zcta5_gid_seq zip_lookup zip_lookup_all zip_lookup_base zip_state zip_state_loc -- Additional types array bigint bigserial bit boolean char character cube decimal double int integer interval numeric precision real serial serial2 serial4 serial8 smallint smallserial text timestamp varchar varying xml zone pg_toast_1234 -- Built-in functions RI_FKey_cascade_del() RI_FKey_cascade_upd() RI_FKey_check_ins() RI_FKey_check_upd() RI_FKey_noaction_del() RI_FKey_noaction_upd() RI_FKey_restrict_del() RI_FKey_restrict_upd() RI_FKey_setdefault_del() RI_FKey_setdefault_upd() RI_FKey_setnull_del() RI_FKey_setnull_upd() abbrev() abs() abstime() abstimeeq() abstimege() abstimegt() abstimein() abstimele() abstimelt() abstimene() abstimeout() abstimerecv() abstimesend() aclcontains() acldefault() aclexplode() aclinsert() aclitemeq() aclitemin() aclitemout() aclremove() acos() acosd() age() amvalidate() any_in() any_out() anyarray_in() anyarray_out() anyarray_recv() anyarray_send() anyelement_in() anyelement_out() anyenum_in() anyenum_out() anynonarray_in() anynonarray_out() anyrange_in() anyrange_out() anytextcat() area() areajoinsel() areasel() array_agg() array_agg_array_finalfn() array_agg_array_transfn() array_agg_finalfn() array_agg_transfn() array_append() array_cat() array_dims() array_eq() array_fill() array_ge() array_gt() array_in() array_larger() array_le() array_length() array_lower() array_lt() array_ndims() array_ne() array_out() array_position() array_positions() array_prepend() array_recv() array_remove() array_replace() array_send() array_smaller() array_to_json() array_to_string() array_to_tsvector() array_typanalyze() array_upper() arraycontained() arraycontains() arraycontjoinsel() arraycontsel() arrayoverlap() ascii() ascii_to_mic() ascii_to_utf8() asin() asind() atan() atan2() atan2d() atand() avg() bernoulli() big5_to_euc_tw() big5_to_mic() big5_to_utf8() binary_upgrade_create_empty_extension() binary_upgrade_set_next_array_pg_type_oid() binary_upgrade_set_next_heap_pg_class_oid() binary_upgrade_set_next_index_pg_class_oid() binary_upgrade_set_next_pg_authid_oid() binary_upgrade_set_next_pg_enum_oid() binary_upgrade_set_next_pg_type_oid() binary_upgrade_set_next_toast_pg_class_oid() binary_upgrade_set_next_toast_pg_type_oid() binary_upgrade_set_record_init_privs() bit() bit_and() bit_in() bit_length() bit_or() bit_out() bit_recv() bit_send() bitand() bitcat() bitcmp() biteq() bitge() bitgt() bitle() bitlt() bitne() bitnot() bitor() bitshiftleft() bitshiftright() bittypmodin() bittypmodout() bitxor() bool() bool_accum() bool_accum_inv() bool_alltrue() bool_and() bool_anytrue() bool_or() booland_statefunc() booleq() boolge() boolgt() boolin() boolle() boollt() boolne() boolor_statefunc() boolout() boolrecv() boolsend() bound_box() box() box_above() box_above_eq() box_add() box_below() box_below_eq() box_center() box_contain() box_contain_pt() box_contained() box_distance() box_div() box_eq() box_ge() box_gt() box_in() box_intersect() box_le() box_left() box_lt() box_mul() box_out() box_overabove() box_overbelow() box_overlap() box_overleft() box_overright() box_recv() box_right() box_same() box_send() box_sub() bpchar() bpchar_larger() bpchar_pattern_ge() bpchar_pattern_gt() bpchar_pattern_le() bpchar_pattern_lt() bpchar_smaller() bpchar_sortsupport() bpcharcmp() bpchareq() bpcharge() bpchargt() bpchariclike() bpcharicnlike() bpcharicregexeq() bpcharicregexne() bpcharin() bpcharle() bpcharlike() bpcharlt() bpcharne() bpcharnlike() bpcharout() bpcharrecv() bpcharregexeq() bpcharregexne() bpcharsend() bpchartypmodin() bpchartypmodout() brin_desummarize_range() brin_inclusion_add_value() brin_inclusion_consistent() brin_inclusion_opcinfo() brin_inclusion_union() brin_minmax_add_value() brin_minmax_consistent() brin_minmax_opcinfo() brin_minmax_union() brin_summarize_new_values() brin_summarize_range() brinhandler() broadcast() btabstimecmp() btarraycmp() btboolcmp() btbpchar_pattern_cmp() btbpchar_pattern_sortsupport() btcharcmp() btfloat48cmp() btfloat4cmp() btfloat4sortsupport() btfloat84cmp() btfloat8cmp() btfloat8sortsupport() bthandler() btint24cmp() btint28cmp() btint2cmp() btint2sortsupport() btint42cmp() btint48cmp() btint4cmp() btint4sortsupport() btint82cmp() btint84cmp() btint8cmp() btint8sortsupport() btnamecmp() btnamesortsupport() btoidcmp() btoidsortsupport() btoidvectorcmp() btrecordcmp() btrecordimagecmp() btreltimecmp() btrim() bttext_pattern_cmp() bttext_pattern_sortsupport() bttextcmp() bttextsortsupport() bttidcmp() bttintervalcmp() bytea_sortsupport() bytea_string_agg_finalfn() bytea_string_agg_transfn() byteacat() byteacmp() byteaeq() byteage() byteagt() byteain() byteale() bytealike() bytealt() byteane() byteanlike() byteaout() bytearecv() byteasend() cardinality() cash_cmp() cash_div_cash() cash_div_flt4() cash_div_flt8() cash_div_int2() cash_div_int4() cash_div_int8() cash_eq() cash_ge() cash_gt() cash_in() cash_le() cash_lt() cash_mi() cash_mul_flt4() cash_mul_flt8() cash_mul_int2() cash_mul_int4() cash_mul_int8() cash_ne() cash_out() cash_pl() cash_recv() cash_send() cash_words() cashlarger() cashsmaller() cbrt() ceil() ceiling() center() char() char_length() character_length() chareq() charge() chargt() charin() charle() charlt() charne() charout() charrecv() charsend() chr() cideq() cidin() cidout() cidr() cidr_in() cidr_out() cidr_recv() cidr_send() cidrecv() cidsend() circle() circle_above() circle_add_pt() circle_below() circle_center() circle_contain() circle_contain_pt() circle_contained() circle_distance() circle_div_pt() circle_eq() circle_ge() circle_gt() circle_in() circle_le() circle_left() circle_lt() circle_mul_pt() circle_ne() circle_out() circle_overabove() circle_overbelow() circle_overlap() circle_overleft() circle_overright() circle_recv() circle_right() circle_same() circle_send() circle_sub_pt() clock_timestamp() close_lb() close_ls() close_lseg() close_pb() close_pl() close_ps() close_sb() close_sl() col_description() concat() concat_ws() contjoinsel() contsel() convert() convert_from() convert_to() corr() cos() cosd() cot() cotd() count() covar_pop() covar_samp() cstring_in() cstring_out() cstring_recv() cstring_send() cume_dist() cume_dist_final() current_database() current_query() current_schema() current_schemas() current_setting() current_user() currtid() currtid2() currval() cursor_to_xml() cursor_to_xmlschema() database_to_xml() database_to_xml_and_xmlschema() database_to_xmlschema() date() date_cmp() date_cmp_timestamp() date_cmp_timestamptz() date_eq() date_eq_timestamp() date_eq_timestamptz() date_ge() date_ge_timestamp() date_ge_timestamptz() date_gt() date_gt_timestamp() date_gt_timestamptz() date_in() date_larger() date_le() date_le_timestamp() date_le_timestamptz() date_lt() date_lt_timestamp() date_lt_timestamptz() date_mi() date_mi_interval() date_mii() date_ne() date_ne_timestamp() date_ne_timestamptz() date_out() date_part() date_pl_interval() date_pli() date_recv() date_send() date_smaller() date_sortsupport() date_trunc() daterange() daterange_canonical() daterange_subdiff() datetime_pl() datetimetz_pl() dcbrt() decode() degrees() dense_rank() dense_rank_final() dexp() diagonal() diameter() dispell_init() dispell_lexize() dist_cpoint() dist_cpoly() dist_lb() dist_pb() dist_pc() dist_pl() dist_polyp() dist_ppath() dist_ppoly() dist_ps() dist_sb() dist_sl() div() dlog1() dlog10() domain_in() domain_recv() dpow() dround() dsimple_init() dsimple_lexize() dsnowball_init() dsnowball_lexize() dsqrt() dsynonym_init() dsynonym_lexize() dtrunc() elem_contained_by_range() encode() enum_cmp() enum_eq() enum_first() enum_ge() enum_gt() enum_in() enum_larger() enum_last() enum_le() enum_lt() enum_ne() enum_out() enum_range() enum_recv() enum_send() enum_smaller() eqjoinsel() eqsel() euc_cn_to_mic() euc_cn_to_utf8() euc_jis_2004_to_shift_jis_2004() euc_jis_2004_to_utf8() euc_jp_to_mic() euc_jp_to_sjis() euc_jp_to_utf8() euc_kr_to_mic() euc_kr_to_utf8() euc_tw_to_big5() euc_tw_to_mic() euc_tw_to_utf8() event_trigger_in() event_trigger_out() every() exp() factorial() family() fdw_handler_in() fdw_handler_out() first_value() float4() float48div() float48eq() float48ge() float48gt() float48le() float48lt() float48mi() float48mul() float48ne() float48pl() float4_accum() float4abs() float4div() float4eq() float4ge() float4gt() float4in() float4larger() float4le() float4lt() float4mi() float4mul() float4ne() float4out() float4pl() float4recv() float4send() float4smaller() float4um() float4up() float8() float84div() float84eq() float84ge() float84gt() float84le() float84lt() float84mi() float84mul() float84ne() float84pl() float8_accum() float8_avg() float8_combine() float8_corr() float8_covar_pop() float8_covar_samp() float8_regr_accum() float8_regr_avgx() float8_regr_avgy() float8_regr_combine() float8_regr_intercept() float8_regr_r2() float8_regr_slope() float8_regr_sxx() float8_regr_sxy() float8_regr_syy() float8_stddev_pop() float8_stddev_samp() float8_var_pop() float8_var_samp() float8abs() float8div() float8eq() float8ge() float8gt() float8in() float8larger() float8le() float8lt() float8mi() float8mul() float8ne() float8out() float8pl() float8recv() float8send() float8smaller() float8um() float8up() floor() flt4_mul_cash() flt8_mul_cash() fmgr_c_validator() fmgr_internal_validator() fmgr_sql_validator() format() format_type() gb18030_to_utf8() gbk_to_utf8() generate_series() generate_subscripts() get_bit() get_byte() get_current_ts_config() getdatabaseencoding() getpgusername() gin_clean_pending_list() gin_cmp_prefix() gin_cmp_tslexeme() gin_compare_jsonb() gin_consistent_jsonb() gin_consistent_jsonb_path() gin_extract_jsonb() gin_extract_jsonb_path() gin_extract_jsonb_query() gin_extract_jsonb_query_path() gin_extract_tsquery() gin_extract_tsvector() gin_triconsistent_jsonb() gin_triconsistent_jsonb_path() gin_tsquery_consistent() gin_tsquery_triconsistent() ginarrayconsistent() ginarrayextract() ginarraytriconsistent() ginhandler() ginqueryarrayextract() gist_box_compress() gist_box_consistent() gist_box_decompress() gist_box_fetch() gist_box_penalty() gist_box_picksplit() gist_box_same() gist_box_union() gist_circle_compress() gist_circle_consistent() gist_circle_distance() gist_point_compress() gist_point_consistent() gist_point_distance() gist_point_fetch() gist_poly_compress() gist_poly_consistent() gist_poly_distance() gisthandler() gtsquery_compress() gtsquery_consistent() gtsquery_decompress() gtsquery_penalty() gtsquery_picksplit() gtsquery_same() gtsquery_union() gtsvector_compress() gtsvector_consistent() gtsvector_decompress() gtsvector_penalty() gtsvector_picksplit() gtsvector_same() gtsvector_union() gtsvectorin() gtsvectorout() has_any_column_privilege() has_column_privilege() has_database_privilege() has_foreign_data_wrapper_privilege() has_function_privilege() has_language_privilege() has_schema_privilege() has_sequence_privilege() has_server_privilege() has_table_privilege() has_tablespace_privilege() has_type_privilege() hash_aclitem() hash_array() hash_numeric() hash_range() hashbpchar() hashchar() hashenum() hashfloat4() hashfloat8() hashhandler() hashinet() hashint2() hashint4() hashint8() hashmacaddr() hashmacaddr8() hashname() hashoid() hashoidvector() hashtext() hashvarlena() height() host() hostmask() iclikejoinsel() iclikesel() icnlikejoinsel() icnlikesel() icregexeqjoinsel() icregexeqsel() icregexnejoinsel() icregexnesel() index_am_handler_in() index_am_handler_out() inet_client_addr() inet_client_port() inet_gist_compress() inet_gist_consistent() inet_gist_decompress() inet_gist_fetch() inet_gist_penalty() inet_gist_picksplit() inet_gist_same() inet_gist_union() inet_in() inet_merge() inet_out() inet_recv() inet_same_family() inet_send() inet_server_addr() inet_server_port() inet_spg_choose() inet_spg_config() inet_spg_inner_consistent() inet_spg_leaf_consistent() inet_spg_picksplit() inetand() inetmi() inetmi_int8() inetnot() inetor() inetpl() initcap() int2() int24div() int24eq() int24ge() int24gt() int24le() int24lt() int24mi() int24mul() int24ne() int24pl() int28div() int28eq() int28ge() int28gt() int28le() int28lt() int28mi() int28mul() int28ne() int28pl() int2_accum() int2_accum_inv() int2_avg_accum() int2_avg_accum_inv() int2_mul_cash() int2_sum() int2abs() int2and() int2div() int2eq() int2ge() int2gt() int2in() int2int4_sum() int2larger() int2le() int2lt() int2mi() int2mod() int2mul() int2ne() int2not() int2or() int2out() int2pl() int2recv() int2send() int2shl() int2shr() int2smaller() int2um() int2up() int2vectorin() int2vectorout() int2vectorrecv() int2vectorsend() int2xor() int4() int42div() int42eq() int42ge() int42gt() int42le() int42lt() int42mi() int42mul() int42ne() int42pl() int48div() int48eq() int48ge() int48gt() int48le() int48lt() int48mi() int48mul() int48ne() int48pl() int4_accum() int4_accum_inv() int4_avg_accum() int4_avg_accum_inv() int4_avg_combine() int4_mul_cash() int4_sum() int4abs() int4and() int4div() int4eq() int4ge() int4gt() int4in() int4inc() int4larger() int4le() int4lt() int4mi() int4mod() int4mul() int4ne() int4not() int4or() int4out() int4pl() int4range() int4range_canonical() int4range_subdiff() int4recv() int4send() int4shl() int4shr() int4smaller() int4um() int4up() int4xor() int8() int82div() int82eq() int82ge() int82gt() int82le() int82lt() int82mi() int82mul() int82ne() int82pl() int84div() int84eq() int84ge() int84gt() int84le() int84lt() int84mi() int84mul() int84ne() int84pl() int8_accum() int8_accum_inv() int8_avg() int8_avg_accum() int8_avg_accum_inv() int8_avg_combine() int8_avg_deserialize() int8_avg_serialize() int8_mul_cash() int8_sum() int8abs() int8and() int8dec() int8dec_any() int8div() int8eq() int8ge() int8gt() int8in() int8inc() int8inc_any() int8inc_float8_float8() int8larger() int8le() int8lt() int8mi() int8mod() int8mul() int8ne() int8not() int8or() int8out() int8pl() int8pl_inet() int8range() int8range_canonical() int8range_subdiff() int8recv() int8send() int8shl() int8shr() int8smaller() int8um() int8up() int8xor() integer_pl_date() inter_lb() inter_sb() inter_sl() internal_in() internal_out() interval() interval_accum() interval_accum_inv() interval_avg() interval_cmp() interval_combine() interval_div() interval_eq() interval_ge() interval_gt() interval_hash() interval_in() interval_larger() interval_le() interval_lt() interval_mi() interval_mul() interval_ne() interval_out() interval_pl() interval_pl_date() interval_pl_time() interval_pl_timestamp() interval_pl_timestamptz() interval_pl_timetz() interval_recv() interval_send() interval_smaller() interval_transform() interval_um() intervaltypmodin() intervaltypmodout() intinterval() isclosed() isempty() isfinite() ishorizontal() iso8859_1_to_utf8() iso8859_to_utf8() iso_to_koi8r() iso_to_mic() iso_to_win1251() iso_to_win866() isopen() isparallel() isperp() isvertical() johab_to_utf8() json_agg() json_agg_finalfn() json_agg_transfn() json_array_element() json_array_element_text() json_array_elements() json_array_elements_text() json_array_length() json_build_array() json_build_object() json_each() json_each_text() json_extract_path() json_extract_path_text() json_in() json_object() json_object_agg() json_object_agg_finalfn() json_object_agg_transfn() json_object_field() json_object_field_text() json_object_keys() json_out() json_populate_record() json_populate_recordset() json_recv() json_send() json_strip_nulls() json_to_record() json_to_recordset() json_typeof() jsonb_agg() jsonb_agg_finalfn() jsonb_agg_transfn() jsonb_array_element() jsonb_array_element_text() jsonb_array_elements() jsonb_array_elements_text() jsonb_array_length() jsonb_build_array() jsonb_build_object() jsonb_cmp() jsonb_concat() jsonb_contained() jsonb_contains() jsonb_delete() jsonb_delete_path() jsonb_each() jsonb_each_text() jsonb_eq() jsonb_exists() jsonb_exists_all() jsonb_exists_any() jsonb_extract_path() jsonb_extract_path_text() jsonb_ge() jsonb_gt() jsonb_hash() jsonb_in() jsonb_insert() jsonb_le() jsonb_lt() jsonb_ne() jsonb_object() jsonb_object_agg() jsonb_object_agg_finalfn() jsonb_object_agg_transfn() jsonb_object_field() jsonb_object_field_text() jsonb_object_keys() jsonb_out() jsonb_populate_record() jsonb_populate_recordset() jsonb_pretty() jsonb_recv() jsonb_send() jsonb_set() jsonb_strip_nulls() jsonb_to_record() jsonb_to_recordset() jsonb_typeof() justify_days() justify_hours() justify_interval() koi8r_to_iso() koi8r_to_mic() koi8r_to_utf8() koi8r_to_win1251() koi8r_to_win866() koi8u_to_utf8() lag() language_handler_in() language_handler_out() last_value() lastval() latin1_to_mic() latin2_to_mic() latin2_to_win1250() latin3_to_mic() latin4_to_mic() lead() left() length() like() like_escape() likejoinsel() likesel() line() line_distance() line_eq() line_horizontal() line_in() line_interpt() line_intersect() line_out() line_parallel() line_perp() line_recv() line_send() line_vertical() ln() lo_close() lo_creat() lo_create() lo_export() lo_from_bytea() lo_get() lo_import() lo_lseek() lo_lseek64() lo_open() lo_put() lo_tell() lo_tell64() lo_truncate() lo_truncate64() lo_unlink() log() loread() lower() lower_inc() lower_inf() lowrite() lpad() lseg() lseg_center() lseg_distance() lseg_eq() lseg_ge() lseg_gt() lseg_horizontal() lseg_in() lseg_interpt() lseg_intersect() lseg_le() lseg_length() lseg_lt() lseg_ne() lseg_out() lseg_parallel() lseg_perp() lseg_recv() lseg_send() lseg_vertical() ltrim() macaddr() macaddr8() macaddr8_and() macaddr8_cmp() macaddr8_eq() macaddr8_ge() macaddr8_gt() macaddr8_in() macaddr8_le() macaddr8_lt() macaddr8_ne() macaddr8_not() macaddr8_or() macaddr8_out() macaddr8_recv() macaddr8_send() macaddr8_set7bit() macaddr_and() macaddr_cmp() macaddr_eq() macaddr_ge() macaddr_gt() macaddr_in() macaddr_le() macaddr_lt() macaddr_ne() macaddr_not() macaddr_or() macaddr_out() macaddr_recv() macaddr_send() macaddr_sortsupport() make_date() make_interval() make_time() make_timestamp() make_timestamptz() makeaclitem() masklen() max() md5() mic_to_ascii() mic_to_big5() mic_to_euc_cn() mic_to_euc_jp() mic_to_euc_kr() mic_to_euc_tw() mic_to_iso() mic_to_koi8r() mic_to_latin1() mic_to_latin2() mic_to_latin3() mic_to_latin4() mic_to_sjis() mic_to_win1250() mic_to_win1251() mic_to_win866() min() mktinterval() mod() mode() mode_final() money() mul_d_interval() mxid_age() name() nameeq() namege() namegt() nameiclike() nameicnlike() nameicregexeq() nameicregexne() namein() namele() namelike() namelt() namene() namenlike() nameout() namerecv() nameregexeq() nameregexne() namesend() neqjoinsel() neqsel() netmask() network() network_cmp() network_eq() network_ge() network_gt() network_larger() network_le() network_lt() network_ne() network_overlap() network_smaller() network_sub() network_subeq() network_sup() network_supeq() networkjoinsel() networksel() nextval() nlikejoinsel() nlikesel() notlike() now() npoints() nth_value() ntile() num_nonnulls() num_nulls() numeric() numeric_abs() numeric_accum() numeric_accum_inv() numeric_add() numeric_avg() numeric_avg_accum() numeric_avg_combine() numeric_avg_deserialize() numeric_avg_serialize() numeric_cmp() numeric_combine() numeric_deserialize() numeric_div() numeric_div_trunc() numeric_eq() numeric_exp() numeric_fac() numeric_ge() numeric_gt() numeric_in() numeric_inc() numeric_larger() numeric_le() numeric_ln() numeric_log() numeric_lt() numeric_mod() numeric_mul() numeric_ne() numeric_out() numeric_poly_avg() numeric_poly_combine() numeric_poly_deserialize() numeric_poly_serialize() numeric_poly_stddev_pop() numeric_poly_stddev_samp() numeric_poly_sum() numeric_poly_var_pop() numeric_poly_var_samp() numeric_power() numeric_recv() numeric_send() numeric_serialize() numeric_smaller() numeric_sortsupport() numeric_sqrt() numeric_stddev_pop() numeric_stddev_samp() numeric_sub() numeric_sum() numeric_transform() numeric_uminus() numeric_uplus() numeric_var_pop() numeric_var_samp() numerictypmodin() numerictypmodout() numnode() numrange() numrange_subdiff() obj_description() octet_length() oid() oideq() oidge() oidgt() oidin() oidlarger() oidle() oidlt() oidne() oidout() oidrecv() oidsend() oidsmaller() oidvectoreq() oidvectorge() oidvectorgt() oidvectorin() oidvectorle() oidvectorlt() oidvectorne() oidvectorout() oidvectorrecv() oidvectorsend() oidvectortypes() on_pb() on_pl() on_ppath() on_ps() on_sb() on_sl() opaque_in() opaque_out() ordered_set_transition() ordered_set_transition_multi() overlaps() overlay() parse_ident() path() path_add() path_add_pt() path_center() path_contain_pt() path_distance() path_div_pt() path_in() path_inter() path_length() path_mul_pt() path_n_eq() path_n_ge() path_n_gt() path_n_le() path_n_lt() path_npoints() path_out() path_recv() path_send() path_sub_pt() pclose() percent_rank() percent_rank_final() percentile_cont() percentile_cont_float8_final() percentile_cont_float8_multi_final() percentile_cont_interval_final() percentile_cont_interval_multi_final() percentile_disc() percentile_disc_final() percentile_disc_multi_final() pg_advisory_lock() pg_advisory_lock_shared() pg_advisory_unlock() pg_advisory_unlock_all() pg_advisory_unlock_shared() pg_advisory_xact_lock() pg_advisory_xact_lock_shared() pg_available_extension_versions() pg_available_extensions() pg_backend_pid() pg_backup_start_time() pg_blocking_pids() pg_cancel_backend() pg_char_to_encoding() pg_client_encoding() pg_collation_actual_version() pg_collation_for() pg_collation_is_visible() pg_column_is_updatable() pg_column_size() pg_conf_load_time() pg_config() pg_control_checkpoint() pg_control_init() pg_control_recovery() pg_control_system() pg_conversion_is_visible() pg_create_logical_replication_slot() pg_create_physical_replication_slot() pg_create_restore_point() pg_current_logfile() pg_current_wal_flush_lsn() pg_current_wal_insert_lsn() pg_current_wal_lsn() pg_cursor() pg_database_size() pg_ddl_command_in() pg_ddl_command_out() pg_ddl_command_recv() pg_ddl_command_send() pg_dependencies_in() pg_dependencies_out() pg_dependencies_recv() pg_dependencies_send() pg_describe_object() pg_drop_replication_slot() pg_encoding_max_length() pg_encoding_to_char() pg_event_trigger_ddl_commands() pg_event_trigger_dropped_objects() pg_event_trigger_table_rewrite_oid() pg_event_trigger_table_rewrite_reason() pg_export_snapshot() pg_extension_config_dump() pg_extension_update_paths() pg_file_length() pg_file_read() pg_file_rename() pg_file_unlink() pg_file_write() pg_filenode_relation() pg_function_is_visible() pg_get_constraintdef() pg_get_expr() pg_get_function_arg_default() pg_get_function_arguments() pg_get_function_identity_arguments() pg_get_function_result() pg_get_functiondef() pg_get_indexdef() pg_get_keywords() pg_get_multixact_members() pg_get_object_address() pg_get_partition_constraintdef() pg_get_partkeydef() pg_get_publication_tables() pg_get_replica_identity_index() pg_get_replication_slots() pg_get_ruledef() pg_get_serial_sequence() pg_get_statisticsobjdef() pg_get_triggerdef() pg_get_userbyid() pg_get_viewdef() pg_has_role() pg_hba_file_rules() pg_identify_object() pg_identify_object_as_address() pg_import_system_collations() pg_index_column_has_property() pg_index_has_property() pg_indexam_has_property() pg_indexes_size() pg_is_in_backup() pg_is_in_recovery() pg_is_other_temp_schema() pg_is_wal_replay_paused() pg_isolation_test_session_is_blocked() pg_last_committed_xact() pg_last_wal_receive_lsn() pg_last_wal_replay_lsn() pg_last_xact_replay_timestamp() pg_listening_channels() pg_lock_status() pg_logdir_ls() pg_logfile_rotate() pg_logical_emit_message() pg_logical_slot_get_binary_changes() pg_logical_slot_get_changes() pg_logical_slot_peek_binary_changes() pg_logical_slot_peek_changes() pg_ls_dir() pg_ls_logdir() pg_ls_waldir() pg_lsn_cmp() pg_lsn_eq() pg_lsn_ge() pg_lsn_gt() pg_lsn_hash() pg_lsn_in() pg_lsn_le() pg_lsn_lt() pg_lsn_mi() pg_lsn_ne() pg_lsn_out() pg_lsn_recv() pg_lsn_send() pg_my_temp_schema() pg_ndistinct_in() pg_ndistinct_out() pg_ndistinct_recv() pg_ndistinct_send() pg_node_tree_in() pg_node_tree_out() pg_node_tree_recv() pg_node_tree_send() pg_notification_queue_usage() pg_notify() pg_opclass_is_visible() pg_operator_is_visible() pg_opfamily_is_visible() pg_options_to_table() pg_postmaster_start_time() pg_prepared_statement() pg_prepared_xact() pg_read_binary_file() pg_read_file() pg_relation_filenode() pg_relation_filepath() pg_relation_is_publishable() pg_relation_is_updatable() pg_relation_size() pg_reload_conf() pg_replication_origin_advance() pg_replication_origin_create() pg_replication_origin_drop() pg_replication_origin_oid() pg_replication_origin_progress() pg_replication_origin_session_is_setup() pg_replication_origin_session_progress() pg_replication_origin_session_reset() pg_replication_origin_session_setup() pg_replication_origin_xact_reset() pg_replication_origin_xact_setup() pg_rotate_logfile() pg_safe_snapshot_blocking_pids() pg_sequence_last_value() pg_sequence_parameters() pg_show_all_file_settings() pg_show_all_settings() pg_show_replication_origin_status() pg_size_bytes() pg_size_pretty() pg_sleep() pg_sleep_for() pg_sleep_until() pg_start_backup() pg_stat_clear_snapshot() pg_stat_file() pg_stat_get_activity() pg_stat_get_analyze_count() pg_stat_get_archiver() pg_stat_get_autoanalyze_count() pg_stat_get_autovacuum_count() pg_stat_get_backend_activity() pg_stat_get_backend_activity_start() pg_stat_get_backend_client_addr() pg_stat_get_backend_client_port() pg_stat_get_backend_dbid() pg_stat_get_backend_idset() pg_stat_get_backend_pid() pg_stat_get_backend_start() pg_stat_get_backend_userid() pg_stat_get_backend_wait_event() pg_stat_get_backend_wait_event_type() pg_stat_get_backend_xact_start() pg_stat_get_bgwriter_buf_written_checkpoints() pg_stat_get_bgwriter_buf_written_clean() pg_stat_get_bgwriter_maxwritten_clean() pg_stat_get_bgwriter_requested_checkpoints() pg_stat_get_bgwriter_stat_reset_time() pg_stat_get_bgwriter_timed_checkpoints() pg_stat_get_blocks_fetched() pg_stat_get_blocks_hit() pg_stat_get_buf_alloc() pg_stat_get_buf_fsync_backend() pg_stat_get_buf_written_backend() pg_stat_get_checkpoint_sync_time() pg_stat_get_checkpoint_write_time() pg_stat_get_db_blk_read_time() pg_stat_get_db_blk_write_time() pg_stat_get_db_blocks_fetched() pg_stat_get_db_blocks_hit() pg_stat_get_db_conflict_all() pg_stat_get_db_conflict_bufferpin() pg_stat_get_db_conflict_lock() pg_stat_get_db_conflict_snapshot() pg_stat_get_db_conflict_startup_deadlock() pg_stat_get_db_conflict_tablespace() pg_stat_get_db_deadlocks() pg_stat_get_db_numbackends() pg_stat_get_db_stat_reset_time() pg_stat_get_db_temp_bytes() pg_stat_get_db_temp_files() pg_stat_get_db_tuples_deleted() pg_stat_get_db_tuples_fetched() pg_stat_get_db_tuples_inserted() pg_stat_get_db_tuples_returned() pg_stat_get_db_tuples_updated() pg_stat_get_db_xact_commit() pg_stat_get_db_xact_rollback() pg_stat_get_dead_tuples() pg_stat_get_function_calls() pg_stat_get_function_self_time() pg_stat_get_function_total_time() pg_stat_get_last_analyze_time() pg_stat_get_last_autoanalyze_time() pg_stat_get_last_autovacuum_time() pg_stat_get_last_vacuum_time() pg_stat_get_live_tuples() pg_stat_get_mod_since_analyze() pg_stat_get_numscans() pg_stat_get_progress_info() pg_stat_get_snapshot_timestamp() pg_stat_get_subscription() pg_stat_get_tuples_deleted() pg_stat_get_tuples_fetched() pg_stat_get_tuples_hot_updated() pg_stat_get_tuples_inserted() pg_stat_get_tuples_returned() pg_stat_get_tuples_updated() pg_stat_get_vacuum_count() pg_stat_get_wal_receiver() pg_stat_get_wal_senders() pg_stat_get_xact_blocks_fetched() pg_stat_get_xact_blocks_hit() pg_stat_get_xact_function_calls() pg_stat_get_xact_function_self_time() pg_stat_get_xact_function_total_time() pg_stat_get_xact_numscans() pg_stat_get_xact_tuples_deleted() pg_stat_get_xact_tuples_fetched() pg_stat_get_xact_tuples_hot_updated() pg_stat_get_xact_tuples_inserted() pg_stat_get_xact_tuples_returned() pg_stat_get_xact_tuples_updated() pg_stat_reset() pg_stat_reset_shared() pg_stat_reset_single_function_counters() pg_stat_reset_single_table_counters() pg_statistics_obj_is_visible() pg_stop_backup() pg_switch_wal() pg_table_is_visible() pg_table_size() pg_tablespace_databases() pg_tablespace_location() pg_tablespace_size() pg_terminate_backend() pg_timezone_abbrevs() pg_timezone_names() pg_total_relation_size() pg_trigger_depth() pg_try_advisory_lock() pg_try_advisory_lock_shared() pg_try_advisory_xact_lock() pg_try_advisory_xact_lock_shared() pg_ts_config_is_visible() pg_ts_dict_is_visible() pg_ts_parser_is_visible() pg_ts_template_is_visible() pg_type_is_visible() pg_typeof() pg_wal_lsn_diff() pg_wal_replay_pause() pg_wal_replay_resume() pg_walfile_name() pg_walfile_name_offset() pg_xact_commit_timestamp() phraseto_tsquery() pi() plainto_tsquery() plperl_call_handler() plperl_inline_handler() plperl_validator() plperlu_call_handler() plperlu_inline_handler() plperlu_validator() plpgsql_call_handler() plpgsql_inline_handler() plpgsql_validator() plpython3_call_handler() plpython3_inline_handler() plpython3_validator() pltcl_call_handler() pltclu_call_handler() point() point_above() point_add() point_below() point_distance() point_div() point_eq() point_horiz() point_in() point_left() point_mul() point_ne() point_out() point_recv() point_right() point_send() point_sub() point_vert() poly_above() poly_below() poly_center() poly_contain() poly_contain_pt() poly_contained() poly_distance() poly_in() poly_left() poly_npoints() poly_out() poly_overabove() poly_overbelow() poly_overlap() poly_overleft() poly_overright() poly_recv() poly_right() poly_same() poly_send() polygon() popen() position() positionjoinsel() positionsel() postgresql_fdw_validator() pow() power() prsd_end() prsd_headline() prsd_lextype() prsd_nexttoken() prsd_start() pt_contained_circle() pt_contained_poly() query_to_xml() query_to_xml_and_xmlschema() query_to_xmlschema() querytree() quote_ident() quote_literal() quote_nullable() radians() radius() random() range_adjacent() range_after() range_before() range_cmp() range_contained_by() range_contains() range_contains_elem() range_eq() range_ge() range_gist_compress() range_gist_consistent() range_gist_decompress() range_gist_fetch() range_gist_penalty() range_gist_picksplit() range_gist_same() range_gist_union() range_gt() range_in() range_intersect() range_le() range_lt() range_merge() range_minus() range_ne() range_out() range_overlaps() range_overleft() range_overright() range_recv() range_send() range_typanalyze() range_union() rangesel() rank() rank_final() record_eq() record_ge() record_gt() record_image_eq() record_image_ge() record_image_gt() record_image_le() record_image_lt() record_image_ne() record_in() record_le() record_lt() record_ne() record_out() record_recv() record_send() regclass() regclassin() regclassout() regclassrecv() regclasssend() regconfigin() regconfigout() regconfigrecv() regconfigsend() regdictionaryin() regdictionaryout() regdictionaryrecv() regdictionarysend() regexeqjoinsel() regexeqsel() regexnejoinsel() regexnesel() regexp_match() regexp_matches() regexp_replace() regexp_split_to_array() regexp_split_to_table() regnamespacein() regnamespaceout() regnamespacerecv() regnamespacesend() regoperatorin() regoperatorout() regoperatorrecv() regoperatorsend() regoperin() regoperout() regoperrecv() regopersend() regprocedurein() regprocedureout() regprocedurerecv() regproceduresend() regprocin() regprocout() regprocrecv() regprocsend() regr_avgx() regr_avgy() regr_count() regr_intercept() regr_r2() regr_slope() regr_sxx() regr_sxy() regr_syy() regrolein() regroleout() regrolerecv() regrolesend() regtypein() regtypeout() regtyperecv() regtypesend() reltime() reltimeeq() reltimege() reltimegt() reltimein() reltimele() reltimelt() reltimene() reltimeout() reltimerecv() reltimesend() repeat() replace() reverse() right() round() row_number() row_security_active() row_to_json() rpad() rtrim() scalargtjoinsel() scalargtsel() scalarltjoinsel() scalarltsel() scale() schema_to_xml() schema_to_xml_and_xmlschema() schema_to_xmlschema() session_user() set_bit() set_byte() set_config() set_masklen() setseed() setval() setweight() shell_in() shell_out() shift_jis_2004_to_euc_jis_2004() shift_jis_2004_to_utf8() shobj_description() sign() similar_escape() sin() sind() sjis_to_euc_jp() sjis_to_mic() sjis_to_utf8() slope() smgreq() smgrin() smgrne() smgrout() spg_box_quad_choose() spg_box_quad_config() spg_box_quad_inner_consistent() spg_box_quad_leaf_consistent() spg_box_quad_picksplit() spg_kd_choose() spg_kd_config() spg_kd_inner_consistent() spg_kd_picksplit() spg_quad_choose() spg_quad_config() spg_quad_inner_consistent() spg_quad_leaf_consistent() spg_quad_picksplit() spg_range_quad_choose() spg_range_quad_config() spg_range_quad_inner_consistent() spg_range_quad_leaf_consistent() spg_range_quad_picksplit() spg_text_choose() spg_text_config() spg_text_inner_consistent() spg_text_leaf_consistent() spg_text_picksplit() spghandler() split_part() sqrt() statement_timestamp() stddev() stddev_pop() stddev_samp() string_agg() string_agg_finalfn() string_agg_transfn() string_to_array() strip() strpos() substr() substring() sum() suppress_redundant_updates_trigger() system() table_to_xml() table_to_xml_and_xmlschema() table_to_xmlschema() tan() tand() text() text_ge() text_gt() text_larger() text_le() text_lt() text_pattern_ge() text_pattern_gt() text_pattern_le() text_pattern_lt() text_smaller() textanycat() textcat() texteq() texticlike() texticnlike() texticregexeq() texticregexne() textin() textlen() textlike() textne() textnlike() textout() textrecv() textregexeq() textregexne() textsend() thesaurus_init() thesaurus_lexize() tideq() tidge() tidgt() tidin() tidlarger() tidle() tidlt() tidne() tidout() tidrecv() tidsend() tidsmaller() time() time_cmp() time_eq() time_ge() time_gt() time_hash() time_in() time_larger() time_le() time_lt() time_mi_interval() time_mi_time() time_ne() time_out() time_pl_interval() time_recv() time_send() time_smaller() time_transform() timedate_pl() timemi() timenow() timeofday() timepl() timestamp() timestamp_cmp() timestamp_cmp_date() timestamp_cmp_timestamptz() timestamp_eq() timestamp_eq_date() timestamp_eq_timestamptz() timestamp_ge() timestamp_ge_date() timestamp_ge_timestamptz() timestamp_gt() timestamp_gt_date() timestamp_gt_timestamptz() timestamp_hash() timestamp_in() timestamp_izone_transform() timestamp_larger() timestamp_le() timestamp_le_date() timestamp_le_timestamptz() timestamp_lt() timestamp_lt_date() timestamp_lt_timestamptz() timestamp_mi() timestamp_mi_interval() timestamp_ne() timestamp_ne_date() timestamp_ne_timestamptz() timestamp_out() timestamp_pl_interval() timestamp_recv() timestamp_send() timestamp_smaller() timestamp_sortsupport() timestamp_transform() timestamp_zone_transform() timestamptypmodin() timestamptypmodout() timestamptz() timestamptz_cmp() timestamptz_cmp_date() timestamptz_cmp_timestamp() timestamptz_eq() timestamptz_eq_date() timestamptz_eq_timestamp() timestamptz_ge() timestamptz_ge_date() timestamptz_ge_timestamp() timestamptz_gt() timestamptz_gt_date() timestamptz_gt_timestamp() timestamptz_in() timestamptz_larger() timestamptz_le() timestamptz_le_date() timestamptz_le_timestamp() timestamptz_lt() timestamptz_lt_date() timestamptz_lt_timestamp() timestamptz_mi() timestamptz_mi_interval() timestamptz_ne() timestamptz_ne_date() timestamptz_ne_timestamp() timestamptz_out() timestamptz_pl_interval() timestamptz_recv() timestamptz_send() timestamptz_smaller() timestamptztypmodin() timestamptztypmodout() timetypmodin() timetypmodout() timetz() timetz_cmp() timetz_eq() timetz_ge() timetz_gt() timetz_hash() timetz_in() timetz_larger() timetz_le() timetz_lt() timetz_mi_interval() timetz_ne() timetz_out() timetz_pl_interval() timetz_recv() timetz_send() timetz_smaller() timetzdate_pl() timetztypmodin() timetztypmodout() timezone() tinterval() tintervalct() tintervalend() tintervaleq() tintervalge() tintervalgt() tintervalin() tintervalle() tintervalleneq() tintervallenge() tintervallengt() tintervallenle() tintervallenlt() tintervallenne() tintervallt() tintervalne() tintervalout() tintervalov() tintervalrecv() tintervalrel() tintervalsame() tintervalsend() tintervalstart() to_ascii() to_char() to_date() to_hex() to_json() to_jsonb() to_number() to_regclass() to_regnamespace() to_regoper() to_regoperator() to_regproc() to_regprocedure() to_regrole() to_regtype() to_timestamp() to_tsquery() to_tsvector() transaction_timestamp() translate() trigger_in() trigger_out() trunc() ts_debug() ts_delete() ts_filter() ts_headline() ts_lexize() ts_match_qv() ts_match_tq() ts_match_tt() ts_match_vq() ts_parse() ts_rank() ts_rank_cd() ts_rewrite() ts_stat() ts_token_type() ts_typanalyze() tsm_handler_in() tsm_handler_out() tsmatchjoinsel() tsmatchsel() tsq_mcontained() tsq_mcontains() tsquery_and() tsquery_cmp() tsquery_eq() tsquery_ge() tsquery_gt() tsquery_le() tsquery_lt() tsquery_ne() tsquery_not() tsquery_or() tsquery_phrase() tsqueryin() tsqueryout() tsqueryrecv() tsquerysend() tsrange() tsrange_subdiff() tstzrange() tstzrange_subdiff() tsvector_cmp() tsvector_concat() tsvector_eq() tsvector_ge() tsvector_gt() tsvector_le() tsvector_lt() tsvector_ne() tsvector_to_array() tsvector_update_trigger() tsvector_update_trigger_column() tsvectorin() tsvectorout() tsvectorrecv() tsvectorsend() txid_current() txid_current_if_assigned() txid_current_snapshot() txid_snapshot_in() txid_snapshot_out() txid_snapshot_recv() txid_snapshot_send() txid_snapshot_xip() txid_snapshot_xmax() txid_snapshot_xmin() txid_status() txid_visible_in_snapshot() uhc_to_utf8() unique_key_recheck() unknownin() unknownout() unknownrecv() unknownsend() unnest() upper() upper_inc() upper_inf() utf8_to_ascii() utf8_to_big5() utf8_to_euc_cn() utf8_to_euc_jis_2004() utf8_to_euc_jp() utf8_to_euc_kr() utf8_to_euc_tw() utf8_to_gb18030() utf8_to_gbk() utf8_to_iso8859() utf8_to_iso8859_1() utf8_to_johab() utf8_to_koi8r() utf8_to_koi8u() utf8_to_shift_jis_2004() utf8_to_sjis() utf8_to_uhc() utf8_to_win() uuid_cmp() uuid_eq() uuid_ge() uuid_gt() uuid_hash() uuid_in() uuid_le() uuid_lt() uuid_ne() uuid_out() uuid_recv() uuid_send() uuid_sortsupport() var_pop() var_samp() varbit() varbit_in() varbit_out() varbit_recv() varbit_send() varbit_transform() varbitcmp() varbiteq() varbitge() varbitgt() varbitle() varbitlt() varbitne() varbittypmodin() varbittypmodout() varchar() varchar_transform() varcharin() varcharout() varcharrecv() varcharsend() varchartypmodin() varchartypmodout() variance() version() void_in() void_out() void_recv() void_send() width() width_bucket() win1250_to_latin2() win1250_to_mic() win1251_to_iso() win1251_to_koi8r() win1251_to_mic() win1251_to_win866() win866_to_iso() win866_to_koi8r() win866_to_mic() win866_to_win1251() win_to_utf8() xideq() xideqint4() xidin() xidneq() xidneqint4() xidout() xidrecv() xidsend() xml() xml_in() xml_is_well_formed() xml_is_well_formed_content() xml_is_well_formed_document() xml_out() xml_recv() xml_send() xmlagg() xmlcomment() xmlconcat2() xmlexists() xmlvalidate() xpath() xpath_exists() -- Extension: refint check_foreign_key() -- function check_primary_key() -- function -- Extension: postgis addauth() -- function addgeometrycolumn() -- function addoverviewconstraints() -- function addrasterconstraints() -- function box() -- function box2d() -- function box2d_in() -- function box2d_out() -- function box2df_in() -- function box2df_out() -- function box3d() -- function box3d_in() -- function box3d_out() -- function box3dtobox() -- function bytea() -- function checkauth() -- function checkauthtrigger() -- function contains_2d() -- function disablelongtransactions() -- function dropgeometrycolumn() -- function dropgeometrytable() -- function dropoverviewconstraints() -- function droprasterconstraints() -- function enablelongtransactions() -- function equals() -- function find_srid() -- function geog_brin_inclusion_add_value() -- function geography() -- function geography_analyze() -- function geography_cmp() -- function geography_distance_knn() -- function geography_eq() -- function geography_ge() -- function geography_gist_compress() -- function geography_gist_consistent() -- function geography_gist_decompress() -- function geography_gist_distance() -- function geography_gist_penalty() -- function geography_gist_picksplit() -- function geography_gist_same() -- function geography_gist_union() -- function geography_gt() -- function geography_in() -- function geography_le() -- function geography_lt() -- function geography_out() -- function geography_overlaps() -- function geography_recv() -- function geography_send() -- function geography_typmod_in() -- function geography_typmod_out() -- function geom2d_brin_inclusion_add_value() -- function geom3d_brin_inclusion_add_value() -- function geom4d_brin_inclusion_add_value() -- function geometry() -- function geometry_above() -- function geometry_analyze() -- function geometry_below() -- function geometry_cmp() -- function geometry_contained_by_raster() -- function geometry_contains() -- function geometry_distance_box() -- function geometry_distance_centroid() -- function geometry_distance_centroid_nd() -- function geometry_distance_cpa() -- function geometry_eq() -- function geometry_ge() -- function geometry_gist_compress_2d() -- function geometry_gist_compress_nd() -- function geometry_gist_consistent_2d() -- function geometry_gist_consistent_nd() -- function geometry_gist_decompress_2d() -- function geometry_gist_decompress_nd() -- function geometry_gist_distance_2d() -- function geometry_gist_distance_nd() -- function geometry_gist_penalty_2d() -- function geometry_gist_penalty_nd() -- function geometry_gist_picksplit_2d() -- function geometry_gist_picksplit_nd() -- function geometry_gist_same_2d() -- function geometry_gist_same_nd() -- function geometry_gist_union_2d() -- function geometry_gist_union_nd() -- function geometry_gt() -- function geometry_in() -- function geometry_le() -- function geometry_left() -- function geometry_lt() -- function geometry_out() -- function geometry_overabove() -- function geometry_overbelow() -- function geometry_overlaps() -- function geometry_overlaps_nd() -- function geometry_overleft() -- function geometry_overright() -- function geometry_raster_contain() -- function geometry_raster_overlap() -- function geometry_recv() -- function geometry_right() -- function geometry_same() -- function geometry_send() -- function geometry_typmod_in() -- function geometry_typmod_out() -- function geometry_within() -- function geometrytype() -- function geomfromewkb() -- function geomfromewkt() -- function get_proj4_from_srid() -- function gettransactionid() -- function gidx_in() -- function gidx_out() -- function gserialized_gist_joinsel_2d() -- function gserialized_gist_joinsel_nd() -- function gserialized_gist_sel_2d() -- function gserialized_gist_sel_nd() -- function is_contained_2d() -- function lockrow() -- function longtransactionsenabled() -- function overlaps_2d() -- function overlaps_geog() -- function overlaps_nd() -- function path() -- function pgis_abs_in() -- function pgis_abs_out() -- function pgis_asgeobuf_finalfn() -- function pgis_asgeobuf_transfn() -- function pgis_asmvt_finalfn() -- function pgis_asmvt_transfn() -- function pgis_geometry_accum_finalfn() -- function pgis_geometry_accum_transfn() -- function pgis_geometry_clusterintersecting_finalfn() -- function pgis_geometry_clusterwithin_finalfn() -- function pgis_geometry_collect_finalfn() -- function pgis_geometry_makeline_finalfn() -- function pgis_geometry_polygonize_finalfn() -- function pgis_geometry_union_finalfn() -- function point() -- function polygon() -- function populate_geometry_columns() -- function postgis_addbbox() -- function postgis_cache_bbox() -- function postgis_constraint_dims() -- function postgis_constraint_srid() -- function postgis_constraint_type() -- function postgis_dropbbox() -- function postgis_full_version() -- function postgis_gdal_version() -- function postgis_geos_version() -- function postgis_getbbox() -- function postgis_hasbbox() -- function postgis_lib_build_date() -- function postgis_lib_version() -- function postgis_libjson_version() -- function postgis_liblwgeom_version() -- function postgis_libprotobuf_version() -- function postgis_libxml_version() -- function postgis_noop() -- function postgis_proj_version() -- function postgis_raster_lib_build_date() -- function postgis_raster_lib_version() -- function postgis_raster_scripts_installed() -- function postgis_scripts_build_date() -- function postgis_scripts_installed() -- function postgis_scripts_released() -- function postgis_svn_version() -- function postgis_transform_geometry() -- function postgis_type_name() -- function postgis_typmod_dims() -- function postgis_typmod_srid() -- function postgis_typmod_type() -- function postgis_version() -- function raster_above() -- function raster_below() -- function raster_contain() -- function raster_contained() -- function raster_contained_by_geometry() -- function raster_eq() -- function raster_geometry_contain() -- function raster_geometry_overlap() -- function raster_hash() -- function raster_in() -- function raster_left() -- function raster_out() -- function raster_overabove() -- function raster_overbelow() -- function raster_overlap() -- function raster_overleft() -- function raster_overright() -- function raster_right() -- function raster_same() -- function spheroid_in() -- function spheroid_out() -- function st_3dclosestpoint() -- function st_3ddfullywithin() -- function st_3ddistance() -- function st_3ddwithin() -- function st_3dextent() -- function st_3dintersects() -- function st_3dlength() -- function st_3dlength_spheroid() -- function st_3dlongestline() -- function st_3dmakebox() -- function st_3dmaxdistance() -- function st_3dperimeter() -- function st_3dshortestline() -- function st_accum() -- function st_addband() -- function st_addmeasure() -- function st_addpoint() -- function st_affine() -- function st_approxcount() -- function st_approxhistogram() -- function st_approxquantile() -- function st_approxsummarystats() -- function st_area() -- function st_area2d() -- function st_asbinary() -- function st_asencodedpolyline() -- function st_asewkb() -- function st_asewkt() -- function st_asgdalraster() -- function st_asgeobuf() -- function st_asgeojson() -- function st_asgml() -- function st_ashexewkb() -- function st_asjpeg() -- function st_askml() -- function st_aslatlontext() -- function st_asmvt() -- function st_asmvtgeom() -- function st_aspect() -- function st_aspng() -- function st_asraster() -- function st_assvg() -- function st_astext() -- function st_astiff() -- function st_astwkb() -- function st_asx3d() -- function st_azimuth() -- function st_band() -- function st_bandisnodata() -- function st_bandmetadata() -- function st_bandnodatavalue() -- function st_bandpath() -- function st_bandpixeltype() -- function st_bdmpolyfromtext() -- function st_bdpolyfromtext() -- function st_boundary() -- function st_boundingdiagonal() -- function st_box2dfromgeohash() -- function st_buffer() -- function st_buildarea() -- function st_centroid() -- function st_cleangeometry() -- function st_clip() -- function st_clipbybox2d() -- function st_closestpoint() -- function st_closestpointofapproach() -- function st_clusterdbscan() -- function st_clusterintersecting() -- function st_clusterkmeans() -- function st_clusterwithin() -- function st_collect() -- function st_collectionextract() -- function st_collectionhomogenize() -- function st_colormap() -- function st_combine_bbox() -- function st_combinebbox() -- function st_concavehull() -- function st_contains() -- function st_containsproperly() -- function st_convexhull() -- function st_coorddim() -- function st_count() -- function st_countagg() -- function st_coveredby() -- function st_covers() -- function st_cpawithin() -- function st_createoverview() -- function st_crosses() -- function st_curvetoline() -- function st_delaunaytriangles() -- function st_dfullywithin() -- function st_difference() -- function st_dimension() -- function st_disjoint() -- function st_distance() -- function st_distance_sphere() -- function st_distance_spheroid() -- function st_distancecpa() -- function st_distancesphere() -- function st_distancespheroid() -- function st_distinct4ma() -- function st_dump() -- function st_dumpaspolygons() -- function st_dumppoints() -- function st_dumprings() -- function st_dumpvalues() -- function st_dwithin() -- function st_endpoint() -- function st_envelope() -- function st_equals() -- function st_estimated_extent() -- function st_estimatedextent() -- function st_expand() -- function st_extent() -- function st_exteriorring() -- function st_find_extent() -- function st_findextent() -- function st_flipcoordinates() -- function st_force2d() -- function st_force3d() -- function st_force3dm() -- function st_force3dz() -- function st_force4d() -- function st_force_2d() -- function st_force_3d() -- function st_force_3dm() -- function st_force_3dz() -- function st_force_4d() -- function st_force_collection() -- function st_forcecollection() -- function st_forcecurve() -- function st_forcepolygonccw() -- function st_forcepolygoncw() -- function st_forcerhr() -- function st_forcesfs() -- function st_frechetdistance() -- function st_fromgdalraster() -- function st_gdaldrivers() -- function st_generatepoints() -- function st_geogfromtext() -- function st_geogfromwkb() -- function st_geographyfromtext() -- function st_geohash() -- function st_geomcollfromtext() -- function st_geomcollfromwkb() -- function st_geometricmedian() -- function st_geometryfromtext() -- function st_geometryn() -- function st_geometrytype() -- function st_geomfromewkb() -- function st_geomfromewkt() -- function st_geomfromgeohash() -- function st_geomfromgeojson() -- function st_geomfromgml() -- function st_geomfromkml() -- function st_geomfromtext() -- function st_geomfromtwkb() -- function st_geomfromwkb() -- function st_georeference() -- function st_geotransform() -- function st_gmltosql() -- function st_hasarc() -- function st_hasnoband() -- function st_hausdorffdistance() -- function st_height() -- function st_hillshade() -- function st_histogram() -- function st_interiorringn() -- function st_interpolatepoint() -- function st_intersection() -- function st_intersects() -- function st_invdistweight4ma() -- function st_isclosed() -- function st_iscollection() -- function st_iscoveragetile() -- function st_isempty() -- function st_ispolygonccw() -- function st_ispolygoncw() -- function st_isring() -- function st_issimple() -- function st_isvalid() -- function st_isvaliddetail() -- function st_isvalidreason() -- function st_isvalidtrajectory() -- function st_length() -- function st_length2d() -- function st_length2d_spheroid() -- function st_length2dspheroid() -- function st_length_spheroid() -- function st_lengthspheroid() -- function st_line_interpolate_point() -- function st_line_locate_point() -- function st_line_substring() -- function st_linecrossingdirection() -- function st_linefromencodedpolyline() -- function st_linefrommultipoint() -- function st_linefromtext() -- function st_linefromwkb() -- function st_lineinterpolatepoint() -- function st_linelocatepoint() -- function st_linemerge() -- function st_linestringfromwkb() -- function st_linesubstring() -- function st_linetocurve() -- function st_locate_along_measure() -- function st_locate_between_measures() -- function st_locatealong() -- function st_locatebetween() -- function st_locatebetweenelevations() -- function st_longestline() -- function st_m() -- function st_makebox2d() -- function st_makeemptycoverage() -- function st_makeemptyraster() -- function st_makeenvelope() -- function st_makeline() -- function st_makepoint() -- function st_makepointm() -- function st_makepolygon() -- function st_makevalid() -- function st_mapalgebra() -- function st_mapalgebraexpr() -- function st_mapalgebrafct() -- function st_mapalgebrafctngb() -- function st_max4ma() -- function st_maxdistance() -- function st_mean4ma() -- function st_mem_size() -- function st_memcollect() -- function st_memsize() -- function st_memunion() -- function st_metadata() -- function st_min4ma() -- function st_minconvexhull() -- function st_mindist4ma() -- function st_minimumboundingcircle() -- function st_minimumboundingradius() -- function st_minimumclearance() -- function st_minimumclearanceline() -- function st_minpossiblevalue() -- function st_mlinefromtext() -- function st_mlinefromwkb() -- function st_mpointfromtext() -- function st_mpointfromwkb() -- function st_mpolyfromtext() -- function st_mpolyfromwkb() -- function st_multi() -- function st_multilinefromwkb() -- function st_multilinestringfromtext() -- function st_multipointfromtext() -- function st_multipointfromwkb() -- function st_multipolyfromwkb() -- function st_multipolygonfromtext() -- function st_ndims() -- function st_nearestvalue() -- function st_neighborhood() -- function st_node() -- function st_normalize() -- function st_notsamealignmentreason() -- function st_npoints() -- function st_nrings() -- function st_numbands() -- function st_numgeometries() -- function st_numinteriorring() -- function st_numinteriorrings() -- function st_numpatches() -- function st_numpoints() -- function st_offsetcurve() -- function st_orderingequals() -- function st_overlaps() -- function st_patchn() -- function st_perimeter() -- function st_perimeter2d() -- function st_pixelascentroid() -- function st_pixelascentroids() -- function st_pixelaspoint() -- function st_pixelaspoints() -- function st_pixelaspolygon() -- function st_pixelaspolygons() -- function st_pixelheight() -- function st_pixelofvalue() -- function st_pixelwidth() -- function st_point() -- function st_point_inside_circle() -- function st_pointfromgeohash() -- function st_pointfromtext() -- function st_pointfromwkb() -- function st_pointinsidecircle() -- function st_pointn() -- function st_pointonsurface() -- function st_points() -- function st_polyfromtext() -- function st_polyfromwkb() -- function st_polygon() -- function st_polygonfromtext() -- function st_polygonfromwkb() -- function st_polygonize() -- function st_project() -- function st_quantile() -- function st_range4ma() -- function st_rastertoworldcoord() -- function st_rastertoworldcoordx() -- function st_rastertoworldcoordy() -- function st_reclass() -- function st_relate() -- function st_relatematch() -- function st_removepoint() -- function st_removerepeatedpoints() -- function st_resample() -- function st_rescale() -- function st_resize() -- function st_reskew() -- function st_retile() -- function st_reverse() -- function st_rotate() -- function st_rotatex() -- function st_rotatey() -- function st_rotatez() -- function st_rotation() -- function st_roughness() -- function st_samealignment() -- function st_scale() -- function st_scalex() -- function st_scaley() -- function st_segmentize() -- function st_setbandisnodata() -- function st_setbandnodatavalue() -- function st_seteffectivearea() -- function st_setgeoreference() -- function st_setgeotransform() -- function st_setpoint() -- function st_setrotation() -- function st_setscale() -- function st_setskew() -- function st_setsrid() -- function st_setupperleft() -- function st_setvalue() -- function st_setvalues() -- function st_sharedpaths() -- function st_shift_longitude() -- function st_shiftlongitude() -- function st_shortestline() -- function st_simplify() -- function st_simplifypreservetopology() -- function st_simplifyvw() -- function st_skewx() -- function st_skewy() -- function st_slope() -- function st_snap() -- function st_snaptogrid() -- function st_split() -- function st_srid() -- function st_startpoint() -- function st_stddev4ma() -- function st_subdivide() -- function st_sum4ma() -- function st_summary() -- function st_summarystats() -- function st_summarystatsagg() -- function st_swapordinates() -- function st_symdifference() -- function st_symmetricdifference() -- function st_tile() -- function st_touches() -- function st_tpi() -- function st_transform() -- function st_translate() -- function st_transscale() -- function st_tri() -- function st_unaryunion() -- function st_union() -- function st_upperleftx() -- function st_upperlefty() -- function st_value() -- function st_valuecount() -- function st_valuepercent() -- function st_voronoilines() -- function st_voronoipolygons() -- function st_width() -- function st_within() -- function st_wkbtosql() -- function st_wkttosql() -- function st_worldtorastercoord() -- function st_worldtorastercoordx() -- function st_worldtorastercoordy() -- function st_wrapx() -- function st_x() -- function st_xmax() -- function st_xmin() -- function st_y() -- function st_ymax() -- function st_ymin() -- function st_z() -- function st_zmax() -- function st_zmflag() -- function st_zmin() -- function text() -- function unlockrows() -- function updategeometrysrid() -- function updaterastersrid() -- function spatial_ref_sys -- table addbandarg -- type agg_count -- type agg_samealignment -- type box2d -- type box2df -- type box3d -- type geography -- type geometry -- type geometry_dump -- type geomval -- type gidx -- type pgis_abs -- type rastbandarg -- type raster -- type reclassarg -- type spheroid -- type summarystats -- type unionarg -- type valid_detail -- type geography_columns -- view geometry_columns -- view raster_columns -- view raster_overviews -- view -- Extension: unaccent unaccent() -- function unaccent_init() -- function unaccent_lexize() -- function -- Extension: btree_gin gin_btree_consistent() -- function gin_compare_prefix_anyenum() -- function gin_compare_prefix_bit() -- function gin_compare_prefix_bytea() -- function gin_compare_prefix_char() -- function gin_compare_prefix_cidr() -- function gin_compare_prefix_date() -- function gin_compare_prefix_float4() -- function gin_compare_prefix_float8() -- function gin_compare_prefix_inet() -- function gin_compare_prefix_int2() -- function gin_compare_prefix_int4() -- function gin_compare_prefix_int8() -- function gin_compare_prefix_interval() -- function gin_compare_prefix_macaddr() -- function gin_compare_prefix_macaddr8() -- function gin_compare_prefix_money() -- function gin_compare_prefix_numeric() -- function gin_compare_prefix_oid() -- function gin_compare_prefix_text() -- function gin_compare_prefix_time() -- function gin_compare_prefix_timestamp() -- function gin_compare_prefix_timestamptz() -- function gin_compare_prefix_timetz() -- function gin_compare_prefix_varbit() -- function gin_enum_cmp() -- function gin_extract_query_anyenum() -- function gin_extract_query_bit() -- function gin_extract_query_bytea() -- function gin_extract_query_char() -- function gin_extract_query_cidr() -- function gin_extract_query_date() -- function gin_extract_query_float4() -- function gin_extract_query_float8() -- function gin_extract_query_inet() -- function gin_extract_query_int2() -- function gin_extract_query_int4() -- function gin_extract_query_int8() -- function gin_extract_query_interval() -- function gin_extract_query_macaddr() -- function gin_extract_query_macaddr8() -- function gin_extract_query_money() -- function gin_extract_query_numeric() -- function gin_extract_query_oid() -- function gin_extract_query_text() -- function gin_extract_query_time() -- function gin_extract_query_timestamp() -- function gin_extract_query_timestamptz() -- function gin_extract_query_timetz() -- function gin_extract_query_varbit() -- function gin_extract_value_anyenum() -- function gin_extract_value_bit() -- function gin_extract_value_bytea() -- function gin_extract_value_char() -- function gin_extract_value_cidr() -- function gin_extract_value_date() -- function gin_extract_value_float4() -- function gin_extract_value_float8() -- function gin_extract_value_inet() -- function gin_extract_value_int2() -- function gin_extract_value_int4() -- function gin_extract_value_int8() -- function gin_extract_value_interval() -- function gin_extract_value_macaddr() -- function gin_extract_value_macaddr8() -- function gin_extract_value_money() -- function gin_extract_value_numeric() -- function gin_extract_value_oid() -- function gin_extract_value_text() -- function gin_extract_value_time() -- function gin_extract_value_timestamp() -- function gin_extract_value_timestamptz() -- function gin_extract_value_timetz() -- function gin_extract_value_varbit() -- function gin_numeric_cmp() -- function -- Extension: plpython3u plpython3_call_handler() -- function plpython3_inline_handler() -- function plpython3_validator() -- function -- Extension: ltree index() -- function lca() -- function lquery_in() -- function lquery_out() -- function lt_q_regex() -- function lt_q_rregex() -- function ltq_regex() -- function ltq_rregex() -- function ltree2text() -- function ltree_addltree() -- function ltree_addtext() -- function ltree_cmp() -- function ltree_compress() -- function ltree_consistent() -- function ltree_decompress() -- function ltree_eq() -- function ltree_ge() -- function ltree_gist_in() -- function ltree_gist_out() -- function ltree_gt() -- function ltree_in() -- function ltree_isparent() -- function ltree_le() -- function ltree_lt() -- function ltree_ne() -- function ltree_out() -- function ltree_penalty() -- function ltree_picksplit() -- function ltree_risparent() -- function ltree_same() -- function ltree_textadd() -- function ltree_union() -- function ltreeparentsel() -- function ltxtq_exec() -- function ltxtq_in() -- function ltxtq_out() -- function ltxtq_rexec() -- function nlevel() -- function subltree() -- function subpath() -- function text2ltree() -- function lquery -- type ltree -- type ltree_gist -- type ltxtquery -- type -- Extension: tsm_system_rows system_rows() -- function -- Extension: adminpack pg_file_length() -- function pg_file_read() -- function pg_file_rename() -- function pg_file_unlink() -- function pg_file_write() -- function pg_logdir_ls() -- function pg_logfile_rotate() -- function -- Extension: dict_xsyn dxsyn_init() -- function dxsyn_lexize() -- function -- Extension: address_standardizer parse_address() -- function standardize_address() -- function stdaddr -- type -- Extension: hstore_plperlu hstore_to_plperlu() -- function plperlu_to_hstore() -- function -- Extension: xml2 xml_encode_special_chars() -- function xml_valid() -- function xpath_bool() -- function xpath_list() -- function xpath_nodeset() -- function xpath_number() -- function xpath_string() -- function xpath_table() -- function xslt_process() -- function -- Extension: hstore akeys() -- function avals() -- function defined() -- function delete() -- function each() -- function exist() -- function exists_all() -- function exists_any() -- function fetchval() -- function ghstore_compress() -- function ghstore_consistent() -- function ghstore_decompress() -- function ghstore_in() -- function ghstore_out() -- function ghstore_penalty() -- function ghstore_picksplit() -- function ghstore_same() -- function ghstore_union() -- function gin_consistent_hstore() -- function gin_extract_hstore() -- function gin_extract_hstore_query() -- function hs_concat() -- function hs_contained() -- function hs_contains() -- function hstore() -- function hstore_cmp() -- function hstore_eq() -- function hstore_ge() -- function hstore_gt() -- function hstore_hash() -- function hstore_in() -- function hstore_le() -- function hstore_lt() -- function hstore_ne() -- function hstore_out() -- function hstore_recv() -- function hstore_send() -- function hstore_to_array() -- function hstore_to_json() -- function hstore_to_json_loose() -- function hstore_to_jsonb() -- function hstore_to_jsonb_loose() -- function hstore_to_matrix() -- function hstore_version_diag() -- function isdefined() -- function isexists() -- function populate_record() -- function skeys() -- function slice() -- function slice_array() -- function svals() -- function tconvert() -- function ghstore -- type hstore -- type -- Extension: pg_visibility pg_check_frozen() -- function pg_check_visible() -- function pg_truncate_visibility_map() -- function pg_visibility() -- function pg_visibility_map() -- function pg_visibility_map_summary() -- function -- Extension: cube cube() -- function cube_cmp() -- function cube_contained() -- function cube_contains() -- function cube_coord() -- function cube_coord_llur() -- function cube_dim() -- function cube_distance() -- function cube_enlarge() -- function cube_eq() -- function cube_ge() -- function cube_gt() -- function cube_in() -- function cube_inter() -- function cube_is_point() -- function cube_le() -- function cube_ll_coord() -- function cube_lt() -- function cube_ne() -- function cube_out() -- function cube_overlap() -- function cube_size() -- function cube_subset() -- function cube_union() -- function cube_ur_coord() -- function distance_chebyshev() -- function distance_taxicab() -- function g_cube_compress() -- function g_cube_consistent() -- function g_cube_decompress() -- function g_cube_distance() -- function g_cube_penalty() -- function g_cube_picksplit() -- function g_cube_same() -- function g_cube_union() -- function cube -- type -- Extension: postgis_tiger_geocoder count_words() -- function create_census_base_tables() -- function cull_null() -- function diff_zip() -- function drop_dupe_featnames_generate_script() -- function drop_indexes_generate_script() -- function drop_nation_tables_generate_script() -- function drop_state_tables_generate_script() -- function end_soundex() -- function geocode() -- function geocode_address() -- function geocode_intersection() -- function geocode_location() -- function get_geocode_setting() -- function get_last_words() -- function get_tract() -- function greatest_hn() -- function includes_address() -- function install_geocode_settings() -- function install_missing_indexes() -- function install_pagc_tables() -- function interpolate_from_address() -- function is_pretype() -- function least_hn() -- function levenshtein_ignore_case() -- function loader_generate_census_script() -- function loader_generate_nation_script() -- function loader_generate_script() -- function loader_load_staged_data() -- function loader_macro_replace() -- function location_extract() -- function location_extract_countysub_exact() -- function location_extract_countysub_fuzzy() -- function location_extract_place_exact() -- function location_extract_place_fuzzy() -- function missing_indexes_generate_script() -- function normalize_address() -- function nullable_levenshtein() -- function numeric_streets_equal() -- function pagc_normalize_address() -- function pprint_addy() -- function rate_attributes() -- function reverse_geocode() -- function set_geocode_setting() -- function setsearchpathforinstall() -- function state_extract() -- function topology_load_tiger() -- function utmzone() -- function zip_range() -- function addr -- table addrfeat -- table bg -- table county -- table county_lookup -- table countysub_lookup -- table cousub -- table direction_lookup -- table edges -- table faces -- table featnames -- table geocode_settings -- table geocode_settings_default -- table loader_lookuptables -- table loader_platform -- table loader_variables -- table pagc_gaz -- table pagc_lex -- table pagc_rules -- table place -- table place_lookup -- table secondary_unit_lookup -- table state -- table state_lookup -- table street_type_lookup -- table tabblock -- table tract -- table zcta5 -- table zip_lookup -- table zip_lookup_all -- table zip_lookup_base -- table zip_state -- table zip_state_loc -- table norm_addy -- type -- Extension: seg gseg_compress() -- function gseg_consistent() -- function gseg_decompress() -- function gseg_penalty() -- function gseg_picksplit() -- function gseg_same() -- function gseg_union() -- function seg_center() -- function seg_cmp() -- function seg_contained() -- function seg_contains() -- function seg_different() -- function seg_ge() -- function seg_gt() -- function seg_in() -- function seg_inter() -- function seg_le() -- function seg_left() -- function seg_lower() -- function seg_lt() -- function seg_out() -- function seg_over_left() -- function seg_over_right() -- function seg_overlap() -- function seg_right() -- function seg_same() -- function seg_size() -- function seg_union() -- function seg_upper() -- function seg -- type -- Extension: intagg int_agg_final_array() -- function int_agg_state() -- function int_array_aggregate() -- function int_array_enum() -- function -- Extension: tcn triggered_change_notification() -- function -- Extension: isn btean13cmp() -- function btisbn13cmp() -- function btisbncmp() -- function btismn13cmp() -- function btismncmp() -- function btissn13cmp() -- function btissncmp() -- function btupccmp() -- function ean13_in() -- function ean13_out() -- function hashean13() -- function hashisbn() -- function hashisbn13() -- function hashismn() -- function hashismn13() -- function hashissn() -- function hashissn13() -- function hashupc() -- function is_valid() -- function isbn() -- function isbn13() -- function isbn13_in() -- function isbn_in() -- function ismn() -- function ismn13() -- function ismn13_in() -- function ismn_in() -- function isn_out() -- function isn_weak() -- function isneq() -- function isnge() -- function isngt() -- function isnle() -- function isnlt() -- function isnne() -- function issn() -- function issn13() -- function issn13_in() -- function issn_in() -- function make_valid() -- function upc() -- function upc_in() -- function ean13 -- type isbn -- type isbn13 -- type ismn -- type ismn13 -- type issn -- type issn13 -- type upc -- type -- Extension: tsm_system_time system_time() -- function -- Extension: lo lo_manage() -- function lo_oid() -- function lo -- type -- Extension: pgrowlocks pgrowlocks() -- function -- Extension: sslinfo ssl_cipher() -- function ssl_client_cert_present() -- function ssl_client_dn() -- function ssl_client_dn_field() -- function ssl_client_serial() -- function ssl_extension_info() -- function ssl_is_used() -- function ssl_issuer_dn() -- function ssl_issuer_field() -- function ssl_version() -- function -- Extension: pgstattuple pg_relpages() -- function pgstatginindex() -- function pgstathashindex() -- function pgstatindex() -- function pgstattuple() -- function pgstattuple_approx() -- function -- Extension: chkpass chkpass_in() -- function chkpass_out() -- function eq() -- function ne() -- function raw() -- function chkpass -- type -- Extension: autoinc autoinc() -- function -- Extension: address_standardizer_data_us us_gaz -- table us_lex -- table us_rules -- table -- Extension: hstore_plpython3u hstore_to_plpython3() -- function plpython3_to_hstore() -- function -- Extension: postgis_topology addedge() -- function addface() -- function addnode() -- function addtopogeometrycolumn() -- function addtosearchpath() -- function asgml() -- function astopojson() -- function cleartopogeom() -- function copytopology() -- function createtopogeom() -- function createtopology() -- function droptopogeometrycolumn() -- function droptopology() -- function equals() -- function geometry() -- function geometrytype() -- function getedgebypoint() -- function getfacebypoint() -- function getnodebypoint() -- function getnodeedges() -- function getringedges() -- function gettopogeomelementarray() -- function gettopogeomelements() -- function gettopologyid() -- function gettopologyname() -- function gettopologysrid() -- function intersects() -- function layertrigger() -- function polygonize() -- function populate_topology_layer() -- function postgis_topology_scripts_installed() -- function relationtrigger() -- function st_addedgemodface() -- function st_addedgenewfaces() -- function st_addisoedge() -- function st_addisonode() -- function st_changeedgegeom() -- function st_createtopogeo() -- function st_geometrytype() -- function st_getfaceedges() -- function st_getfacegeometry() -- function st_inittopogeo() -- function st_modedgeheal() -- function st_modedgesplit() -- function st_moveisonode() -- function st_newedgeheal() -- function st_newedgessplit() -- function st_remedgemodface() -- function st_remedgenewface() -- function st_remisonode() -- function st_removeisoedge() -- function st_removeisonode() -- function st_simplify() -- function topoelementarray_agg() -- function topoelementarray_append() -- function topogeo_addgeometry() -- function topogeo_addlinestring() -- function topogeo_addpoint() -- function topogeo_addpolygon() -- function topogeom_addelement() -- function topogeom_remelement() -- function topologysummary() -- function totopogeom() -- function validatetopology() -- function layer -- table topology -- table getfaceedges_returntype -- type topoelement -- type topoelementarray -- type topogeometry -- type validatetopology_returntype -- type -- Extension: pg_freespacemap pg_freespace() -- function -- Extension: file_fdw file_fdw_handler() -- function file_fdw_validator() -- function -- Extension: pg_buffercache pg_buffercache_pages() -- function pg_buffercache -- view -- Extension: dblink dblink() -- function dblink_build_sql_delete() -- function dblink_build_sql_insert() -- function dblink_build_sql_update() -- function dblink_cancel_query() -- function dblink_close() -- function dblink_connect() -- function dblink_connect_u() -- function dblink_current_query() -- function dblink_disconnect() -- function dblink_error_message() -- function dblink_exec() -- function dblink_fdw_validator() -- function dblink_fetch() -- function dblink_get_connections() -- function dblink_get_notify() -- function dblink_get_pkey() -- function dblink_get_result() -- function dblink_is_busy() -- function dblink_open() -- function dblink_send_query() -- function dblink_pkey_results -- type -- Extension: pg_stat_statements pg_stat_statements() -- function pg_stat_statements_reset() -- function pg_stat_statements -- view -- Extension: insert_username insert_username() -- function -- Extension: pg_prewarm pg_prewarm() -- function -- Extension: pgtap is() -- function add_result() -- function alike() -- function any_column_privs_are() -- function bag_eq() -- function bag_has() -- function bag_hasnt() -- function bag_ne() -- function can() -- function cast_context_is() -- function casts_are() -- function check_test() -- function cmp_ok() -- function col_default_is() -- function col_has_check() -- function col_has_default() -- function col_hasnt_default() -- function col_is_fk() -- function col_is_null() -- function col_is_pk() -- function col_is_unique() -- function col_isnt_fk() -- function col_isnt_pk() -- function col_not_null() -- function col_type_is() -- function collect_tap() -- function column_privs_are() -- function columns_are() -- function composite_owner_is() -- function database_privs_are() -- function db_owner_is() -- function diag() -- function diag_test_name() -- function display_oper() -- function do_tap() -- function doesnt_imatch() -- function doesnt_match() -- function domain_type_is() -- function domain_type_isnt() -- function domains_are() -- function enum_has_labels() -- function enums_are() -- function extensions_are() -- function fail() -- function fdw_privs_are() -- function findfuncs() -- function finish() -- function fk_ok() -- function foreign_table_owner_is() -- function foreign_tables_are() -- function function_lang_is() -- function function_owner_is() -- function function_privs_are() -- function function_returns() -- function functions_are() -- function groups_are() -- function has_cast() -- function has_check() -- function has_column() -- function has_composite() -- function has_domain() -- function has_enum() -- function has_extension() -- function has_fk() -- function has_foreign_table() -- function has_function() -- function has_group() -- function has_index() -- function has_language() -- function has_leftop() -- function has_materialized_view() -- function has_opclass() -- function has_operator() -- function has_pk() -- function has_relation() -- function has_rightop() -- function has_role() -- function has_rule() -- function has_schema() -- function has_sequence() -- function has_table() -- function has_tablespace() -- function has_trigger() -- function has_type() -- function has_unique() -- function has_user() -- function has_view() -- function hasnt_cast() -- function hasnt_column() -- function hasnt_composite() -- function hasnt_domain() -- function hasnt_enum() -- function hasnt_extension() -- function hasnt_fk() -- function hasnt_foreign_table() -- function hasnt_function() -- function hasnt_group() -- function hasnt_index() -- function hasnt_language() -- function hasnt_materialized_view() -- function hasnt_opclass() -- function hasnt_pk() -- function hasnt_relation() -- function hasnt_role() -- function hasnt_rule() -- function hasnt_schema() -- function hasnt_sequence() -- function hasnt_table() -- function hasnt_tablespace() -- function hasnt_trigger() -- function hasnt_type() -- function hasnt_user() -- function hasnt_view() -- function ialike() -- function imatches() -- function in_todo() -- function index_is_primary() -- function index_is_type() -- function index_is_unique() -- function index_owner_is() -- function indexes_are() -- function is_aggregate() -- function is_clustered() -- function is_definer() -- function is_empty() -- function is_indexed() -- function is_member_of() -- function is_strict() -- function is_superuser() -- function isa_ok() -- function isnt() -- function isnt_aggregate() -- function isnt_definer() -- function isnt_empty() -- function isnt_strict() -- function isnt_superuser() -- function language_is_trusted() -- function language_owner_is() -- function language_privs_are() -- function languages_are() -- function lives_ok() -- function matches() -- function materialized_view_owner_is() -- function materialized_views_are() -- function no_plan() -- function num_failed() -- function ok() -- function opclass_owner_is() -- function opclasses_are() -- function operators_are() -- function os_name() -- function pass() -- function performs_ok() -- function performs_within() -- function pg_version() -- function pg_version_num() -- function pgtap_version() -- function plan() -- function relation_owner_is() -- function results_eq() -- function results_ne() -- function roles_are() -- function row_eq() -- function rule_is_instead() -- function rule_is_on() -- function rules_are() -- function runtests() -- function schema_owner_is() -- function schema_privs_are() -- function schemas_are() -- function sequence_owner_is() -- function sequence_privs_are() -- function sequences_are() -- function server_privs_are() -- function set_eq() -- function set_has() -- function set_hasnt() -- function set_ne() -- function skip() -- function table_owner_is() -- function table_privs_are() -- function tables_are() -- function tablespace_owner_is() -- function tablespace_privs_are() -- function tablespaces_are() -- function throws_ilike() -- function throws_imatching() -- function throws_like() -- function throws_matching() -- function throws_ok() -- function todo() -- function todo_end() -- function todo_start() -- function trigger_is() -- function triggers_are() -- function type_owner_is() -- function types_are() -- function unalike() -- function unialike() -- function users_are() -- function view_owner_is() -- function views_are() -- function volatility_is() -- function pg_all_foreign_keys -- view tap_funky -- view -- Extension: earthdistance earth() -- function earth_box() -- function earth_distance() -- function gc_to_sec() -- function geo_distance() -- function latitude() -- function ll_to_earth() -- function longitude() -- function sec_to_gc() -- function earth -- type -- Extension: uuid-ossp uuid_generate_v1() -- function uuid_generate_v1mc() -- function uuid_generate_v3() -- function uuid_generate_v4() -- function uuid_generate_v5() -- function uuid_nil() -- function uuid_ns_dns() -- function uuid_ns_oid() -- function uuid_ns_url() -- function uuid_ns_x500() -- function -- Extension: plperlu plperlu_call_handler() -- function plperlu_inline_handler() -- function plperlu_validator() -- function -- Extension: intarray boolop() -- function bqarr_in() -- function bqarr_out() -- function g_int_compress() -- function g_int_consistent() -- function g_int_decompress() -- function g_int_penalty() -- function g_int_picksplit() -- function g_int_same() -- function g_int_union() -- function g_intbig_compress() -- function g_intbig_consistent() -- function g_intbig_decompress() -- function g_intbig_penalty() -- function g_intbig_picksplit() -- function g_intbig_same() -- function g_intbig_union() -- function ginint4_consistent() -- function ginint4_queryextract() -- function icount() -- function idx() -- function intarray_del_elem() -- function intarray_push_array() -- function intarray_push_elem() -- function intset() -- function intset_subtract() -- function intset_union_elem() -- function querytree() -- function rboolop() -- function sort() -- function sort_asc() -- function sort_desc() -- function subarray() -- function uniq() -- function intbig_gkey -- type query_int -- type -- Extension: pg_trgm gin_extract_query_trgm() -- function gin_extract_value_trgm() -- function gin_trgm_consistent() -- function gin_trgm_triconsistent() -- function gtrgm_compress() -- function gtrgm_consistent() -- function gtrgm_decompress() -- function gtrgm_distance() -- function gtrgm_in() -- function gtrgm_out() -- function gtrgm_penalty() -- function gtrgm_picksplit() -- function gtrgm_same() -- function gtrgm_union() -- function set_limit() -- function show_limit() -- function show_trgm() -- function similarity() -- function similarity_dist() -- function similarity_op() -- function word_similarity() -- function word_similarity_commutator_op() -- function word_similarity_dist_commutator_op() -- function word_similarity_dist_op() -- function word_similarity_op() -- function gtrgm -- type -- Extension: dict_int dintdict_init() -- function dintdict_lexize() -- function -- Extension: amcheck bt_index_check() -- function bt_index_parent_check() -- function -- Extension: btree_gist cash_dist() -- function date_dist() -- function float4_dist() -- function float8_dist() -- function gbt_bit_compress() -- function gbt_bit_consistent() -- function gbt_bit_penalty() -- function gbt_bit_picksplit() -- function gbt_bit_same() -- function gbt_bit_union() -- function gbt_bpchar_compress() -- function gbt_bpchar_consistent() -- function gbt_bytea_compress() -- function gbt_bytea_consistent() -- function gbt_bytea_penalty() -- function gbt_bytea_picksplit() -- function gbt_bytea_same() -- function gbt_bytea_union() -- function gbt_cash_compress() -- function gbt_cash_consistent() -- function gbt_cash_distance() -- function gbt_cash_fetch() -- function gbt_cash_penalty() -- function gbt_cash_picksplit() -- function gbt_cash_same() -- function gbt_cash_union() -- function gbt_date_compress() -- function gbt_date_consistent() -- function gbt_date_distance() -- function gbt_date_fetch() -- function gbt_date_penalty() -- function gbt_date_picksplit() -- function gbt_date_same() -- function gbt_date_union() -- function gbt_decompress() -- function gbt_enum_compress() -- function gbt_enum_consistent() -- function gbt_enum_fetch() -- function gbt_enum_penalty() -- function gbt_enum_picksplit() -- function gbt_enum_same() -- function gbt_enum_union() -- function gbt_float4_compress() -- function gbt_float4_consistent() -- function gbt_float4_distance() -- function gbt_float4_fetch() -- function gbt_float4_penalty() -- function gbt_float4_picksplit() -- function gbt_float4_same() -- function gbt_float4_union() -- function gbt_float8_compress() -- function gbt_float8_consistent() -- function gbt_float8_distance() -- function gbt_float8_fetch() -- function gbt_float8_penalty() -- function gbt_float8_picksplit() -- function gbt_float8_same() -- function gbt_float8_union() -- function gbt_inet_compress() -- function gbt_inet_consistent() -- function gbt_inet_penalty() -- function gbt_inet_picksplit() -- function gbt_inet_same() -- function gbt_inet_union() -- function gbt_int2_compress() -- function gbt_int2_consistent() -- function gbt_int2_distance() -- function gbt_int2_fetch() -- function gbt_int2_penalty() -- function gbt_int2_picksplit() -- function gbt_int2_same() -- function gbt_int2_union() -- function gbt_int4_compress() -- function gbt_int4_consistent() -- function gbt_int4_distance() -- function gbt_int4_fetch() -- function gbt_int4_penalty() -- function gbt_int4_picksplit() -- function gbt_int4_same() -- function gbt_int4_union() -- function gbt_int8_compress() -- function gbt_int8_consistent() -- function gbt_int8_distance() -- function gbt_int8_fetch() -- function gbt_int8_penalty() -- function gbt_int8_picksplit() -- function gbt_int8_same() -- function gbt_int8_union() -- function gbt_intv_compress() -- function gbt_intv_consistent() -- function gbt_intv_decompress() -- function gbt_intv_distance() -- function gbt_intv_fetch() -- function gbt_intv_penalty() -- function gbt_intv_picksplit() -- function gbt_intv_same() -- function gbt_intv_union() -- function gbt_macad8_compress() -- function gbt_macad8_consistent() -- function gbt_macad8_fetch() -- function gbt_macad8_penalty() -- function gbt_macad8_picksplit() -- function gbt_macad8_same() -- function gbt_macad8_union() -- function gbt_macad_compress() -- function gbt_macad_consistent() -- function gbt_macad_fetch() -- function gbt_macad_penalty() -- function gbt_macad_picksplit() -- function gbt_macad_same() -- function gbt_macad_union() -- function gbt_numeric_compress() -- function gbt_numeric_consistent() -- function gbt_numeric_penalty() -- function gbt_numeric_picksplit() -- function gbt_numeric_same() -- function gbt_numeric_union() -- function gbt_oid_compress() -- function gbt_oid_consistent() -- function gbt_oid_distance() -- function gbt_oid_fetch() -- function gbt_oid_penalty() -- function gbt_oid_picksplit() -- function gbt_oid_same() -- function gbt_oid_union() -- function gbt_text_compress() -- function gbt_text_consistent() -- function gbt_text_penalty() -- function gbt_text_picksplit() -- function gbt_text_same() -- function gbt_text_union() -- function gbt_time_compress() -- function gbt_time_consistent() -- function gbt_time_distance() -- function gbt_time_fetch() -- function gbt_time_penalty() -- function gbt_time_picksplit() -- function gbt_time_same() -- function gbt_time_union() -- function gbt_timetz_compress() -- function gbt_timetz_consistent() -- function gbt_ts_compress() -- function gbt_ts_consistent() -- function gbt_ts_distance() -- function gbt_ts_fetch() -- function gbt_ts_penalty() -- function gbt_ts_picksplit() -- function gbt_ts_same() -- function gbt_ts_union() -- function gbt_tstz_compress() -- function gbt_tstz_consistent() -- function gbt_tstz_distance() -- function gbt_uuid_compress() -- function gbt_uuid_consistent() -- function gbt_uuid_fetch() -- function gbt_uuid_penalty() -- function gbt_uuid_picksplit() -- function gbt_uuid_same() -- function gbt_uuid_union() -- function gbt_var_decompress() -- function gbt_var_fetch() -- function gbtreekey16_in() -- function gbtreekey16_out() -- function gbtreekey32_in() -- function gbtreekey32_out() -- function gbtreekey4_in() -- function gbtreekey4_out() -- function gbtreekey8_in() -- function gbtreekey8_out() -- function gbtreekey_var_in() -- function gbtreekey_var_out() -- function int2_dist() -- function int4_dist() -- function int8_dist() -- function interval_dist() -- function oid_dist() -- function time_dist() -- function ts_dist() -- function tstz_dist() -- function gbtreekey16 -- type gbtreekey32 -- type gbtreekey4 -- type gbtreekey8 -- type gbtreekey_var -- type -- Extension: pageinspect brin_metapage_info() -- function brin_page_items() -- function brin_page_type() -- function brin_revmap_data() -- function bt_metap() -- function bt_page_items() -- function bt_page_stats() -- function fsm_page_contents() -- function get_raw_page() -- function gin_leafpage_items() -- function gin_metapage_info() -- function gin_page_opaque_info() -- function hash_bitmap_info() -- function hash_metapage_info() -- function hash_page_items() -- function hash_page_stats() -- function hash_page_type() -- function heap_page_item_attrs() -- function heap_page_items() -- function page_checksum() -- function page_header() -- function tuple_data_split() -- function -- Extension: pltclu pltclu_call_handler() -- function -- Extension: hstore_plperl hstore_to_plperl() -- function plperl_to_hstore() -- function -- Extension: moddatetime moddatetime() -- function -- Extension: fuzzystrmatch difference() -- function dmetaphone() -- function dmetaphone_alt() -- function levenshtein() -- function levenshtein_less_equal() -- function metaphone() -- function soundex() -- function text_soundex() -- function -- Extension: ltree_plpython3u ltree_to_plpython3() -- function -- Extension: pgrouting pgr_alphashape() -- function pgr_analyzegraph() -- function pgr_analyzeoneway() -- function pgr_apspjohnson() -- function pgr_apspwarshall() -- function pgr_articulationpoints() -- function pgr_astar() -- function pgr_astarcost() -- function pgr_astarcostmatrix() -- function pgr_bdastar() -- function pgr_bdastarcost() -- function pgr_bdastarcostmatrix() -- function pgr_bddijkstra() -- function pgr_bddijkstracost() -- function pgr_bddijkstracostmatrix() -- function pgr_biconnectedcomponents() -- function pgr_boykovkolmogorov() -- function pgr_bridges() -- function pgr_connectedcomponents() -- function pgr_contractgraph() -- function pgr_createtopology() -- function pgr_createverticestable() -- function pgr_dijkstra() -- function pgr_dijkstracost() -- function pgr_dijkstracostmatrix() -- function pgr_dijkstravia() -- function pgr_drivingdistance() -- function pgr_edgedisjointpaths() -- function pgr_edmondskarp() -- function pgr_endpoint() -- function pgr_euclediantsp() -- function pgr_flipedges() -- function pgr_floydwarshall() -- function pgr_getcolumnname() -- function pgr_gettablename() -- function pgr_gsoc_vrppdtw() -- function pgr_iscolumnindexed() -- function pgr_iscolumnintable() -- function pgr_johnson() -- function pgr_kdijkstracost() -- function pgr_kdijkstrapath() -- function pgr_ksp() -- function pgr_labelgraph() -- function pgr_linegraph() -- function pgr_linegraphfull() -- function pgr_maxcardinalitymatch() -- function pgr_maxflow() -- function pgr_maxflowboykovkolmogorov() -- function pgr_maxflowedmondskarp() -- function pgr_maxflowpushrelabel() -- function pgr_maximumcardinalitymatching() -- function pgr_nodenetwork() -- function pgr_pointsaspolygon() -- function pgr_pointstodmatrix() -- function pgr_pointstovids() -- function pgr_pointtoedgenode() -- function pgr_pushrelabel() -- function pgr_quote_ident() -- function pgr_startpoint() -- function pgr_strongcomponents() -- function pgr_texttopoints() -- function pgr_trsp() -- function pgr_trspviaedges() -- function pgr_trspviavertices() -- function pgr_tsp() -- function pgr_version() -- function pgr_versionless() -- function pgr_vidstodmatrix() -- function pgr_vrponedepot() -- function pgr_withpoints() -- function pgr_withpointscost() -- function pgr_withpointscostmatrix() -- function pgr_withpointsdd() -- function pgr_withpointsksp() -- function pgr_costresult -- type pgr_costresult3 -- type pgr_geomresult -- type -- Extension: pldbgapi pldbg_abort_target() -- function pldbg_attach_to_port() -- function pldbg_continue() -- function pldbg_create_listener() -- function pldbg_deposit_value() -- function pldbg_drop_breakpoint() -- function pldbg_get_breakpoints() -- function pldbg_get_proxy_info() -- function pldbg_get_source() -- function pldbg_get_stack() -- function pldbg_get_target_info() -- function pldbg_get_variables() -- function pldbg_oid_debug() -- function pldbg_select_frame() -- function pldbg_set_breakpoint() -- function pldbg_set_global_breakpoint() -- function pldbg_step_into() -- function pldbg_step_over() -- function pldbg_wait_for_breakpoint() -- function pldbg_wait_for_target() -- function plpgsql_oid_debug() -- function breakpoint -- type frame -- type proxyinfo -- type targetinfo -- type var -- type -- Extension: pgcrypto armor() -- function crypt() -- function dearmor() -- function decrypt() -- function decrypt_iv() -- function digest() -- function encrypt() -- function encrypt_iv() -- function gen_random_bytes() -- function gen_random_uuid() -- function gen_salt() -- function hmac() -- function pgp_armor_headers() -- function pgp_key_id() -- function pgp_pub_decrypt() -- function pgp_pub_decrypt_bytea() -- function pgp_pub_encrypt() -- function pgp_pub_encrypt_bytea() -- function pgp_sym_decrypt() -- function pgp_sym_decrypt_bytea() -- function pgp_sym_encrypt() -- function pgp_sym_encrypt_bytea() -- function -- Extension: postgis_sfcgal postgis_sfcgal_scripts_installed() -- function postgis_sfcgal_version() -- function st_3darea() -- function st_3ddifference() -- function st_3dintersection() -- function st_3dunion() -- function st_approximatemedialaxis() -- function st_extrude() -- function st_forcelhr() -- function st_isplanar() -- function st_issolid() -- function st_makesolid() -- function st_minkowskisum() -- function st_orientation() -- function st_straightskeleton() -- function st_tesselate() -- function st_volume() -- function -- Extension: timetravel get_timetravel() -- function set_timetravel() -- function timetravel() -- function -- Extension: plperl plperl_call_handler() -- function plperl_inline_handler() -- function plperl_validator() -- function -- Extension: tablefunc connectby() -- function crosstab() -- function crosstab2() -- function crosstab3() -- function crosstab4() -- function normal_rand() -- function tablefunc_crosstab_2 -- type tablefunc_crosstab_3 -- type tablefunc_crosstab_4 -- type -- Extension: postgres_fdw postgres_fdw_handler() -- function postgres_fdw_validator() -- function -- Extension: bloom blhandler() -- function -- Extension: pltcl pltcl_call_handler() -- function -- Extension: citext citext() -- function citext_cmp() -- function citext_eq() -- function citext_ge() -- function citext_gt() -- function citext_hash() -- function citext_larger() -- function citext_le() -- function citext_lt() -- function citext_ne() -- function citext_smaller() -- function citextin() -- function citextout() -- function citextrecv() -- function citextsend() -- function max() -- function min() -- function regexp_match() -- function regexp_matches() -- function regexp_replace() -- function regexp_split_to_array() -- function regexp_split_to_table() -- function replace() -- function split_part() -- function strpos() -- function texticlike() -- function texticnlike() -- function texticregexeq() -- function texticregexne() -- function translate() -- function citext -- type -- Extension: plpgsql plpgsql_call_handler() -- function plpgsql_inline_handler() -- function plpgsql_validator() -- function -- Extensions names address_standardizer address_standardizer_data_us adminpack amcheck autoinc bloom btree_gin btree_gist chkpass citext cube dblink dict_int dict_xsyn earthdistance file_fdw fuzzystrmatch hstore hstore_plperl hstore_plperlu hstore_plpython3u insert_username intagg intarray isn lo ltree ltree_plpython3u moddatetime pageinspect pg_buffercache pg_freespacemap pg_prewarm pg_stat_statements pg_trgm pg_visibility pgcrypto pgrouting pgrowlocks pgstattuple pgtap pldbgapi plperl plperlu plpgsql plpython3u pltcl pltclu postgis postgis_sfcgal postgis_tiger_geocoder postgis_topology postgres_fdw refint seg sslinfo tablefunc tcn timetravel tsm_system_rows tsm_system_time unaccent xml2 -- Catalog tables administrable_role_authorizations applicable_roles attributes character_sets check_constraint_routine_usage check_constraints collation_character_set_applicability collations column_domain_usage column_options column_privileges column_udt_usage columns constraint_column_usage constraint_table_usage data_type_privileges domain_constraints domain_udt_usage domains element_types enabled_roles foreign_data_wrapper_options foreign_data_wrappers foreign_server_options foreign_servers foreign_table_options foreign_tables information_schema_catalog_name key_column_usage parameters pg_aggregate pg_am pg_amop pg_amproc pg_attrdef pg_attribute pg_auth_members pg_authid pg_available_extension_versions pg_available_extensions pg_cast pg_class pg_collation pg_config pg_constraint pg_conversion pg_cursors pg_database pg_db_role_setting pg_default_acl pg_depend pg_description pg_enum pg_event_trigger pg_extension pg_file_settings pg_foreign_data_wrapper pg_foreign_server pg_foreign_table pg_group pg_hba_file_rules pg_index pg_indexes pg_inherits pg_init_privs pg_language pg_largeobject pg_largeobject_metadata pg_locks pg_matviews pg_namespace pg_opclass pg_operator pg_opfamily pg_partitioned_table pg_pltemplate pg_policies pg_policy pg_prepared_statements pg_prepared_xacts pg_proc pg_publication pg_publication_rel pg_publication_tables pg_range pg_replication_origin pg_replication_origin_status pg_replication_slots pg_rewrite pg_roles pg_rules pg_seclabel pg_seclabels pg_sequence pg_sequences pg_settings pg_shadow pg_shdepend pg_shdescription pg_shseclabel pg_stat_activity pg_stat_all_indexes pg_stat_all_tables pg_stat_archiver pg_stat_bgwriter pg_stat_database pg_stat_database_conflicts pg_stat_progress_vacuum pg_stat_replication pg_stat_ssl pg_stat_subscription pg_stat_sys_indexes pg_stat_sys_tables pg_stat_user_functions pg_stat_user_indexes pg_stat_user_tables pg_stat_wal_receiver pg_stat_xact_all_tables pg_stat_xact_sys_tables pg_stat_xact_user_functions pg_stat_xact_user_tables pg_statio_all_indexes pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_indexes pg_statio_sys_sequences pg_statio_sys_tables pg_statio_user_indexes pg_statio_user_sequences pg_statio_user_tables pg_statistic pg_statistic_ext pg_stats pg_subscription pg_subscription_rel pg_tables pg_tablespace pg_timezone_abbrevs pg_timezone_names pg_transform pg_trigger pg_ts_config pg_ts_config_map pg_ts_dict pg_ts_parser pg_ts_template pg_type pg_user pg_user_mapping pg_user_mappings pg_views referential_constraints role_column_grants role_routine_grants role_table_grants role_udt_grants role_usage_grants routine_privileges routines schemata sequences sql_features sql_implementation_info sql_languages sql_packages sql_parts sql_sizing sql_sizing_profiles table_constraints table_privileges tables transforms triggered_update_columns triggers udt_privileges usage_privileges user_defined_types user_mapping_options user_mappings view_column_usage view_routine_usage view_table_usage views -- Built-in keywords absolute access action add admin after aggregate all also always analyse and any as asc assertion assignment asymmetric at attach attribute authorization backward before between binary both by cache called cascade cascaded case cast catalog chain characteristics check class coalesce collate collation column columns comments committed concurrently configuration conflict connection constraint content continue conversion cost cross csv current current_catalog current_date current_role current_schema current_time current_timestamp current_user cursor cycle data database day dec default defaults deferrable deferred definer delimiter delimiters depends desc detach dictionary disable distinct document domain each else enable encoding encrypted enum escape event except exclude excluding exclusive exists extension external extract false family filter first float following for force foreign forward freeze from full function functions generated global granted greatest group grouping handler having header hold hour identity if ilike immediate immutable implicit in including increment index indexes inherit inherits initially inline inner inout input insensitive instead intersect into invoker is isnull isolation join key language large last lateral leading leakproof least left level like limit local localtime localtimestamp location locked logged mapping match materialized maxvalue method minute minvalue mode month name names national natural nchar new next no none not nothing notnull nowait null nullif nulls object of off offset oids old on only operator option options or order ordinality out outer over overlaps overlay overriding owned owner parallel parser partial partition passing password placing plans policy position preceding preserve primary prior privileges procedural procedure program publication quote range read recheck recursive ref references referencing relative rename repeatable replace replica restart restrict returning returns right role rollup row rows rule schema schemas scroll search second sequence sequences serializable server session session_user setof sets share similar simple skip snapshot some sql stable standalone statement statistics stdin stdout storage strict strip subscription substring symmetric sysid system table tables tablesample tablespace temp template temporary then to trailing transform treat trigger trim true trusted type types unbounded uncommitted unencrypted union unique unknown unlogged until user using valid validate validator value variadic verbose version view views volatile when where whitespace window with within without wrapper write xmlattributes xmlconcat xmlelement xmlexists xmlforest xmlnamespaces xmlparse xmlpi xmlroot xmlserialize xmltable year yes -- Additional constants information_schema pg_catalog -- Operators ! !! !~ !~* !~~ !~~* # ## #- #< #<# #<= #<=# #<> #= #> #># #>= #>=# #>> % %# %% %> & && &&& &< &<| &> * *< *<= *<> *= *> *>= + - -> ->> -|- / < <#> <% <-> <->> << <<-> <<->> <<= <<| <= <=> <> <@ <@> <^ = > >= >> >>= >^ ? ?# ?& ?- ?-| ?<@ ?@ ?@> ?| ?|| ?~ @ @-@ @> @@ @@@ ^ ^<@ ^? ^@ ^@> ^~ | |&> |/ |=| |>> || ||/ ~ ~* ~<=~ ~<~ ~= ~> ~>=~ ~>~ ~~ ~~* -- Error codes active_sql_transaction admin_shutdown ambiguous_alias ambiguous_column ambiguous_function ambiguous_parameter array_subscript_error assert_failure bad_copy_file_format branch_transaction_already_active cannot_coerce cannot_connect_now cant_change_runtime_param cardinality_violation case_not_found character_not_in_repertoire check_violation collation_mismatch config_file_error configuration_limit_exceeded connection_does_not_exist connection_exception connection_failure containing_sql_not_permitted crash_shutdown data_corrupted data_exception database_dropped datatype_mismatch datetime_field_overflow deadlock_detected dependent_objects_still_exist dependent_privilege_descriptors_still_exist deprecated_feature diagnostics_exception disk_full division_by_zero duplicate_alias duplicate_column duplicate_cursor duplicate_database duplicate_file duplicate_function duplicate_object duplicate_prepared_statement duplicate_schema duplicate_table dynamic_result_sets_returned error_in_assignment escape_character_conflict event_trigger_protocol_violated exclusion_violation external_routine_exception external_routine_invocation_exception fdw_column_name_not_found fdw_dynamic_parameter_value_needed fdw_error fdw_function_sequence_error fdw_inconsistent_descriptor_information fdw_invalid_attribute_value fdw_invalid_column_name fdw_invalid_column_number fdw_invalid_data_type fdw_invalid_data_type_descriptors fdw_invalid_descriptor_field_identifier fdw_invalid_handle fdw_invalid_option_index fdw_invalid_option_name fdw_invalid_string_format fdw_invalid_string_length_or_buffer_length fdw_invalid_use_of_null_pointer fdw_no_schemas fdw_option_name_not_found fdw_out_of_memory fdw_reply_handle fdw_schema_not_found fdw_table_not_found fdw_too_many_handles fdw_unable_to_create_execution fdw_unable_to_create_reply fdw_unable_to_establish_connection feature_not_supported floating_point_exception foreign_key_violation function_executed_no_return_statement generated_always grouping_error held_cursor_requires_same_isolation_level idle_in_transaction_session_timeout implicit_zero_bit_padding in_failed_sql_transaction inappropriate_access_mode_for_branch_transaction inappropriate_isolation_level_for_branch_transaction indeterminate_collation indeterminate_datatype index_corrupted indicator_overflow insufficient_privilege insufficient_resources integrity_constraint_violation internal_error interval_field_overflow invalid_argument_for_logarithm invalid_argument_for_nth_value_function invalid_argument_for_ntile_function invalid_argument_for_power_function invalid_argument_for_width_bucket_function invalid_authorization_specification invalid_binary_representation invalid_catalog_name invalid_character_value_for_cast invalid_column_definition invalid_column_reference invalid_cursor_definition invalid_cursor_name invalid_cursor_state invalid_database_definition invalid_datetime_format invalid_escape_character invalid_escape_octet invalid_escape_sequence invalid_foreign_key invalid_function_definition invalid_grant_operation invalid_grantor invalid_indicator_parameter_value invalid_locator_specification invalid_name invalid_object_definition invalid_parameter_value invalid_password invalid_preceding_following_size invalid_prepared_statement_definition invalid_recursion invalid_regular_expression invalid_role_specification invalid_row_count_in_limit_clause invalid_row_count_in_result_offset_clause invalid_savepoint_specification invalid_schema_definition invalid_schema_name invalid_sql_statement_name invalid_sqlstate_returned invalid_table_definition invalid_tablesample_argument invalid_tablesample_repeat invalid_text_representation invalid_time_zone_displacement_value invalid_transaction_initiation invalid_transaction_state invalid_transaction_termination invalid_use_of_escape_character invalid_xml_comment invalid_xml_content invalid_xml_document invalid_xml_processing_instruction io_error locator_exception lock_file_exists lock_not_available modifying_sql_data_not_permitted most_specific_type_mismatch name_too_long no_active_sql_transaction no_active_sql_transaction_for_branch_transaction no_additional_dynamic_result_sets_returned no_data no_data_found nonstandard_use_of_escape_character not_an_xml_document not_null_violation null_value_eliminated_in_set_function null_value_no_indicator_parameter null_value_not_allowed numeric_value_out_of_range object_in_use object_not_in_prerequisite_state operator_intervention out_of_memory plpgsql_error privilege_not_granted privilege_not_revoked program_limit_exceeded prohibited_sql_statement_attempted protocol_violation query_canceled raise_exception read_only_sql_transaction reading_sql_data_not_permitted reserved_name restrict_violation savepoint_exception schema_and_data_statement_mixing_not_supported sequence_generator_limit_exceeded serialization_failure snapshot_too_old sql_routine_exception sql_statement_not_yet_complete sqlclient_unable_to_establish_sqlconnection sqlserver_rejected_establishment_of_sqlconnection srf_protocol_violated stacked_diagnostics_accessed_without_active_handler statement_completion_unknown statement_too_complex string_data_length_mismatch string_data_right_truncation substring_error successful_completion syntax_error syntax_error_or_access_rule_violation system_error too_many_arguments too_many_columns too_many_connections too_many_rows transaction_integrity_constraint_violation transaction_resolution_unknown transaction_rollback trigger_protocol_violated triggered_action_exception triggered_data_change_violation trim_error undefined_column undefined_file undefined_function undefined_object undefined_parameter undefined_table unique_violation unterminated_c_string untranslatable_character warning windowing_error with_check_option_violation wrong_object_type zero_length_character_string -- More checks -- See https://github.com/lifepillar/pgsql.vim/issues/4 where cast(t.data #>> '{user,id_str}' as bigint) = 123; pgsql.vim-2.1.1/src/pgsql.sql000066400000000000000000000266651330023463100161030ustar00rootroot00000000000000-- To generate the syntax file, proceed as follows: -- -- 1. createdb -T template0 vim_pgsql_syntax -- 2. psql -f pgsql.sql vim_pgsql_syntax -- -- ...or simply use the provided Makefile. \o \set QUIET 1 \pset border 0 \pset columns 0 \pset expanded off \pset fieldsep ' ' \pset footer off \pset format unaligned \pset null '' \pset numericlocale off \pset pager off \pset recordsep '\n' \pset title \pset tuples_only on \i common.sql start transaction; set local client_min_messages to 'warning'; set local schema 'public'; -- Format keywords to use in a Vim syntax file. -- _keywords is a list of keywords. -- _kind is the highlight group (without the 'sql' prefix). -- _wrap is the (approximate) number of columns after which a new line should start. -- -- Example: select vim_format('[create, select]', 'Statement', 6). create or replace function vim_format( _keywords text[], _kind text, _wrap integer default 60) returns setof text language plpgsql stable set search_path to "public" as $$ begin return query with T as ( select sum(char_length(keyword)) over (order by keyword) as num, keyword from unnest(_keywords) K(keyword) ) select format('syn keyword sql%s contained %s', _kind, string_agg(keyword, ' ')) from T group by num / (_wrap - 1) order by num / (_wrap - 1); return; end; $$; create or replace function vim_format_operators( _keywords text[], _kind text, _wrap integer default 50) returns setof text language plpgsql stable set search_path to "public" as $$ begin return query with T as ( select sum(char_length(keyword)) over (order by char_length(keyword) desc, keyword) as num, keyword from unnest(_keywords) K(keyword) ) select format('syn match sql%s contained "\%%(%s\)\ze\%%([^!?~#^@<=>%%&|*/+-]\|$\)"', _kind, string_agg(regexp_replace(keyword, '[~^*#]', E'\\\\\\&', 'g'), '\|')) from T group by num / (_wrap - 1) order by num / (_wrap - 1); return; end; $$; -- Define keywords for all extensions create or replace function vim_format_extensions( _wrap integer default 60 ) returns setof text language plpgsql stable set search_path to "public" as $$ declare _ext record; begin for _ext in select extname, extversion from extension_names() loop return query select format('" Extension: %s (v%s)', _ext.extname, _ext.extversion); return query select format('if index(get(g:, ''pgsql_disabled_extensions'', []), ''%s'') == -1', _ext.extname); return query with T as ( select sum(char_length(synkeyword)) over (partition by synclass order by synkeyword) num, synclass, synkeyword from get_extension_objects(_ext.extname) ) select format(' syn keyword sql%s contained %s', initcap(synclass), string_agg(regexp_replace(synkeyword, '^\w+\.|"', '', 'g'), ' ')) -- remove schema name and double quotes from T group by synclass, num / (_wrap - 1) order by synclass, num / (_wrap - 1); return query select format('endif " %s', _ext.extname); end loop; for _ext in select extname from legacy_extension_names() loop return query select format('" Extension: %s', _ext.extname); return query select format('if index(get(g:, ''pgsql_disabled_extensions'', []), ''%s'') == -1', _ext.extname); return query with T as ( select sum(char_length(synkeyword)) over (partition by synclass order by synkeyword) num, synclass, synkeyword from get_legacy_extension_objects(_ext.extname) ) select format(' syn keyword sql%s contained %s', initcap(synclass), string_agg(regexp_replace(synkeyword, '^\w+\.|"', '', 'g'), ' ')) -- remove schema name and double quotes from T group by synclass, num / (_wrap - 1) order by synclass, num / (_wrap - 1); return query select format('endif " %s', _ext.extname); end loop; return; end; $$; ------------------------------------------------------------------------------- select 'Generating syntax file...'; \o pgsql.vim select $HERE$" Vim syntax file " Language: SQL (PostgreSQL dialect), PL/pgSQL, PL/…, PostGIS, … " Maintainer: Lifepillar " Version: 2.1.1 " License: This file is placed in the public domain. $HERE$; select '" Based on ' || substring(version() from 'PostgreSQL \d+\.\d+\.?\d*'); select '" Automatically generated on ' || current_date || ' at ' || localtime(0); select $HERE$ if exists("b:current_syntax") finish endif syn case ignore syn sync minlines=100 syn iskeyword @,48-57,192-255,_ syn match sqlIsKeyword /\<\h\w*\>/ contains=sqlStatement,sqlKeyword,sqlCatalog,sqlConstant,sqlSpecial,sqlOption,sqlErrorCode,sqlType,sqlTable,sqlView syn match sqlIsFunction /\<\h\w*\ze(/ contains=sqlFunction,sqlKeyword syn region sqlIsPsql start=/^\s*\\/ end=/\n/ oneline contains=sqlPsqlCommand,sqlPsqlKeyword,sqlNumber,sqlString syn keyword sqlSpecial contained false null true $HERE$; select '" Statements'; select vim_format(array(select get_statements()), 'Statement'); select '" Types'; select vim_format(array(select get_types()), 'Type'); select 'syn match sqlType /pg_toast_\d\+/'; select '" Additional types'; select vim_format(array(select get_additional_types()), 'Type'); select '" Keywords'; select vim_format(array(select get_keywords()), 'Keyword'); select vim_format(array(select get_additional_constants()), 'Constant'); select '" Built-in functions'; select vim_format(array(select get_builtin_functions()), 'Function'); select '" Extensions names'; select vim_format(array(select extname from extension_names() where not extname ~* '-'), 'Constant'); select '" Legacy extensions names'; select vim_format(array(select extname from legacy_extension_names() where not extname ~* '-'), 'Constant'); select vim_format_extensions(); select '" Catalog tables'; select vim_format(array(select get_catalog_tables()), 'Catalog'); select '" Error codes (Appendix A, Table A-1)'; select vim_format(array(select get_errcodes()), 'ErrorCode'); select $HERE$ " Numbers syn match sqlNumber "\<\d*\.\=[0-9_]\>" " Variables (identifiers starting with an underscore) syn match sqlVariable "\<_[A-Za-z0-9][A-Za-z0-9_]*\>" " Strings syn region sqlIdentifier start=+"+ skip=+\\\\\|\\"+ end=+"+ syn region sqlString start=+'+ skip=+\\\\\|\\'+ end=+'+ contains=@Spell syn region sqlString start=+\$HERE\$+ end=+\$HERE\$+ " Operators syn match sqlIsOperator "\%(^\|[^!?~#^@<=>%&|*/+-]\)\zs[!?~#^@<=>%&|*/+-]\+" contains=sqlOperator $HERE$; select vim_format_operators(array(select get_operators()), 'Operator'); select $HERE$ " Comments syn region sqlComment start="/\*" end="\*/" contains=sqlTodo,@Spell syn match sqlComment "#\s.*$" contains=sqlTodo,@Spell syn match sqlComment "--.*$" contains=sqlTodo,@Spell " Options syn keyword sqlOption contained client_min_messages search_path syntax case match " Psql Keywords syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\[aCfHhortTxz]\>\|\\[?!]/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\c\%(\%(d\|onnect\|onninfo\|opy\%(right\)\?\|rosstabview\)\?\)\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\d\>\|\\dS\>+\?\|\\d[ao]S\?\>\|\\d[cDgiLmnOstTuvE]\%(\>\|S\>+\?\)/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\d[AbClx]\>+\?\|\\d[py]\>\|\\dd[pS]\>\?\|\\de[tsuw]\>+\?\|\\df[antw]\?S\?\>+\?\|\\dF[dpt]\?\>+\?\|\\drds\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\e\%(cho\|[fv]\|ncoding\|rrverbose\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\g\%(exec\|set\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\ir\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\l\>+\?\|\\lo_\%(export\|import\|list\|unlink\)\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\p\%(assword\|rompt\|set\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\q\%(echo\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\s\>\|\\s[fv]\>+\?\|\\set\%(env\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\t\%(iming\)\?\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\unset\>/ syn match sqlPsqlCommand contained nextgroup=sqlPsqlKeyword,sqlNumber,sqlString /\\w\%(atch\)\?\>/ syn keyword sqlPsqlKeyword contained format border columns expanded fieldsep fieldsep_zero footer null syn keyword sqlPsqlKeyword contained numericlocale recordsep recordsep_zero tuples_only title tableattr pages syn keyword sqlPsqlKeyword contained unicode_border_linestyle unicode_column_linestyle unicode_header_linestyle syn keyword sqlPsqlKeyword contained on off auto unaligned pager syn keyword sqlPsqlKeyword contained AUTOCOMMIT HISTCONTROL PROMPT VERBOSITY SHOW_CONTEXT VERSION syn keyword sqlPsqlKeyword contained DBNAME USER HOST PORT ENCODING HISTSIZE QUIET " Todo syn keyword sqlTodo contained TODO FIXME XXX DEBUG NOTE syntax case ignore " PL/pgSQL syn keyword sqlPlpgsqlKeyword contained alias all array as begin by case close collate column constant syn keyword sqlPlpgsqlKeyword contained constraint continue current current cursor datatype declare syn keyword sqlPlpgsqlKeyword contained detail diagnostics else elsif end errcode exception execute syn keyword sqlPlpgsqlKeyword contained exit fetch for foreach forward found from get hint if syn keyword sqlPlpgsqlKeyword contained into last loop message move next no notice open perform prepare syn keyword sqlPlpgsqlKeyword contained query raise relative return reverse rowtype schema syn keyword sqlPlpgsqlKeyword contained scroll slice sqlstate stacked strict table tg_argv tg_event syn keyword sqlPlpgsqlKeyword contained tg_level tg_name tg_nargs tg_op tg_relid tg_relname syn keyword sqlPlpgsqlKeyword contained tg_table_name tg_table_schema tg_tag tg_when then type using syn keyword sqlPlpgsqlKeyword contained while syn region plpgsql matchgroup=sqlString start=+\$pgsql\$+ end=+\$pgsql\$+ keepend contains=ALL syn region plpgsql matchgroup=sqlString start=+\$\$+ end=+\$\$+ keepend contains=ALL " PL/ fun! s:add_syntax(s) execute 'syn include @PL' . a:s . ' syntax/' . a:s . '.vim' unlet b:current_syntax execute 'syn region pgsqlpl' . a:s . ' start=+\$' . a:s . '\$+ end=+\$' . a:s . '\$+ keepend contains=@PL' . a:s endf for pl in get(b:, 'pgsql_pl', get(g:, 'pgsql_pl', [])) call s:add_syntax(pl) endfor " Default highlighting hi def link sqlCatalog Constant hi def link sqlComment Comment hi def link sqlConstant Constant hi def link sqlErrorCode Special hi def link sqlFunction Function hi def link sqlIdentifier Identifier hi def link sqlKeyword sqlSpecial hi def link sqlplpgsqlKeyword sqlSpecial hi def link sqlNumber Number hi def link sqlOperator sqlStatement hi def link sqlOption Define hi def link sqlSpecial Special hi def link sqlStatement Statement hi def link sqlString String hi def link sqlTable Identifier hi def link sqlType Type hi def link sqlView sqlTable hi def link sqlTodo Todo hi def link sqlVariable Identifier hi def link sqlPsqlCommand SpecialKey hi def link sqlPsqlKeyword Keyword let b:current_syntax = "sql" $HERE$; \o select 'done!'; commit; \o pgsql.vim-2.1.1/src/test.sql000066400000000000000000000040331330023463100157150ustar00rootroot00000000000000-- Generate keywords.sql. \o \set QUIET 1 \pset border 0 \pset columns 0 \pset expanded off \pset fieldsep ' ' \pset footer off \pset format unaligned \pset null '' \pset numericlocale off \pset pager off \pset recordsep '\n' \pset title \pset tuples_only on \i common.sql start transaction; set local client_min_messages to 'warning'; set local schema 'public'; create or replace function vim_extensions() returns setof text language plpgsql stable set search_path to "public" as $$ declare _ext record; begin for _ext in select extname from extension_names() loop return query select format('-- Extension: %s', _ext.extname); return query select regexp_replace(synkeyword, '^\w+\.|"', '', 'g') || case when synclass = 'function' then '()' else '' end || ' -- ' || synclass from get_extension_objects(_ext.extname); end loop; return; end; $$; select 'Generating the test file...'; \o keywords.sql select '-- Statements'; select stm from get_statements() order by stm; select '-- Types'; select "type" from get_types() order by "type"; select '-- Additional types'; select "type" from get_additional_types() order by "type"; select 'pg_toast_1234'; select '-- Built-in functions'; select synfunction || '()' from get_builtin_functions() order by synfunction; select vim_extensions(); select '-- Extensions names'; select extname from extension_names() where not extname ~* '-' order by extname; select '-- Catalog tables'; select table_name from get_catalog_tables() order by table_name; select '-- Built-in keywords'; select keyword from get_keywords() order by keyword; select '-- Additional constants'; select keyword from get_additional_constants() order by keyword; select '-- Operators'; select keyword from get_operators() order by keyword; select '-- Error codes'; select errcode from get_errcodes() order by errcode; select $HERE$ -- More checks -- See https://github.com/lifepillar/pgsql.vim/issues/4 where cast(t.data #>> '{user,id_str}' as bigint) = 123; $HERE$; \o select 'done!'; commit; \o pgsql.vim-2.1.1/syntax/000077500000000000000000000000001330023463100147545ustar00rootroot00000000000000pgsql.vim-2.1.1/syntax/pgsql.vim000066400000000000000000004363751330023463100166410ustar00rootroot00000000000000" Vim syntax file " Language: SQL (PostgreSQL dialect), PL/pgSQL, PL/…, PostGIS, … " Maintainer: Lifepillar " Version: 2.1.1 " License: This file is placed in the public domain. " Based on PostgreSQL 10.4 " Automatically generated on 2018-05-20 at 10:59:59 if exists("b:current_syntax") finish endif syn case ignore syn sync minlines=100 syn iskeyword @,48-57,192-255,_ syn match sqlIsKeyword /\<\h\w*\>/ contains=sqlStatement,sqlKeyword,sqlCatalog,sqlConstant,sqlSpecial,sqlOption,sqlErrorCode,sqlType,sqlTable,sqlView syn match sqlIsFunction /\<\h\w*\ze(/ contains=sqlFunction,sqlKeyword syn region sqlIsPsql start=/^\s*\\/ end=/\n/ oneline contains=sqlPsqlCommand,sqlPsqlKeyword,sqlNumber,sqlString syn keyword sqlSpecial contained false null true " Statements syn keyword sqlStatement contained abort alter analyze begin checkpoint close cluster comment commit syn keyword sqlStatement contained constraints copy create deallocate declare delete discard do drop end syn keyword sqlStatement contained execute explain fetch grant import insert label listen load lock move syn keyword sqlStatement contained notify prepare prepared reassign refresh reindex release reset syn keyword sqlStatement contained revoke rollback savepoint security select select set show start syn keyword sqlStatement contained transaction truncate unlisten update vacuum values work " Types syn keyword sqlType contained abstime aclitem addbandarg addr addr_gid_seq addrfeat syn keyword sqlType contained addrfeat_gid_seq agg_count agg_samealignment anyarray anyelement anyenum syn keyword sqlType contained anynonarray anyrange bg bg_gid_seq bit bool box box2d box2df box3d syn keyword sqlType contained bpchar breakpoint bytea cardinal_number char character_data chkpass syn keyword sqlType contained cid cidr circle citext county county_gid_seq county_lookup syn keyword sqlType contained countysub_lookup cousub cousub_gid_seq cstring cube date daterange syn keyword sqlType contained dblink_pkey_results direction_lookup ean13 earth edges edges_gid_seq syn keyword sqlType contained errcodes event_trigger faces faces_gid_seq fdw_handler featnames syn keyword sqlType contained featnames_gid_seq float4 float8 frame gbtreekey16 gbtreekey32 syn keyword sqlType contained gbtreekey4 gbtreekey8 gbtreekey_var geocode_settings syn keyword sqlType contained geocode_settings_default geography geography_columns geometry geometry_columns syn keyword sqlType contained geometry_dump geomval getfaceedges_returntype ghstore gidx gtrgm syn keyword sqlType contained gtsvector hstore index_am_handler inet int2 int2vector int4 syn keyword sqlType contained int4range int8 int8range intbig_gkey internal interval isbn isbn13 ismn syn keyword sqlType contained ismn13 issn issn13 json jsonb language_handler layer line lo syn keyword sqlType contained loader_lookuptables loader_platform loader_variables lquery lseg ltree syn keyword sqlType contained ltree_gist ltxtquery macaddr macaddr8 money norm_addy numeric numrange syn keyword sqlType contained oid oidvector opaque pagc_gaz pagc_gaz_id_seq pagc_lex syn keyword sqlType contained pagc_lex_id_seq pagc_rules pagc_rules_id_seq path pg_all_foreign_keys syn keyword sqlType contained pg_ddl_command pg_dependencies pg_lsn pg_ndistinct pg_node_tree syn keyword sqlType contained pgis_abs pgr_costresult pgr_costresult3 pgr_geomresult place syn keyword sqlType contained place_gid_seq place_lookup point polygon proxyinfo query_int rastbandarg syn keyword sqlType contained raster raster_columns raster_overviews reclassarg record syn keyword sqlType contained refcursor regclass regconfig regdictionary regnamespace regoper syn keyword sqlType contained regoperator regproc regprocedure regrole regtype reltime syn keyword sqlType contained secondary_unit_lookup seg smgr spatial_ref_sys spheroid sql_identifier state syn keyword sqlType contained state_gid_seq state_lookup stdaddr street_type_lookup summarystats syn keyword sqlType contained tabblock tabblock_gid_seq tablefunc_crosstab_2 syn keyword sqlType contained tablefunc_crosstab_3 tablefunc_crosstab_4 tap_funky targetinfo text tid time syn keyword sqlType contained time_stamp timestamp timestamptz timetz tinterval topoelement syn keyword sqlType contained topoelementarray topogeometry topology topology_id_seq tract tract_gid_seq syn keyword sqlType contained tsm_handler tsquery tsrange tstzrange tsvector txid_snapshot syn keyword sqlType contained unionarg upc us_gaz us_gaz_id_seq us_lex us_lex_id_seq us_rules syn keyword sqlType contained us_rules_id_seq uuid valid_detail validatetopology_returntype var syn keyword sqlType contained varbit varchar void xid xml yes_or_no zcta5 zcta5_gid_seq zip_lookup syn keyword sqlType contained zip_lookup_all zip_lookup_base zip_state zip_state_loc syn match sqlType /pg_toast_\d\+/ " Additional types syn keyword sqlType contained array bigint bigserial bit boolean char character cube decimal syn keyword sqlType contained double int integer interval numeric precision real serial serial2 syn keyword sqlType contained serial4 serial8 smallint smallserial text timestamp varchar varying xml syn keyword sqlType contained zone " Keywords syn keyword sqlKeyword contained absolute access action add admin after aggregate all also always syn keyword sqlKeyword contained analyse and any as asc assertion assignment asymmetric at attach syn keyword sqlKeyword contained attribute authorization backward before between binary both by cache called syn keyword sqlKeyword contained cascade cascaded case cast catalog chain characteristics check syn keyword sqlKeyword contained class coalesce collate collation column columns comments committed syn keyword sqlKeyword contained concurrently configuration conflict connection constraint content syn keyword sqlKeyword contained continue conversion cost cross csv current current_catalog syn keyword sqlKeyword contained current_date current_role current_schema current_time current_timestamp syn keyword sqlKeyword contained current_user cursor cycle data database day dec default defaults syn keyword sqlKeyword contained deferrable deferred definer delimiter delimiters depends desc detach syn keyword sqlKeyword contained dictionary disable distinct document domain each else enable encoding syn keyword sqlKeyword contained encrypted enum escape event except exclude excluding exclusive syn keyword sqlKeyword contained exists extension external extract false family filter first float syn keyword sqlKeyword contained following for force foreign forward freeze from full function functions syn keyword sqlKeyword contained generated global granted greatest group grouping handler having header syn keyword sqlKeyword contained hold hour identity if ilike immediate immutable implicit in including syn keyword sqlKeyword contained increment index indexes inherit inherits initially inline inner syn keyword sqlKeyword contained inout input insensitive instead intersect into invoker is isnull syn keyword sqlKeyword contained isolation join key language large last lateral leading leakproof least left syn keyword sqlKeyword contained level like limit local localtime localtimestamp location locked syn keyword sqlKeyword contained logged mapping match materialized maxvalue method minute minvalue mode syn keyword sqlKeyword contained month name names national natural nchar new next no none not nothing syn keyword sqlKeyword contained notnull nowait null nullif nulls object of off offset oids old on only syn keyword sqlKeyword contained operator option options or order ordinality out outer over overlaps syn keyword sqlKeyword contained overlay overriding owned owner parallel parser partial partition syn keyword sqlKeyword contained passing password placing plans policy position preceding preserve primary syn keyword sqlKeyword contained prior privileges procedural procedure program publication quote syn keyword sqlKeyword contained range read recheck recursive ref references referencing relative syn keyword sqlKeyword contained rename repeatable replace replica restart restrict returning returns syn keyword sqlKeyword contained right role rollup row rows rule schema schemas scroll search second syn keyword sqlKeyword contained sequence sequences serializable server session session_user setof sets syn keyword sqlKeyword contained share similar simple skip snapshot some sql stable standalone syn keyword sqlKeyword contained statement statistics stdin stdout storage strict strip subscription syn keyword sqlKeyword contained substring symmetric sysid system table tables tablesample tablespace syn keyword sqlKeyword contained temp template temporary then to trailing transform treat trigger trim syn keyword sqlKeyword contained true trusted type types unbounded uncommitted unencrypted union syn keyword sqlKeyword contained unique unknown unlogged until user using valid validate validator value syn keyword sqlKeyword contained variadic verbose version view views volatile when where whitespace syn keyword sqlKeyword contained window with within without wrapper write xmlattributes xmlconcat syn keyword sqlKeyword contained xmlelement xmlexists xmlforest xmlnamespaces xmlparse xmlpi xmlroot syn keyword sqlKeyword contained xmlserialize xmltable year yes syn keyword sqlConstant contained information_schema pg_catalog " Built-in functions syn keyword sqlFunction contained RI_FKey_cascade_del RI_FKey_cascade_upd RI_FKey_check_ins syn keyword sqlFunction contained RI_FKey_check_upd RI_FKey_noaction_del RI_FKey_noaction_upd syn keyword sqlFunction contained RI_FKey_restrict_del RI_FKey_restrict_upd RI_FKey_setdefault_del syn keyword sqlFunction contained RI_FKey_setdefault_upd RI_FKey_setnull_del RI_FKey_setnull_upd syn keyword sqlFunction contained abbrev abs abstime abstimeeq abstimege abstimegt abstimein syn keyword sqlFunction contained abstimele abstimelt abstimene abstimeout abstimerecv abstimesend syn keyword sqlFunction contained aclcontains acldefault aclexplode aclinsert aclitemeq aclitemin syn keyword sqlFunction contained aclitemout aclremove acos acosd age amvalidate any_in any_out anyarray_in syn keyword sqlFunction contained anyarray_out anyarray_recv anyarray_send anyelement_in syn keyword sqlFunction contained anyelement_out anyenum_in anyenum_out anynonarray_in anynonarray_out syn keyword sqlFunction contained anyrange_in anyrange_out anytextcat area areajoinsel areasel array_agg syn keyword sqlFunction contained array_agg_array_finalfn array_agg_array_transfn syn keyword sqlFunction contained array_agg_finalfn array_agg_transfn array_append array_cat array_dims array_eq syn keyword sqlFunction contained array_fill array_ge array_gt array_in array_larger array_le syn keyword sqlFunction contained array_length array_lower array_lt array_ndims array_ne array_out syn keyword sqlFunction contained array_position array_positions array_prepend array_recv array_remove syn keyword sqlFunction contained array_replace array_send array_smaller array_to_json syn keyword sqlFunction contained array_to_string array_to_tsvector array_typanalyze array_upper syn keyword sqlFunction contained arraycontained arraycontains arraycontjoinsel arraycontsel arrayoverlap syn keyword sqlFunction contained ascii ascii_to_mic ascii_to_utf8 asin asind atan atan2 atan2d atand syn keyword sqlFunction contained avg bernoulli big5_to_euc_tw big5_to_mic big5_to_utf8 syn keyword sqlFunction contained binary_upgrade_create_empty_extension syn keyword sqlFunction contained binary_upgrade_set_next_array_pg_type_oid binary_upgrade_set_next_heap_pg_class_oid syn keyword sqlFunction contained binary_upgrade_set_next_index_pg_class_oid syn keyword sqlFunction contained binary_upgrade_set_next_pg_authid_oid binary_upgrade_set_next_pg_enum_oid syn keyword sqlFunction contained binary_upgrade_set_next_pg_type_oid syn keyword sqlFunction contained binary_upgrade_set_next_toast_pg_class_oid binary_upgrade_set_next_toast_pg_type_oid syn keyword sqlFunction contained binary_upgrade_set_record_init_privs bit bit_and bit_in bit_length bit_or syn keyword sqlFunction contained bit_out bit_recv bit_send bitand bitcat bitcmp biteq bitge bitgt bitle syn keyword sqlFunction contained bitlt bitne bitnot bitor bitshiftleft bitshiftright bittypmodin syn keyword sqlFunction contained bittypmodout bitxor bool bool_accum bool_accum_inv bool_alltrue syn keyword sqlFunction contained bool_and bool_anytrue bool_or booland_statefunc booleq boolge boolgt syn keyword sqlFunction contained boolin boolle boollt boolne boolor_statefunc boolout boolrecv boolsend syn keyword sqlFunction contained bound_box box box_above box_above_eq box_add box_below syn keyword sqlFunction contained box_below_eq box_center box_contain box_contain_pt box_contained syn keyword sqlFunction contained box_distance box_div box_eq box_ge box_gt box_in box_intersect box_le syn keyword sqlFunction contained box_left box_lt box_mul box_out box_overabove box_overbelow box_overlap syn keyword sqlFunction contained box_overleft box_overright box_recv box_right box_same box_send syn keyword sqlFunction contained box_sub bpchar bpchar_larger bpchar_pattern_ge bpchar_pattern_gt syn keyword sqlFunction contained bpchar_pattern_le bpchar_pattern_lt bpchar_smaller syn keyword sqlFunction contained bpchar_sortsupport bpcharcmp bpchareq bpcharge bpchargt bpchariclike syn keyword sqlFunction contained bpcharicnlike bpcharicregexeq bpcharicregexne bpcharin bpcharle syn keyword sqlFunction contained bpcharlike bpcharlt bpcharne bpcharnlike bpcharout bpcharrecv syn keyword sqlFunction contained bpcharregexeq bpcharregexne bpcharsend bpchartypmodin bpchartypmodout syn keyword sqlFunction contained brin_desummarize_range brin_inclusion_add_value syn keyword sqlFunction contained brin_inclusion_consistent brin_inclusion_opcinfo brin_inclusion_union syn keyword sqlFunction contained brin_minmax_add_value brin_minmax_consistent brin_minmax_opcinfo syn keyword sqlFunction contained brin_minmax_union brin_summarize_new_values brin_summarize_range syn keyword sqlFunction contained brinhandler broadcast btabstimecmp btarraycmp btboolcmp syn keyword sqlFunction contained btbpchar_pattern_cmp btbpchar_pattern_sortsupport btcharcmp btfloat48cmp syn keyword sqlFunction contained btfloat4cmp btfloat4sortsupport btfloat84cmp btfloat8cmp syn keyword sqlFunction contained btfloat8sortsupport bthandler btint24cmp btint28cmp btint2cmp syn keyword sqlFunction contained btint2sortsupport btint42cmp btint48cmp btint4cmp btint4sortsupport syn keyword sqlFunction contained btint82cmp btint84cmp btint8cmp btint8sortsupport btnamecmp syn keyword sqlFunction contained btnamesortsupport btoidcmp btoidsortsupport btoidvectorcmp btrecordcmp syn keyword sqlFunction contained btrecordimagecmp btreltimecmp btrim bttext_pattern_cmp syn keyword sqlFunction contained bttext_pattern_sortsupport bttextcmp bttextsortsupport bttidcmp syn keyword sqlFunction contained bttintervalcmp bytea_sortsupport bytea_string_agg_finalfn syn keyword sqlFunction contained bytea_string_agg_transfn byteacat byteacmp byteaeq byteage byteagt byteain syn keyword sqlFunction contained byteale bytealike bytealt byteane byteanlike byteaout bytearecv syn keyword sqlFunction contained byteasend cardinality cash_cmp cash_div_cash cash_div_flt4 syn keyword sqlFunction contained cash_div_flt8 cash_div_int2 cash_div_int4 cash_div_int8 cash_eq cash_ge syn keyword sqlFunction contained cash_gt cash_in cash_le cash_lt cash_mi cash_mul_flt4 cash_mul_flt8 syn keyword sqlFunction contained cash_mul_int2 cash_mul_int4 cash_mul_int8 cash_ne cash_out cash_pl syn keyword sqlFunction contained cash_recv cash_send cash_words cashlarger cashsmaller cbrt ceil syn keyword sqlFunction contained ceiling center char char_length character_length chareq charge syn keyword sqlFunction contained chargt charin charle charlt charne charout charrecv charsend chr cideq syn keyword sqlFunction contained cidin cidout cidr cidr_in cidr_out cidr_recv cidr_send cidrecv cidsend syn keyword sqlFunction contained circle circle_above circle_add_pt circle_below circle_center syn keyword sqlFunction contained circle_contain circle_contain_pt circle_contained circle_distance syn keyword sqlFunction contained circle_div_pt circle_eq circle_ge circle_gt circle_in circle_le syn keyword sqlFunction contained circle_left circle_lt circle_mul_pt circle_ne circle_out syn keyword sqlFunction contained circle_overabove circle_overbelow circle_overlap circle_overleft syn keyword sqlFunction contained circle_overright circle_recv circle_right circle_same circle_send syn keyword sqlFunction contained circle_sub_pt clock_timestamp close_lb close_ls close_lseg close_pb syn keyword sqlFunction contained close_pl close_ps close_sb close_sl col_description concat syn keyword sqlFunction contained concat_ws contjoinsel contsel convert convert_from convert_to corr cos syn keyword sqlFunction contained cosd cot cotd count covar_pop covar_samp cstring_in cstring_out syn keyword sqlFunction contained cstring_recv cstring_send cume_dist cume_dist_final current_database syn keyword sqlFunction contained current_query current_schema current_schemas current_setting syn keyword sqlFunction contained current_user currtid currtid2 currval cursor_to_xml syn keyword sqlFunction contained cursor_to_xmlschema database_to_xml database_to_xml_and_xmlschema syn keyword sqlFunction contained database_to_xmlschema date date_cmp date_cmp_timestamp syn keyword sqlFunction contained date_cmp_timestamptz date_eq date_eq_timestamp date_eq_timestamptz date_ge syn keyword sqlFunction contained date_ge_timestamp date_ge_timestamptz date_gt date_gt_timestamp syn keyword sqlFunction contained date_gt_timestamptz date_in date_larger date_le date_le_timestamp syn keyword sqlFunction contained date_le_timestamptz date_lt date_lt_timestamp date_lt_timestamptz syn keyword sqlFunction contained date_mi date_mi_interval date_mii date_ne date_ne_timestamp syn keyword sqlFunction contained date_ne_timestamptz date_out date_part date_pl_interval date_pli syn keyword sqlFunction contained date_recv date_send date_smaller date_sortsupport date_trunc syn keyword sqlFunction contained daterange daterange_canonical daterange_subdiff datetime_pl syn keyword sqlFunction contained datetimetz_pl dcbrt decode degrees dense_rank dense_rank_final dexp diagonal syn keyword sqlFunction contained diameter dispell_init dispell_lexize dist_cpoint dist_cpoly syn keyword sqlFunction contained dist_lb dist_pb dist_pc dist_pl dist_polyp dist_ppath dist_ppoly syn keyword sqlFunction contained dist_ps dist_sb dist_sl div dlog1 dlog10 domain_in domain_recv dpow dround syn keyword sqlFunction contained dsimple_init dsimple_lexize dsnowball_init dsnowball_lexize syn keyword sqlFunction contained dsqrt dsynonym_init dsynonym_lexize dtrunc elem_contained_by_range syn keyword sqlFunction contained encode enum_cmp enum_eq enum_first enum_ge enum_gt enum_in syn keyword sqlFunction contained enum_larger enum_last enum_le enum_lt enum_ne enum_out enum_range syn keyword sqlFunction contained enum_recv enum_send enum_smaller eqjoinsel eqsel euc_cn_to_mic syn keyword sqlFunction contained euc_cn_to_utf8 euc_jis_2004_to_shift_jis_2004 euc_jis_2004_to_utf8 syn keyword sqlFunction contained euc_jp_to_mic euc_jp_to_sjis euc_jp_to_utf8 euc_kr_to_mic syn keyword sqlFunction contained euc_kr_to_utf8 euc_tw_to_big5 euc_tw_to_mic euc_tw_to_utf8 syn keyword sqlFunction contained event_trigger_in event_trigger_out every exp factorial family fdw_handler_in syn keyword sqlFunction contained fdw_handler_out first_value float4 float48div float48eq float48ge syn keyword sqlFunction contained float48gt float48le float48lt float48mi float48mul float48ne syn keyword sqlFunction contained float48pl float4_accum float4abs float4div float4eq float4ge float4gt syn keyword sqlFunction contained float4in float4larger float4le float4lt float4mi float4mul syn keyword sqlFunction contained float4ne float4out float4pl float4recv float4send float4smaller float4um syn keyword sqlFunction contained float4up float8 float84div float84eq float84ge float84gt syn keyword sqlFunction contained float84le float84lt float84mi float84mul float84ne float84pl float8_accum syn keyword sqlFunction contained float8_avg float8_combine float8_corr float8_covar_pop syn keyword sqlFunction contained float8_covar_samp float8_regr_accum float8_regr_avgx float8_regr_avgy syn keyword sqlFunction contained float8_regr_combine float8_regr_intercept float8_regr_r2 syn keyword sqlFunction contained float8_regr_slope float8_regr_sxx float8_regr_sxy float8_regr_syy syn keyword sqlFunction contained float8_stddev_pop float8_stddev_samp float8_var_pop syn keyword sqlFunction contained float8_var_samp float8abs float8div float8eq float8ge float8gt float8in syn keyword sqlFunction contained float8larger float8le float8lt float8mi float8mul float8ne float8out syn keyword sqlFunction contained float8pl float8recv float8send float8smaller float8um float8up floor syn keyword sqlFunction contained flt4_mul_cash flt8_mul_cash fmgr_c_validator syn keyword sqlFunction contained fmgr_internal_validator fmgr_sql_validator format format_type gb18030_to_utf8 syn keyword sqlFunction contained gbk_to_utf8 generate_series generate_subscripts get_bit get_byte syn keyword sqlFunction contained get_current_ts_config getdatabaseencoding getpgusername syn keyword sqlFunction contained gin_clean_pending_list gin_cmp_prefix gin_cmp_tslexeme syn keyword sqlFunction contained gin_compare_jsonb gin_consistent_jsonb gin_consistent_jsonb_path syn keyword sqlFunction contained gin_extract_jsonb gin_extract_jsonb_path gin_extract_jsonb_query syn keyword sqlFunction contained gin_extract_jsonb_query_path gin_extract_tsquery gin_extract_tsvector syn keyword sqlFunction contained gin_triconsistent_jsonb gin_triconsistent_jsonb_path syn keyword sqlFunction contained gin_tsquery_consistent gin_tsquery_triconsistent ginarrayconsistent syn keyword sqlFunction contained ginarrayextract ginarraytriconsistent ginhandler syn keyword sqlFunction contained ginqueryarrayextract gist_box_compress gist_box_consistent gist_box_decompress syn keyword sqlFunction contained gist_box_fetch gist_box_penalty gist_box_picksplit syn keyword sqlFunction contained gist_box_same gist_box_union gist_circle_compress gist_circle_consistent syn keyword sqlFunction contained gist_circle_distance gist_point_compress gist_point_consistent syn keyword sqlFunction contained gist_point_distance gist_point_fetch gist_poly_compress syn keyword sqlFunction contained gist_poly_consistent gist_poly_distance gisthandler gtsquery_compress syn keyword sqlFunction contained gtsquery_consistent gtsquery_decompress gtsquery_penalty syn keyword sqlFunction contained gtsquery_picksplit gtsquery_same gtsquery_union gtsvector_compress syn keyword sqlFunction contained gtsvector_consistent gtsvector_decompress gtsvector_penalty syn keyword sqlFunction contained gtsvector_picksplit gtsvector_same gtsvector_union gtsvectorin syn keyword sqlFunction contained gtsvectorout has_any_column_privilege has_column_privilege syn keyword sqlFunction contained has_database_privilege has_foreign_data_wrapper_privilege syn keyword sqlFunction contained has_function_privilege has_language_privilege has_schema_privilege syn keyword sqlFunction contained has_sequence_privilege has_server_privilege has_table_privilege syn keyword sqlFunction contained has_tablespace_privilege has_type_privilege hash_aclitem syn keyword sqlFunction contained hash_array hash_numeric hash_range hashbpchar hashchar hashenum syn keyword sqlFunction contained hashfloat4 hashfloat8 hashhandler hashinet hashint2 hashint4 hashint8 syn keyword sqlFunction contained hashmacaddr hashmacaddr8 hashname hashoid hashoidvector hashtext syn keyword sqlFunction contained hashvarlena height host hostmask iclikejoinsel iclikesel syn keyword sqlFunction contained icnlikejoinsel icnlikesel icregexeqjoinsel icregexeqsel icregexnejoinsel syn keyword sqlFunction contained icregexnesel index_am_handler_in index_am_handler_out syn keyword sqlFunction contained inet_client_addr inet_client_port inet_gist_compress inet_gist_consistent syn keyword sqlFunction contained inet_gist_decompress inet_gist_fetch inet_gist_penalty syn keyword sqlFunction contained inet_gist_picksplit inet_gist_same inet_gist_union inet_in inet_merge syn keyword sqlFunction contained inet_out inet_recv inet_same_family inet_send inet_server_addr syn keyword sqlFunction contained inet_server_port inet_spg_choose inet_spg_config syn keyword sqlFunction contained inet_spg_inner_consistent inet_spg_leaf_consistent inet_spg_picksplit inetand syn keyword sqlFunction contained inetmi inetmi_int8 inetnot inetor inetpl initcap int2 int24div syn keyword sqlFunction contained int24eq int24ge int24gt int24le int24lt int24mi int24mul int24ne syn keyword sqlFunction contained int24pl int28div int28eq int28ge int28gt int28le int28lt int28mi int28mul syn keyword sqlFunction contained int28ne int28pl int2_accum int2_accum_inv int2_avg_accum syn keyword sqlFunction contained int2_avg_accum_inv int2_mul_cash int2_sum int2abs int2and int2div int2eq syn keyword sqlFunction contained int2ge int2gt int2in int2int4_sum int2larger int2le int2lt int2mi syn keyword sqlFunction contained int2mod int2mul int2ne int2not int2or int2out int2pl int2recv syn keyword sqlFunction contained int2send int2shl int2shr int2smaller int2um int2up int2vectorin syn keyword sqlFunction contained int2vectorout int2vectorrecv int2vectorsend int2xor int4 int42div int42eq syn keyword sqlFunction contained int42ge int42gt int42le int42lt int42mi int42mul int42ne int42pl syn keyword sqlFunction contained int48div int48eq int48ge int48gt int48le int48lt int48mi int48mul syn keyword sqlFunction contained int48ne int48pl int4_accum int4_accum_inv int4_avg_accum syn keyword sqlFunction contained int4_avg_accum_inv int4_avg_combine int4_mul_cash int4_sum int4abs int4and syn keyword sqlFunction contained int4div int4eq int4ge int4gt int4in int4inc int4larger int4le syn keyword sqlFunction contained int4lt int4mi int4mod int4mul int4ne int4not int4or int4out int4pl syn keyword sqlFunction contained int4range int4range_canonical int4range_subdiff int4recv int4send syn keyword sqlFunction contained int4shl int4shr int4smaller int4um int4up int4xor int8 int82div int82eq syn keyword sqlFunction contained int82ge int82gt int82le int82lt int82mi int82mul int82ne int82pl syn keyword sqlFunction contained int84div int84eq int84ge int84gt int84le int84lt int84mi int84mul syn keyword sqlFunction contained int84ne int84pl int8_accum int8_accum_inv int8_avg int8_avg_accum syn keyword sqlFunction contained int8_avg_accum_inv int8_avg_combine int8_avg_deserialize syn keyword sqlFunction contained int8_avg_serialize int8_mul_cash int8_sum int8abs int8and int8dec syn keyword sqlFunction contained int8dec_any int8div int8eq int8ge int8gt int8in int8inc int8inc_any syn keyword sqlFunction contained int8inc_float8_float8 int8larger int8le int8lt int8mi int8mod int8mul syn keyword sqlFunction contained int8ne int8not int8or int8out int8pl int8pl_inet int8range syn keyword sqlFunction contained int8range_canonical int8range_subdiff int8recv int8send int8shl int8shr syn keyword sqlFunction contained int8smaller int8um int8up int8xor integer_pl_date inter_lb syn keyword sqlFunction contained inter_sb inter_sl internal_in internal_out interval interval_accum syn keyword sqlFunction contained interval_accum_inv interval_avg interval_cmp interval_combine syn keyword sqlFunction contained interval_div interval_eq interval_ge interval_gt interval_hash syn keyword sqlFunction contained interval_in interval_larger interval_le interval_lt interval_mi syn keyword sqlFunction contained interval_mul interval_ne interval_out interval_pl interval_pl_date syn keyword sqlFunction contained interval_pl_time interval_pl_timestamp interval_pl_timestamptz syn keyword sqlFunction contained interval_pl_timetz interval_recv interval_send interval_smaller syn keyword sqlFunction contained interval_transform interval_um intervaltypmodin syn keyword sqlFunction contained intervaltypmodout intinterval isclosed isempty isfinite ishorizontal syn keyword sqlFunction contained iso8859_1_to_utf8 iso8859_to_utf8 iso_to_koi8r iso_to_mic iso_to_win1251 syn keyword sqlFunction contained iso_to_win866 isopen isparallel isperp isvertical johab_to_utf8 syn keyword sqlFunction contained json_agg json_agg_finalfn json_agg_transfn json_array_element syn keyword sqlFunction contained json_array_element_text json_array_elements syn keyword sqlFunction contained json_array_elements_text json_array_length json_build_array json_build_object syn keyword sqlFunction contained json_each json_each_text json_extract_path json_extract_path_text syn keyword sqlFunction contained json_in json_object json_object_agg json_object_agg_finalfn syn keyword sqlFunction contained json_object_agg_transfn json_object_field json_object_field_text syn keyword sqlFunction contained json_object_keys json_out json_populate_record syn keyword sqlFunction contained json_populate_recordset json_recv json_send json_strip_nulls json_to_record syn keyword sqlFunction contained json_to_recordset json_typeof jsonb_agg jsonb_agg_finalfn syn keyword sqlFunction contained jsonb_agg_transfn jsonb_array_element jsonb_array_element_text syn keyword sqlFunction contained jsonb_array_elements jsonb_array_elements_text jsonb_array_length syn keyword sqlFunction contained jsonb_build_array jsonb_build_object jsonb_cmp jsonb_concat syn keyword sqlFunction contained jsonb_contained jsonb_contains jsonb_delete jsonb_delete_path jsonb_each syn keyword sqlFunction contained jsonb_each_text jsonb_eq jsonb_exists jsonb_exists_all syn keyword sqlFunction contained jsonb_exists_any jsonb_extract_path jsonb_extract_path_text jsonb_ge syn keyword sqlFunction contained jsonb_gt jsonb_hash jsonb_in jsonb_insert jsonb_le jsonb_lt jsonb_ne syn keyword sqlFunction contained jsonb_object jsonb_object_agg jsonb_object_agg_finalfn syn keyword sqlFunction contained jsonb_object_agg_transfn jsonb_object_field jsonb_object_field_text syn keyword sqlFunction contained jsonb_object_keys jsonb_out jsonb_populate_record syn keyword sqlFunction contained jsonb_populate_recordset jsonb_pretty jsonb_recv jsonb_send jsonb_set syn keyword sqlFunction contained jsonb_strip_nulls jsonb_to_record jsonb_to_recordset jsonb_typeof syn keyword sqlFunction contained justify_days justify_hours justify_interval koi8r_to_iso syn keyword sqlFunction contained koi8r_to_mic koi8r_to_utf8 koi8r_to_win1251 koi8r_to_win866 koi8u_to_utf8 syn keyword sqlFunction contained lag language_handler_in language_handler_out last_value lastval syn keyword sqlFunction contained latin1_to_mic latin2_to_mic latin2_to_win1250 latin3_to_mic syn keyword sqlFunction contained latin4_to_mic lead left length like like_escape likejoinsel likesel syn keyword sqlFunction contained line line_distance line_eq line_horizontal line_in line_interpt syn keyword sqlFunction contained line_intersect line_out line_parallel line_perp line_recv line_send syn keyword sqlFunction contained line_vertical ln lo_close lo_creat lo_create lo_export syn keyword sqlFunction contained lo_from_bytea lo_get lo_import lo_lseek lo_lseek64 lo_open lo_put lo_tell syn keyword sqlFunction contained lo_tell64 lo_truncate lo_truncate64 lo_unlink log loread lower syn keyword sqlFunction contained lower_inc lower_inf lowrite lpad lseg lseg_center lseg_distance lseg_eq syn keyword sqlFunction contained lseg_ge lseg_gt lseg_horizontal lseg_in lseg_interpt syn keyword sqlFunction contained lseg_intersect lseg_le lseg_length lseg_lt lseg_ne lseg_out lseg_parallel syn keyword sqlFunction contained lseg_perp lseg_recv lseg_send lseg_vertical ltrim macaddr macaddr8 syn keyword sqlFunction contained macaddr8_and macaddr8_cmp macaddr8_eq macaddr8_ge macaddr8_gt syn keyword sqlFunction contained macaddr8_in macaddr8_le macaddr8_lt macaddr8_ne macaddr8_not syn keyword sqlFunction contained macaddr8_or macaddr8_out macaddr8_recv macaddr8_send macaddr8_set7bit syn keyword sqlFunction contained macaddr_and macaddr_cmp macaddr_eq macaddr_ge macaddr_gt syn keyword sqlFunction contained macaddr_in macaddr_le macaddr_lt macaddr_ne macaddr_not macaddr_or syn keyword sqlFunction contained macaddr_out macaddr_recv macaddr_send macaddr_sortsupport make_date syn keyword sqlFunction contained make_interval make_time make_timestamp make_timestamptz syn keyword sqlFunction contained makeaclitem masklen max md5 mic_to_ascii mic_to_big5 mic_to_euc_cn syn keyword sqlFunction contained mic_to_euc_jp mic_to_euc_kr mic_to_euc_tw mic_to_iso mic_to_koi8r syn keyword sqlFunction contained mic_to_latin1 mic_to_latin2 mic_to_latin3 mic_to_latin4 mic_to_sjis syn keyword sqlFunction contained mic_to_win1250 mic_to_win1251 mic_to_win866 min mktinterval mod mode syn keyword sqlFunction contained mode_final money mul_d_interval mxid_age name nameeq namege namegt syn keyword sqlFunction contained nameiclike nameicnlike nameicregexeq nameicregexne namein namele syn keyword sqlFunction contained namelike namelt namene namenlike nameout namerecv nameregexeq syn keyword sqlFunction contained nameregexne namesend neqjoinsel neqsel netmask network network_cmp syn keyword sqlFunction contained network_eq network_ge network_gt network_larger network_le syn keyword sqlFunction contained network_lt network_ne network_overlap network_smaller network_sub syn keyword sqlFunction contained network_subeq network_sup network_supeq networkjoinsel networksel syn keyword sqlFunction contained nextval nlikejoinsel nlikesel notlike now npoints nth_value ntile syn keyword sqlFunction contained num_nonnulls num_nulls numeric numeric_abs numeric_accum syn keyword sqlFunction contained numeric_accum_inv numeric_add numeric_avg numeric_avg_accum syn keyword sqlFunction contained numeric_avg_combine numeric_avg_deserialize numeric_avg_serialize numeric_cmp syn keyword sqlFunction contained numeric_combine numeric_deserialize numeric_div syn keyword sqlFunction contained numeric_div_trunc numeric_eq numeric_exp numeric_fac numeric_ge numeric_gt syn keyword sqlFunction contained numeric_in numeric_inc numeric_larger numeric_le numeric_ln syn keyword sqlFunction contained numeric_log numeric_lt numeric_mod numeric_mul numeric_ne numeric_out syn keyword sqlFunction contained numeric_poly_avg numeric_poly_combine numeric_poly_deserialize syn keyword sqlFunction contained numeric_poly_serialize numeric_poly_stddev_pop syn keyword sqlFunction contained numeric_poly_stddev_samp numeric_poly_sum numeric_poly_var_pop syn keyword sqlFunction contained numeric_poly_var_samp numeric_power numeric_recv numeric_send syn keyword sqlFunction contained numeric_serialize numeric_smaller numeric_sortsupport numeric_sqrt syn keyword sqlFunction contained numeric_stddev_pop numeric_stddev_samp numeric_sub numeric_sum syn keyword sqlFunction contained numeric_transform numeric_uminus numeric_uplus numeric_var_pop syn keyword sqlFunction contained numeric_var_samp numerictypmodin numerictypmodout numnode numrange syn keyword sqlFunction contained numrange_subdiff obj_description octet_length oid oideq oidge oidgt oidin syn keyword sqlFunction contained oidlarger oidle oidlt oidne oidout oidrecv oidsend oidsmaller syn keyword sqlFunction contained oidvectoreq oidvectorge oidvectorgt oidvectorin oidvectorle oidvectorlt syn keyword sqlFunction contained oidvectorne oidvectorout oidvectorrecv oidvectorsend syn keyword sqlFunction contained oidvectortypes on_pb on_pl on_ppath on_ps on_sb on_sl opaque_in opaque_out syn keyword sqlFunction contained ordered_set_transition ordered_set_transition_multi overlaps syn keyword sqlFunction contained overlay parse_ident path path_add path_add_pt path_center syn keyword sqlFunction contained path_contain_pt path_distance path_div_pt path_in path_inter path_length syn keyword sqlFunction contained path_mul_pt path_n_eq path_n_ge path_n_gt path_n_le path_n_lt syn keyword sqlFunction contained path_npoints path_out path_recv path_send path_sub_pt pclose syn keyword sqlFunction contained percent_rank percent_rank_final percentile_cont syn keyword sqlFunction contained percentile_cont_float8_final percentile_cont_float8_multi_final syn keyword sqlFunction contained percentile_cont_interval_final percentile_cont_interval_multi_final syn keyword sqlFunction contained percentile_disc percentile_disc_final percentile_disc_multi_final syn keyword sqlFunction contained pg_advisory_lock pg_advisory_lock_shared pg_advisory_unlock syn keyword sqlFunction contained pg_advisory_unlock_all pg_advisory_unlock_shared pg_advisory_xact_lock syn keyword sqlFunction contained pg_advisory_xact_lock_shared pg_available_extension_versions syn keyword sqlFunction contained pg_available_extensions pg_backend_pid pg_backup_start_time syn keyword sqlFunction contained pg_blocking_pids pg_cancel_backend pg_char_to_encoding syn keyword sqlFunction contained pg_client_encoding pg_collation_actual_version pg_collation_for syn keyword sqlFunction contained pg_collation_is_visible pg_column_is_updatable pg_column_size syn keyword sqlFunction contained pg_conf_load_time pg_config pg_control_checkpoint pg_control_init syn keyword sqlFunction contained pg_control_recovery pg_control_system pg_conversion_is_visible syn keyword sqlFunction contained pg_create_logical_replication_slot syn keyword sqlFunction contained pg_create_physical_replication_slot pg_create_restore_point pg_current_logfile syn keyword sqlFunction contained pg_current_wal_flush_lsn pg_current_wal_insert_lsn pg_current_wal_lsn syn keyword sqlFunction contained pg_cursor pg_database_size pg_ddl_command_in pg_ddl_command_out syn keyword sqlFunction contained pg_ddl_command_recv pg_ddl_command_send pg_dependencies_in syn keyword sqlFunction contained pg_dependencies_out pg_dependencies_recv pg_dependencies_send syn keyword sqlFunction contained pg_describe_object pg_drop_replication_slot pg_encoding_max_length syn keyword sqlFunction contained pg_encoding_to_char pg_event_trigger_ddl_commands syn keyword sqlFunction contained pg_event_trigger_dropped_objects pg_event_trigger_table_rewrite_oid syn keyword sqlFunction contained pg_event_trigger_table_rewrite_reason pg_export_snapshot syn keyword sqlFunction contained pg_extension_config_dump pg_extension_update_paths pg_file_length syn keyword sqlFunction contained pg_file_read pg_file_rename pg_file_unlink pg_file_write syn keyword sqlFunction contained pg_filenode_relation pg_function_is_visible pg_get_constraintdef syn keyword sqlFunction contained pg_get_expr pg_get_function_arg_default pg_get_function_arguments syn keyword sqlFunction contained pg_get_function_identity_arguments pg_get_function_result syn keyword sqlFunction contained pg_get_functiondef pg_get_indexdef pg_get_keywords syn keyword sqlFunction contained pg_get_multixact_members pg_get_object_address pg_get_partition_constraintdef syn keyword sqlFunction contained pg_get_partkeydef pg_get_publication_tables syn keyword sqlFunction contained pg_get_replica_identity_index pg_get_replication_slots pg_get_ruledef syn keyword sqlFunction contained pg_get_serial_sequence pg_get_statisticsobjdef pg_get_triggerdef syn keyword sqlFunction contained pg_get_userbyid pg_get_viewdef pg_has_role pg_hba_file_rules syn keyword sqlFunction contained pg_identify_object pg_identify_object_as_address syn keyword sqlFunction contained pg_import_system_collations pg_index_column_has_property pg_index_has_property syn keyword sqlFunction contained pg_indexam_has_property pg_indexes_size pg_is_in_backup syn keyword sqlFunction contained pg_is_in_recovery pg_is_other_temp_schema pg_is_wal_replay_paused syn keyword sqlFunction contained pg_isolation_test_session_is_blocked pg_last_committed_xact syn keyword sqlFunction contained pg_last_wal_receive_lsn pg_last_wal_replay_lsn syn keyword sqlFunction contained pg_last_xact_replay_timestamp pg_listening_channels pg_lock_status pg_logdir_ls syn keyword sqlFunction contained pg_logfile_rotate pg_logical_emit_message syn keyword sqlFunction contained pg_logical_slot_get_binary_changes pg_logical_slot_get_changes syn keyword sqlFunction contained pg_logical_slot_peek_binary_changes pg_logical_slot_peek_changes pg_ls_dir syn keyword sqlFunction contained pg_ls_logdir pg_ls_waldir pg_lsn_cmp pg_lsn_eq pg_lsn_ge pg_lsn_gt syn keyword sqlFunction contained pg_lsn_hash pg_lsn_in pg_lsn_le pg_lsn_lt pg_lsn_mi pg_lsn_ne pg_lsn_out syn keyword sqlFunction contained pg_lsn_recv pg_lsn_send pg_my_temp_schema pg_ndistinct_in syn keyword sqlFunction contained pg_ndistinct_out pg_ndistinct_recv pg_ndistinct_send pg_node_tree_in syn keyword sqlFunction contained pg_node_tree_out pg_node_tree_recv pg_node_tree_send syn keyword sqlFunction contained pg_notification_queue_usage pg_notify pg_opclass_is_visible syn keyword sqlFunction contained pg_operator_is_visible pg_opfamily_is_visible pg_options_to_table syn keyword sqlFunction contained pg_postmaster_start_time pg_prepared_statement pg_prepared_xact syn keyword sqlFunction contained pg_read_binary_file pg_read_file pg_relation_filenode syn keyword sqlFunction contained pg_relation_filepath pg_relation_is_publishable pg_relation_is_updatable syn keyword sqlFunction contained pg_relation_size pg_reload_conf pg_replication_origin_advance syn keyword sqlFunction contained pg_replication_origin_create pg_replication_origin_drop syn keyword sqlFunction contained pg_replication_origin_oid pg_replication_origin_progress syn keyword sqlFunction contained pg_replication_origin_session_is_setup syn keyword sqlFunction contained pg_replication_origin_session_progress pg_replication_origin_session_reset syn keyword sqlFunction contained pg_replication_origin_session_setup pg_replication_origin_xact_reset syn keyword sqlFunction contained pg_replication_origin_xact_setup pg_rotate_logfile syn keyword sqlFunction contained pg_safe_snapshot_blocking_pids pg_sequence_last_value pg_sequence_parameters syn keyword sqlFunction contained pg_show_all_file_settings pg_show_all_settings syn keyword sqlFunction contained pg_show_replication_origin_status pg_size_bytes pg_size_pretty pg_sleep syn keyword sqlFunction contained pg_sleep_for pg_sleep_until pg_start_backup pg_stat_clear_snapshot syn keyword sqlFunction contained pg_stat_file pg_stat_get_activity pg_stat_get_analyze_count syn keyword sqlFunction contained pg_stat_get_archiver pg_stat_get_autoanalyze_count syn keyword sqlFunction contained pg_stat_get_autovacuum_count pg_stat_get_backend_activity syn keyword sqlFunction contained pg_stat_get_backend_activity_start pg_stat_get_backend_client_addr syn keyword sqlFunction contained pg_stat_get_backend_client_port pg_stat_get_backend_dbid syn keyword sqlFunction contained pg_stat_get_backend_idset pg_stat_get_backend_pid pg_stat_get_backend_start syn keyword sqlFunction contained pg_stat_get_backend_userid pg_stat_get_backend_wait_event syn keyword sqlFunction contained pg_stat_get_backend_wait_event_type pg_stat_get_backend_xact_start syn keyword sqlFunction contained pg_stat_get_bgwriter_buf_written_checkpoints syn keyword sqlFunction contained pg_stat_get_bgwriter_buf_written_clean pg_stat_get_bgwriter_maxwritten_clean syn keyword sqlFunction contained pg_stat_get_bgwriter_requested_checkpoints syn keyword sqlFunction contained pg_stat_get_bgwriter_stat_reset_time pg_stat_get_bgwriter_timed_checkpoints syn keyword sqlFunction contained pg_stat_get_blocks_fetched pg_stat_get_blocks_hit syn keyword sqlFunction contained pg_stat_get_buf_alloc pg_stat_get_buf_fsync_backend syn keyword sqlFunction contained pg_stat_get_buf_written_backend pg_stat_get_checkpoint_sync_time syn keyword sqlFunction contained pg_stat_get_checkpoint_write_time pg_stat_get_db_blk_read_time syn keyword sqlFunction contained pg_stat_get_db_blk_write_time pg_stat_get_db_blocks_fetched syn keyword sqlFunction contained pg_stat_get_db_blocks_hit pg_stat_get_db_conflict_all syn keyword sqlFunction contained pg_stat_get_db_conflict_bufferpin pg_stat_get_db_conflict_lock syn keyword sqlFunction contained pg_stat_get_db_conflict_snapshot pg_stat_get_db_conflict_startup_deadlock syn keyword sqlFunction contained pg_stat_get_db_conflict_tablespace pg_stat_get_db_deadlocks syn keyword sqlFunction contained pg_stat_get_db_numbackends pg_stat_get_db_stat_reset_time syn keyword sqlFunction contained pg_stat_get_db_temp_bytes pg_stat_get_db_temp_files syn keyword sqlFunction contained pg_stat_get_db_tuples_deleted pg_stat_get_db_tuples_fetched syn keyword sqlFunction contained pg_stat_get_db_tuples_inserted pg_stat_get_db_tuples_returned syn keyword sqlFunction contained pg_stat_get_db_tuples_updated pg_stat_get_db_xact_commit pg_stat_get_db_xact_rollback syn keyword sqlFunction contained pg_stat_get_dead_tuples pg_stat_get_function_calls syn keyword sqlFunction contained pg_stat_get_function_self_time pg_stat_get_function_total_time syn keyword sqlFunction contained pg_stat_get_last_analyze_time pg_stat_get_last_autoanalyze_time syn keyword sqlFunction contained pg_stat_get_last_autovacuum_time pg_stat_get_last_vacuum_time syn keyword sqlFunction contained pg_stat_get_live_tuples pg_stat_get_mod_since_analyze syn keyword sqlFunction contained pg_stat_get_numscans pg_stat_get_progress_info syn keyword sqlFunction contained pg_stat_get_snapshot_timestamp pg_stat_get_subscription pg_stat_get_tuples_deleted syn keyword sqlFunction contained pg_stat_get_tuples_fetched pg_stat_get_tuples_hot_updated syn keyword sqlFunction contained pg_stat_get_tuples_inserted pg_stat_get_tuples_returned syn keyword sqlFunction contained pg_stat_get_tuples_updated pg_stat_get_vacuum_count syn keyword sqlFunction contained pg_stat_get_wal_receiver pg_stat_get_wal_senders pg_stat_get_xact_blocks_fetched syn keyword sqlFunction contained pg_stat_get_xact_blocks_hit pg_stat_get_xact_function_calls syn keyword sqlFunction contained pg_stat_get_xact_function_self_time syn keyword sqlFunction contained pg_stat_get_xact_function_total_time pg_stat_get_xact_numscans syn keyword sqlFunction contained pg_stat_get_xact_tuples_deleted pg_stat_get_xact_tuples_fetched syn keyword sqlFunction contained pg_stat_get_xact_tuples_hot_updated pg_stat_get_xact_tuples_inserted syn keyword sqlFunction contained pg_stat_get_xact_tuples_returned pg_stat_get_xact_tuples_updated syn keyword sqlFunction contained pg_stat_reset pg_stat_reset_shared syn keyword sqlFunction contained pg_stat_reset_single_function_counters pg_stat_reset_single_table_counters syn keyword sqlFunction contained pg_statistics_obj_is_visible pg_stop_backup pg_switch_wal pg_table_is_visible syn keyword sqlFunction contained pg_table_size pg_tablespace_databases pg_tablespace_location syn keyword sqlFunction contained pg_tablespace_size pg_terminate_backend pg_timezone_abbrevs syn keyword sqlFunction contained pg_timezone_names pg_total_relation_size pg_trigger_depth syn keyword sqlFunction contained pg_try_advisory_lock pg_try_advisory_lock_shared pg_try_advisory_xact_lock syn keyword sqlFunction contained pg_try_advisory_xact_lock_shared pg_ts_config_is_visible syn keyword sqlFunction contained pg_ts_dict_is_visible pg_ts_parser_is_visible syn keyword sqlFunction contained pg_ts_template_is_visible pg_type_is_visible pg_typeof pg_wal_lsn_diff syn keyword sqlFunction contained pg_wal_replay_pause pg_wal_replay_resume pg_walfile_name syn keyword sqlFunction contained pg_walfile_name_offset pg_xact_commit_timestamp phraseto_tsquery pi syn keyword sqlFunction contained plainto_tsquery plperl_call_handler plperl_inline_handler plperl_validator syn keyword sqlFunction contained plperlu_call_handler plperlu_inline_handler plperlu_validator syn keyword sqlFunction contained plpgsql_call_handler plpgsql_inline_handler plpgsql_validator syn keyword sqlFunction contained plpython3_call_handler plpython3_inline_handler syn keyword sqlFunction contained plpython3_validator pltcl_call_handler pltclu_call_handler point point_above syn keyword sqlFunction contained point_add point_below point_distance point_div point_eq syn keyword sqlFunction contained point_horiz point_in point_left point_mul point_ne point_out point_recv syn keyword sqlFunction contained point_right point_send point_sub point_vert poly_above poly_below syn keyword sqlFunction contained poly_center poly_contain poly_contain_pt poly_contained syn keyword sqlFunction contained poly_distance poly_in poly_left poly_npoints poly_out poly_overabove syn keyword sqlFunction contained poly_overbelow poly_overlap poly_overleft poly_overright poly_recv syn keyword sqlFunction contained poly_right poly_same poly_send polygon popen position syn keyword sqlFunction contained positionjoinsel positionsel postgresql_fdw_validator pow power prsd_end syn keyword sqlFunction contained prsd_headline prsd_lextype prsd_nexttoken prsd_start syn keyword sqlFunction contained pt_contained_circle pt_contained_poly query_to_xml query_to_xml_and_xmlschema syn keyword sqlFunction contained query_to_xmlschema querytree quote_ident quote_literal syn keyword sqlFunction contained quote_nullable radians radius random range_adjacent range_after syn keyword sqlFunction contained range_before range_cmp range_contained_by range_contains syn keyword sqlFunction contained range_contains_elem range_eq range_ge range_gist_compress syn keyword sqlFunction contained range_gist_consistent range_gist_decompress range_gist_fetch range_gist_penalty syn keyword sqlFunction contained range_gist_picksplit range_gist_same range_gist_union range_gt syn keyword sqlFunction contained range_in range_intersect range_le range_lt range_merge range_minus syn keyword sqlFunction contained range_ne range_out range_overlaps range_overleft range_overright syn keyword sqlFunction contained range_recv range_send range_typanalyze range_union rangesel rank syn keyword sqlFunction contained rank_final record_eq record_ge record_gt record_image_eq syn keyword sqlFunction contained record_image_ge record_image_gt record_image_le record_image_lt syn keyword sqlFunction contained record_image_ne record_in record_le record_lt record_ne record_out syn keyword sqlFunction contained record_recv record_send regclass regclassin regclassout regclassrecv syn keyword sqlFunction contained regclasssend regconfigin regconfigout regconfigrecv syn keyword sqlFunction contained regconfigsend regdictionaryin regdictionaryout regdictionaryrecv syn keyword sqlFunction contained regdictionarysend regexeqjoinsel regexeqsel regexnejoinsel regexnesel syn keyword sqlFunction contained regexp_match regexp_matches regexp_replace regexp_split_to_array syn keyword sqlFunction contained regexp_split_to_table regnamespacein regnamespaceout syn keyword sqlFunction contained regnamespacerecv regnamespacesend regoperatorin regoperatorout syn keyword sqlFunction contained regoperatorrecv regoperatorsend regoperin regoperout regoperrecv syn keyword sqlFunction contained regopersend regprocedurein regprocedureout regprocedurerecv syn keyword sqlFunction contained regproceduresend regprocin regprocout regprocrecv regprocsend regr_avgx syn keyword sqlFunction contained regr_avgy regr_count regr_intercept regr_r2 regr_slope regr_sxx syn keyword sqlFunction contained regr_sxy regr_syy regrolein regroleout regrolerecv regrolesend syn keyword sqlFunction contained regtypein regtypeout regtyperecv regtypesend reltime reltimeeq reltimege syn keyword sqlFunction contained reltimegt reltimein reltimele reltimelt reltimene reltimeout syn keyword sqlFunction contained reltimerecv reltimesend repeat replace reverse right round row_number syn keyword sqlFunction contained row_security_active row_to_json rpad rtrim scalargtjoinsel syn keyword sqlFunction contained scalargtsel scalarltjoinsel scalarltsel scale schema_to_xml syn keyword sqlFunction contained schema_to_xml_and_xmlschema schema_to_xmlschema session_user set_bit syn keyword sqlFunction contained set_byte set_config set_masklen setseed setval setweight shell_in syn keyword sqlFunction contained shell_out shift_jis_2004_to_euc_jis_2004 shift_jis_2004_to_utf8 syn keyword sqlFunction contained shobj_description sign similar_escape sin sind sjis_to_euc_jp syn keyword sqlFunction contained sjis_to_mic sjis_to_utf8 slope smgreq smgrin smgrne smgrout syn keyword sqlFunction contained spg_box_quad_choose spg_box_quad_config spg_box_quad_inner_consistent syn keyword sqlFunction contained spg_box_quad_leaf_consistent spg_box_quad_picksplit spg_kd_choose syn keyword sqlFunction contained spg_kd_config spg_kd_inner_consistent spg_kd_picksplit syn keyword sqlFunction contained spg_quad_choose spg_quad_config spg_quad_inner_consistent syn keyword sqlFunction contained spg_quad_leaf_consistent spg_quad_picksplit spg_range_quad_choose syn keyword sqlFunction contained spg_range_quad_config spg_range_quad_inner_consistent syn keyword sqlFunction contained spg_range_quad_leaf_consistent spg_range_quad_picksplit spg_text_choose syn keyword sqlFunction contained spg_text_config spg_text_inner_consistent syn keyword sqlFunction contained spg_text_leaf_consistent spg_text_picksplit spghandler split_part sqrt syn keyword sqlFunction contained statement_timestamp stddev stddev_pop stddev_samp string_agg string_agg_finalfn syn keyword sqlFunction contained string_agg_transfn string_to_array strip strpos substr substring syn keyword sqlFunction contained sum suppress_redundant_updates_trigger system table_to_xml syn keyword sqlFunction contained table_to_xml_and_xmlschema table_to_xmlschema tan tand text text_ge syn keyword sqlFunction contained text_gt text_larger text_le text_lt text_pattern_ge syn keyword sqlFunction contained text_pattern_gt text_pattern_le text_pattern_lt text_smaller textanycat syn keyword sqlFunction contained textcat texteq texticlike texticnlike texticregexeq texticregexne syn keyword sqlFunction contained textin textlen textlike textne textnlike textout textrecv textregexeq syn keyword sqlFunction contained textregexne textsend thesaurus_init thesaurus_lexize tideq tidge syn keyword sqlFunction contained tidgt tidin tidlarger tidle tidlt tidne tidout tidrecv tidsend syn keyword sqlFunction contained tidsmaller time time_cmp time_eq time_ge time_gt time_hash time_in syn keyword sqlFunction contained time_larger time_le time_lt time_mi_interval time_mi_time time_ne syn keyword sqlFunction contained time_out time_pl_interval time_recv time_send time_smaller syn keyword sqlFunction contained time_transform timedate_pl timemi timenow timeofday timepl timestamp syn keyword sqlFunction contained timestamp_cmp timestamp_cmp_date timestamp_cmp_timestamptz syn keyword sqlFunction contained timestamp_eq timestamp_eq_date timestamp_eq_timestamptz timestamp_ge syn keyword sqlFunction contained timestamp_ge_date timestamp_ge_timestamptz timestamp_gt syn keyword sqlFunction contained timestamp_gt_date timestamp_gt_timestamptz timestamp_hash timestamp_in syn keyword sqlFunction contained timestamp_izone_transform timestamp_larger timestamp_le syn keyword sqlFunction contained timestamp_le_date timestamp_le_timestamptz timestamp_lt syn keyword sqlFunction contained timestamp_lt_date timestamp_lt_timestamptz timestamp_mi timestamp_mi_interval syn keyword sqlFunction contained timestamp_ne timestamp_ne_date timestamp_ne_timestamptz syn keyword sqlFunction contained timestamp_out timestamp_pl_interval timestamp_recv timestamp_send syn keyword sqlFunction contained timestamp_smaller timestamp_sortsupport timestamp_transform syn keyword sqlFunction contained timestamp_zone_transform timestamptypmodin timestamptypmodout syn keyword sqlFunction contained timestamptz timestamptz_cmp timestamptz_cmp_date syn keyword sqlFunction contained timestamptz_cmp_timestamp timestamptz_eq timestamptz_eq_date syn keyword sqlFunction contained timestamptz_eq_timestamp timestamptz_ge timestamptz_ge_date syn keyword sqlFunction contained timestamptz_ge_timestamp timestamptz_gt timestamptz_gt_date syn keyword sqlFunction contained timestamptz_gt_timestamp timestamptz_in timestamptz_larger timestamptz_le syn keyword sqlFunction contained timestamptz_le_date timestamptz_le_timestamp timestamptz_lt syn keyword sqlFunction contained timestamptz_lt_date timestamptz_lt_timestamp timestamptz_mi syn keyword sqlFunction contained timestamptz_mi_interval timestamptz_ne timestamptz_ne_date syn keyword sqlFunction contained timestamptz_ne_timestamp timestamptz_out timestamptz_pl_interval timestamptz_recv syn keyword sqlFunction contained timestamptz_send timestamptz_smaller timestamptztypmodin syn keyword sqlFunction contained timestamptztypmodout timetypmodin timetypmodout timetz timetz_cmp syn keyword sqlFunction contained timetz_eq timetz_ge timetz_gt timetz_hash timetz_in timetz_larger syn keyword sqlFunction contained timetz_le timetz_lt timetz_mi_interval timetz_ne timetz_out syn keyword sqlFunction contained timetz_pl_interval timetz_recv timetz_send timetz_smaller syn keyword sqlFunction contained timetzdate_pl timetztypmodin timetztypmodout timezone tinterval tintervalct syn keyword sqlFunction contained tintervalend tintervaleq tintervalge tintervalgt tintervalin syn keyword sqlFunction contained tintervalle tintervalleneq tintervallenge tintervallengt syn keyword sqlFunction contained tintervallenle tintervallenlt tintervallenne tintervallt tintervalne syn keyword sqlFunction contained tintervalout tintervalov tintervalrecv tintervalrel tintervalsame syn keyword sqlFunction contained tintervalsend tintervalstart to_ascii to_char to_date to_hex syn keyword sqlFunction contained to_json to_jsonb to_number to_regclass to_regnamespace to_regoper syn keyword sqlFunction contained to_regoperator to_regproc to_regprocedure to_regrole to_regtype syn keyword sqlFunction contained to_timestamp to_tsquery to_tsvector transaction_timestamp translate syn keyword sqlFunction contained trigger_in trigger_out trunc ts_debug ts_delete ts_filter syn keyword sqlFunction contained ts_headline ts_lexize ts_match_qv ts_match_tq ts_match_tt ts_match_vq syn keyword sqlFunction contained ts_parse ts_rank ts_rank_cd ts_rewrite ts_stat ts_token_type syn keyword sqlFunction contained ts_typanalyze tsm_handler_in tsm_handler_out tsmatchjoinsel tsmatchsel syn keyword sqlFunction contained tsq_mcontained tsq_mcontains tsquery_and tsquery_cmp tsquery_eq syn keyword sqlFunction contained tsquery_ge tsquery_gt tsquery_le tsquery_lt tsquery_ne syn keyword sqlFunction contained tsquery_not tsquery_or tsquery_phrase tsqueryin tsqueryout tsqueryrecv syn keyword sqlFunction contained tsquerysend tsrange tsrange_subdiff tstzrange tstzrange_subdiff syn keyword sqlFunction contained tsvector_cmp tsvector_concat tsvector_eq tsvector_ge tsvector_gt syn keyword sqlFunction contained tsvector_le tsvector_lt tsvector_ne tsvector_to_array syn keyword sqlFunction contained tsvector_update_trigger tsvector_update_trigger_column tsvectorin syn keyword sqlFunction contained tsvectorout tsvectorrecv tsvectorsend txid_current syn keyword sqlFunction contained txid_current_if_assigned txid_current_snapshot txid_snapshot_in txid_snapshot_out syn keyword sqlFunction contained txid_snapshot_recv txid_snapshot_send txid_snapshot_xip syn keyword sqlFunction contained txid_snapshot_xmax txid_snapshot_xmin txid_status syn keyword sqlFunction contained txid_visible_in_snapshot uhc_to_utf8 unique_key_recheck unknownin unknownout syn keyword sqlFunction contained unknownrecv unknownsend unnest upper upper_inc upper_inf utf8_to_ascii syn keyword sqlFunction contained utf8_to_big5 utf8_to_euc_cn utf8_to_euc_jis_2004 syn keyword sqlFunction contained utf8_to_euc_jp utf8_to_euc_kr utf8_to_euc_tw utf8_to_gb18030 utf8_to_gbk syn keyword sqlFunction contained utf8_to_iso8859 utf8_to_iso8859_1 utf8_to_johab utf8_to_koi8r syn keyword sqlFunction contained utf8_to_koi8u utf8_to_shift_jis_2004 utf8_to_sjis utf8_to_uhc syn keyword sqlFunction contained utf8_to_win uuid_cmp uuid_eq uuid_ge uuid_gt uuid_hash uuid_in uuid_le syn keyword sqlFunction contained uuid_lt uuid_ne uuid_out uuid_recv uuid_send uuid_sortsupport syn keyword sqlFunction contained var_pop var_samp varbit varbit_in varbit_out varbit_recv varbit_send syn keyword sqlFunction contained varbit_transform varbitcmp varbiteq varbitge varbitgt varbitle syn keyword sqlFunction contained varbitlt varbitne varbittypmodin varbittypmodout varchar syn keyword sqlFunction contained varchar_transform varcharin varcharout varcharrecv varcharsend syn keyword sqlFunction contained varchartypmodin varchartypmodout variance version void_in void_out void_recv syn keyword sqlFunction contained void_send width width_bucket win1250_to_latin2 win1250_to_mic syn keyword sqlFunction contained win1251_to_iso win1251_to_koi8r win1251_to_mic win1251_to_win866 syn keyword sqlFunction contained win866_to_iso win866_to_koi8r win866_to_mic win866_to_win1251 syn keyword sqlFunction contained win_to_utf8 xideq xideqint4 xidin xidneq xidneqint4 xidout xidrecv syn keyword sqlFunction contained xidsend xml xml_in xml_is_well_formed xml_is_well_formed_content syn keyword sqlFunction contained xml_is_well_formed_document xml_out xml_recv xml_send xmlagg syn keyword sqlFunction contained xmlcomment xmlconcat2 xmlexists xmlvalidate xpath xpath_exists " Extensions names syn keyword sqlConstant contained address_standardizer address_standardizer_data_us adminpack syn keyword sqlConstant contained amcheck autoinc bloom btree_gin btree_gist chkpass citext cube syn keyword sqlConstant contained dblink dict_int dict_xsyn earthdistance file_fdw fuzzystrmatch hstore syn keyword sqlConstant contained hstore_plperl hstore_plperlu hstore_plpython3u insert_username syn keyword sqlConstant contained intagg intarray isn lo ltree ltree_plpython3u moddatetime syn keyword sqlConstant contained pageinspect pg_buffercache pg_freespacemap pg_prewarm pg_stat_statements syn keyword sqlConstant contained pg_trgm pg_visibility pgcrypto pgrouting pgrowlocks pgstattuple syn keyword sqlConstant contained pgtap pldbgapi plperl plperlu plpgsql plpython3u pltcl pltclu syn keyword sqlConstant contained postgis postgis_sfcgal postgis_tiger_geocoder postgis_topology syn keyword sqlConstant contained postgres_fdw refint seg sslinfo tablefunc tcn timetravel tsm_system_rows syn keyword sqlConstant contained tsm_system_time unaccent xml2 " Legacy extensions names syn keyword sqlConstant contained hstore_plpython2u hstore_plpythonu ltree_plpython2u syn keyword sqlConstant contained ltree_plpythonu plpython2u plpythonu " Extension: refint (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'refint') == -1 syn keyword sqlFunction contained check_foreign_key check_primary_key endif " refint " Extension: postgis (v2.4.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'postgis') == -1 syn keyword sqlFunction contained addauth addgeometrycolumn syn keyword sqlFunction contained addoverviewconstraints addrasterconstraints box box2d syn keyword sqlFunction contained box2d_in box2d_out box2df_in syn keyword sqlFunction contained box2df_out box3d box3d_in box3d_out syn keyword sqlFunction contained box3dtobox bytea checkauth checkauthtrigger syn keyword sqlFunction contained contains_2d disablelongtransactions syn keyword sqlFunction contained dropgeometrycolumn dropgeometrytable syn keyword sqlFunction contained dropoverviewconstraints droprasterconstraints syn keyword sqlFunction contained enablelongtransactions equals find_srid syn keyword sqlFunction contained geog_brin_inclusion_add_value geography geography_analyze syn keyword sqlFunction contained geography_cmp geography_distance_knn geography_eq syn keyword sqlFunction contained geography_ge geography_gist_compress syn keyword sqlFunction contained geography_gist_consistent geography_gist_decompress syn keyword sqlFunction contained geography_gist_distance geography_gist_penalty syn keyword sqlFunction contained geography_gist_picksplit geography_gist_same syn keyword sqlFunction contained geography_gist_union geography_gt geography_in syn keyword sqlFunction contained geography_le geography_lt geography_out syn keyword sqlFunction contained geography_overlaps geography_recv syn keyword sqlFunction contained geography_send geography_typmod_in geography_typmod_out syn keyword sqlFunction contained geom2d_brin_inclusion_add_value syn keyword sqlFunction contained geom3d_brin_inclusion_add_value geom4d_brin_inclusion_add_value syn keyword sqlFunction contained geometry geometry_above geometry_analyze syn keyword sqlFunction contained geometry_below geometry_cmp syn keyword sqlFunction contained geometry_contained_by_raster geometry_contains syn keyword sqlFunction contained geometry_distance_box geometry_distance_centroid syn keyword sqlFunction contained geometry_distance_centroid_nd geometry_distance_cpa syn keyword sqlFunction contained geometry_eq geometry_ge geometry_gist_compress_2d syn keyword sqlFunction contained geometry_gist_compress_nd geometry_gist_consistent_2d syn keyword sqlFunction contained geometry_gist_consistent_nd syn keyword sqlFunction contained geometry_gist_decompress_2d geometry_gist_decompress_nd syn keyword sqlFunction contained geometry_gist_distance_2d geometry_gist_distance_nd syn keyword sqlFunction contained geometry_gist_penalty_2d geometry_gist_penalty_nd syn keyword sqlFunction contained geometry_gist_picksplit_2d geometry_gist_picksplit_nd syn keyword sqlFunction contained geometry_gist_same_2d geometry_gist_same_nd syn keyword sqlFunction contained geometry_gist_union_2d geometry_gist_union_nd syn keyword sqlFunction contained geometry_gt geometry_in geometry_le syn keyword sqlFunction contained geometry_left geometry_lt geometry_out syn keyword sqlFunction contained geometry_overabove geometry_overbelow syn keyword sqlFunction contained geometry_overlaps geometry_overlaps_nd geometry_overleft syn keyword sqlFunction contained geometry_overright geometry_raster_contain syn keyword sqlFunction contained geometry_raster_overlap geometry_recv syn keyword sqlFunction contained geometry_right geometry_same geometry_send syn keyword sqlFunction contained geometry_typmod_in geometry_typmod_out geometry_within syn keyword sqlFunction contained geometrytype geomfromewkb geomfromewkt syn keyword sqlFunction contained get_proj4_from_srid gettransactionid gidx_in syn keyword sqlFunction contained gidx_out gserialized_gist_joinsel_2d syn keyword sqlFunction contained gserialized_gist_joinsel_nd gserialized_gist_sel_2d syn keyword sqlFunction contained gserialized_gist_sel_nd is_contained_2d syn keyword sqlFunction contained lockrow longtransactionsenabled overlaps_2d syn keyword sqlFunction contained overlaps_geog overlaps_nd path pgis_abs_in syn keyword sqlFunction contained pgis_abs_out pgis_asgeobuf_finalfn syn keyword sqlFunction contained pgis_asgeobuf_transfn pgis_asmvt_finalfn syn keyword sqlFunction contained pgis_asmvt_transfn pgis_geometry_accum_finalfn syn keyword sqlFunction contained pgis_geometry_accum_transfn syn keyword sqlFunction contained pgis_geometry_clusterintersecting_finalfn pgis_geometry_clusterwithin_finalfn syn keyword sqlFunction contained pgis_geometry_collect_finalfn syn keyword sqlFunction contained pgis_geometry_makeline_finalfn pgis_geometry_polygonize_finalfn syn keyword sqlFunction contained pgis_geometry_union_finalfn point polygon syn keyword sqlFunction contained populate_geometry_columns postgis_addbbox syn keyword sqlFunction contained postgis_cache_bbox postgis_constraint_dims syn keyword sqlFunction contained postgis_constraint_srid postgis_constraint_type postgis_dropbbox syn keyword sqlFunction contained postgis_full_version postgis_gdal_version syn keyword sqlFunction contained postgis_geos_version postgis_getbbox syn keyword sqlFunction contained postgis_hasbbox postgis_lib_build_date postgis_lib_version syn keyword sqlFunction contained postgis_libjson_version syn keyword sqlFunction contained postgis_liblwgeom_version postgis_libprotobuf_version syn keyword sqlFunction contained postgis_libxml_version postgis_noop postgis_proj_version syn keyword sqlFunction contained postgis_raster_lib_build_date syn keyword sqlFunction contained postgis_raster_lib_version postgis_raster_scripts_installed syn keyword sqlFunction contained postgis_scripts_build_date postgis_scripts_installed syn keyword sqlFunction contained postgis_scripts_released postgis_svn_version syn keyword sqlFunction contained postgis_transform_geometry postgis_type_name syn keyword sqlFunction contained postgis_typmod_dims postgis_typmod_srid syn keyword sqlFunction contained postgis_typmod_type postgis_version raster_above syn keyword sqlFunction contained raster_below raster_contain raster_contained syn keyword sqlFunction contained raster_contained_by_geometry raster_eq syn keyword sqlFunction contained raster_geometry_contain raster_geometry_overlap syn keyword sqlFunction contained raster_hash raster_in raster_left raster_out syn keyword sqlFunction contained raster_overabove raster_overbelow syn keyword sqlFunction contained raster_overlap raster_overleft raster_overright syn keyword sqlFunction contained raster_right raster_same spheroid_in syn keyword sqlFunction contained spheroid_out st_3dclosestpoint st_3ddfullywithin syn keyword sqlFunction contained st_3ddistance st_3ddwithin st_3dextent syn keyword sqlFunction contained st_3dintersects st_3dlength st_3dlength_spheroid syn keyword sqlFunction contained st_3dlongestline st_3dmakebox syn keyword sqlFunction contained st_3dmaxdistance st_3dperimeter st_3dshortestline syn keyword sqlFunction contained st_accum st_addband st_addmeasure syn keyword sqlFunction contained st_addpoint st_affine st_approxcount syn keyword sqlFunction contained st_approxhistogram st_approxquantile st_approxsummarystats syn keyword sqlFunction contained st_area st_area2d st_asbinary syn keyword sqlFunction contained st_asencodedpolyline st_asewkb st_asewkt syn keyword sqlFunction contained st_asgdalraster st_asgeobuf st_asgeojson syn keyword sqlFunction contained st_asgml st_ashexewkb st_asjpeg st_askml syn keyword sqlFunction contained st_aslatlontext st_asmvt st_asmvtgeom syn keyword sqlFunction contained st_aspect st_aspng st_asraster st_assvg syn keyword sqlFunction contained st_astext st_astiff st_astwkb st_asx3d syn keyword sqlFunction contained st_azimuth st_band st_bandisnodata syn keyword sqlFunction contained st_bandmetadata st_bandnodatavalue st_bandpath syn keyword sqlFunction contained st_bandpixeltype st_bdmpolyfromtext syn keyword sqlFunction contained st_bdpolyfromtext st_boundary st_boundingdiagonal syn keyword sqlFunction contained st_box2dfromgeohash st_buffer st_buildarea syn keyword sqlFunction contained st_centroid st_cleangeometry st_clip syn keyword sqlFunction contained st_clipbybox2d st_closestpoint syn keyword sqlFunction contained st_closestpointofapproach st_clusterdbscan syn keyword sqlFunction contained st_clusterintersecting st_clusterkmeans st_clusterwithin syn keyword sqlFunction contained st_collect st_collectionextract syn keyword sqlFunction contained st_collectionhomogenize st_colormap st_combine_bbox syn keyword sqlFunction contained st_combinebbox st_concavehull st_contains syn keyword sqlFunction contained st_containsproperly st_convexhull st_coorddim syn keyword sqlFunction contained st_count st_countagg st_coveredby syn keyword sqlFunction contained st_covers st_cpawithin st_createoverview syn keyword sqlFunction contained st_crosses st_curvetoline st_delaunaytriangles syn keyword sqlFunction contained st_dfullywithin st_difference st_dimension syn keyword sqlFunction contained st_disjoint st_distance st_distance_sphere syn keyword sqlFunction contained st_distance_spheroid st_distancecpa syn keyword sqlFunction contained st_distancesphere st_distancespheroid st_distinct4ma syn keyword sqlFunction contained st_dump st_dumpaspolygons st_dumppoints syn keyword sqlFunction contained st_dumprings st_dumpvalues st_dwithin syn keyword sqlFunction contained st_endpoint st_envelope st_equals syn keyword sqlFunction contained st_estimated_extent st_estimatedextent st_expand syn keyword sqlFunction contained st_extent st_exteriorring st_find_extent syn keyword sqlFunction contained st_findextent st_flipcoordinates st_force2d syn keyword sqlFunction contained st_force3d st_force3dm st_force3dz syn keyword sqlFunction contained st_force4d st_force_2d st_force_3d syn keyword sqlFunction contained st_force_3dm st_force_3dz st_force_4d syn keyword sqlFunction contained st_force_collection st_forcecollection st_forcecurve syn keyword sqlFunction contained st_forcepolygonccw st_forcepolygoncw syn keyword sqlFunction contained st_forcerhr st_forcesfs st_frechetdistance syn keyword sqlFunction contained st_fromgdalraster st_gdaldrivers st_generatepoints syn keyword sqlFunction contained st_geogfromtext st_geogfromwkb syn keyword sqlFunction contained st_geographyfromtext st_geohash st_geomcollfromtext syn keyword sqlFunction contained st_geomcollfromwkb st_geometricmedian syn keyword sqlFunction contained st_geometryfromtext st_geometryn st_geometrytype syn keyword sqlFunction contained st_geomfromewkb st_geomfromewkt st_geomfromgeohash syn keyword sqlFunction contained st_geomfromgeojson st_geomfromgml syn keyword sqlFunction contained st_geomfromkml st_geomfromtext st_geomfromtwkb syn keyword sqlFunction contained st_geomfromwkb st_georeference st_geotransform syn keyword sqlFunction contained st_gmltosql st_hasarc st_hasnoband syn keyword sqlFunction contained st_hausdorffdistance st_height st_hillshade syn keyword sqlFunction contained st_histogram st_interiorringn syn keyword sqlFunction contained st_interpolatepoint st_intersection st_intersects syn keyword sqlFunction contained st_invdistweight4ma st_isclosed st_iscollection syn keyword sqlFunction contained st_iscoveragetile st_isempty st_ispolygonccw syn keyword sqlFunction contained st_ispolygoncw st_isring st_issimple syn keyword sqlFunction contained st_isvalid st_isvaliddetail st_isvalidreason syn keyword sqlFunction contained st_isvalidtrajectory st_length st_length2d syn keyword sqlFunction contained st_length2d_spheroid st_length2dspheroid syn keyword sqlFunction contained st_length_spheroid st_lengthspheroid syn keyword sqlFunction contained st_line_interpolate_point st_line_locate_point syn keyword sqlFunction contained st_line_substring st_linecrossingdirection syn keyword sqlFunction contained st_linefromencodedpolyline st_linefrommultipoint syn keyword sqlFunction contained st_linefromtext st_linefromwkb st_lineinterpolatepoint syn keyword sqlFunction contained st_linelocatepoint st_linemerge syn keyword sqlFunction contained st_linestringfromwkb st_linesubstring st_linetocurve syn keyword sqlFunction contained st_locate_along_measure st_locate_between_measures syn keyword sqlFunction contained st_locatealong st_locatebetween syn keyword sqlFunction contained st_locatebetweenelevations st_longestline st_m syn keyword sqlFunction contained st_makebox2d st_makeemptycoverage st_makeemptyraster syn keyword sqlFunction contained st_makeenvelope st_makeline st_makepoint syn keyword sqlFunction contained st_makepointm st_makepolygon syn keyword sqlFunction contained st_makevalid st_mapalgebra st_mapalgebraexpr syn keyword sqlFunction contained st_mapalgebrafct st_mapalgebrafctngb st_max4ma syn keyword sqlFunction contained st_maxdistance st_mean4ma st_mem_size syn keyword sqlFunction contained st_memcollect st_memsize st_memunion syn keyword sqlFunction contained st_metadata st_min4ma st_minconvexhull syn keyword sqlFunction contained st_mindist4ma st_minimumboundingcircle syn keyword sqlFunction contained st_minimumboundingradius st_minimumclearance syn keyword sqlFunction contained st_minimumclearanceline st_minpossiblevalue st_mlinefromtext syn keyword sqlFunction contained st_mlinefromwkb st_mpointfromtext syn keyword sqlFunction contained st_mpointfromwkb st_mpolyfromtext st_mpolyfromwkb syn keyword sqlFunction contained st_multi st_multilinefromwkb syn keyword sqlFunction contained st_multilinestringfromtext st_multipointfromtext st_multipointfromwkb syn keyword sqlFunction contained st_multipolyfromwkb st_multipolygonfromtext syn keyword sqlFunction contained st_ndims st_nearestvalue st_neighborhood syn keyword sqlFunction contained st_node st_normalize syn keyword sqlFunction contained st_notsamealignmentreason st_npoints st_nrings st_numbands syn keyword sqlFunction contained st_numgeometries st_numinteriorring syn keyword sqlFunction contained st_numinteriorrings st_numpatches st_numpoints syn keyword sqlFunction contained st_offsetcurve st_orderingequals st_overlaps syn keyword sqlFunction contained st_patchn st_perimeter st_perimeter2d syn keyword sqlFunction contained st_pixelascentroid st_pixelascentroids syn keyword sqlFunction contained st_pixelaspoint st_pixelaspoints st_pixelaspolygon syn keyword sqlFunction contained st_pixelaspolygons st_pixelheight syn keyword sqlFunction contained st_pixelofvalue st_pixelwidth st_point syn keyword sqlFunction contained st_point_inside_circle st_pointfromgeohash st_pointfromtext syn keyword sqlFunction contained st_pointfromwkb st_pointinsidecircle syn keyword sqlFunction contained st_pointn st_pointonsurface st_points syn keyword sqlFunction contained st_polyfromtext st_polyfromwkb st_polygon syn keyword sqlFunction contained st_polygonfromtext st_polygonfromwkb st_polygonize syn keyword sqlFunction contained st_project st_quantile st_range4ma syn keyword sqlFunction contained st_rastertoworldcoord st_rastertoworldcoordx syn keyword sqlFunction contained st_rastertoworldcoordy st_reclass st_relate syn keyword sqlFunction contained st_relatematch st_removepoint syn keyword sqlFunction contained st_removerepeatedpoints st_resample st_rescale st_resize syn keyword sqlFunction contained st_reskew st_retile st_reverse syn keyword sqlFunction contained st_rotate st_rotatex st_rotatey st_rotatez syn keyword sqlFunction contained st_rotation st_roughness st_samealignment syn keyword sqlFunction contained st_scale st_scalex st_scaley syn keyword sqlFunction contained st_segmentize st_setbandisnodata st_setbandnodatavalue syn keyword sqlFunction contained st_seteffectivearea st_setgeoreference syn keyword sqlFunction contained st_setgeotransform st_setpoint st_setrotation syn keyword sqlFunction contained st_setscale st_setskew st_setsrid syn keyword sqlFunction contained st_setupperleft st_setvalue st_setvalues syn keyword sqlFunction contained st_sharedpaths st_shift_longitude st_shiftlongitude syn keyword sqlFunction contained st_shortestline st_simplify syn keyword sqlFunction contained st_simplifypreservetopology st_simplifyvw st_skewx syn keyword sqlFunction contained st_skewy st_slope st_snap st_snaptogrid syn keyword sqlFunction contained st_split st_srid st_startpoint syn keyword sqlFunction contained st_stddev4ma st_subdivide st_sum4ma st_summary syn keyword sqlFunction contained st_summarystats st_summarystatsagg syn keyword sqlFunction contained st_swapordinates st_symdifference st_symmetricdifference syn keyword sqlFunction contained st_tile st_touches st_tpi syn keyword sqlFunction contained st_transform st_translate st_transscale st_tri syn keyword sqlFunction contained st_unaryunion st_union st_upperleftx syn keyword sqlFunction contained st_upperlefty st_value st_valuecount syn keyword sqlFunction contained st_valuepercent st_voronoilines st_voronoipolygons syn keyword sqlFunction contained st_width st_within st_wkbtosql syn keyword sqlFunction contained st_wkttosql st_worldtorastercoord syn keyword sqlFunction contained st_worldtorastercoordx st_worldtorastercoordy st_wrapx st_x syn keyword sqlFunction contained st_xmax st_xmin st_y st_ymax syn keyword sqlFunction contained st_ymin st_z st_zmax st_zmflag syn keyword sqlFunction contained st_zmin text unlockrows updategeometrysrid syn keyword sqlFunction contained updaterastersrid syn keyword sqlTable contained spatial_ref_sys syn keyword sqlType contained addbandarg agg_count agg_samealignment syn keyword sqlType contained box2d box2df box3d geography syn keyword sqlType contained geometry geometry_dump geomval gidx syn keyword sqlType contained pgis_abs rastbandarg raster reclassarg syn keyword sqlType contained spheroid summarystats unionarg syn keyword sqlType contained valid_detail syn keyword sqlView contained geography_columns geometry_columns syn keyword sqlView contained raster_columns raster_overviews endif " postgis " Extension: unaccent (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'unaccent') == -1 syn keyword sqlFunction contained unaccent unaccent_init unaccent_lexize endif " unaccent " Extension: btree_gin (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'btree_gin') == -1 syn keyword sqlFunction contained gin_btree_consistent syn keyword sqlFunction contained gin_compare_prefix_anyenum gin_compare_prefix_bit syn keyword sqlFunction contained gin_compare_prefix_bytea gin_compare_prefix_char syn keyword sqlFunction contained gin_compare_prefix_cidr gin_compare_prefix_date syn keyword sqlFunction contained gin_compare_prefix_float4 gin_compare_prefix_float8 syn keyword sqlFunction contained gin_compare_prefix_inet gin_compare_prefix_int2 syn keyword sqlFunction contained gin_compare_prefix_int4 gin_compare_prefix_int8 syn keyword sqlFunction contained gin_compare_prefix_interval gin_compare_prefix_macaddr syn keyword sqlFunction contained gin_compare_prefix_macaddr8 gin_compare_prefix_money syn keyword sqlFunction contained gin_compare_prefix_numeric gin_compare_prefix_oid syn keyword sqlFunction contained gin_compare_prefix_text gin_compare_prefix_time syn keyword sqlFunction contained gin_compare_prefix_timestamp syn keyword sqlFunction contained gin_compare_prefix_timestamptz gin_compare_prefix_timetz syn keyword sqlFunction contained gin_compare_prefix_varbit gin_enum_cmp syn keyword sqlFunction contained gin_extract_query_anyenum gin_extract_query_bit syn keyword sqlFunction contained gin_extract_query_bytea gin_extract_query_char syn keyword sqlFunction contained gin_extract_query_cidr gin_extract_query_date syn keyword sqlFunction contained gin_extract_query_float4 gin_extract_query_float8 syn keyword sqlFunction contained gin_extract_query_inet gin_extract_query_int2 syn keyword sqlFunction contained gin_extract_query_int4 gin_extract_query_int8 syn keyword sqlFunction contained gin_extract_query_interval gin_extract_query_macaddr syn keyword sqlFunction contained gin_extract_query_macaddr8 gin_extract_query_money syn keyword sqlFunction contained gin_extract_query_numeric gin_extract_query_oid syn keyword sqlFunction contained gin_extract_query_text gin_extract_query_time syn keyword sqlFunction contained gin_extract_query_timestamp gin_extract_query_timestamptz syn keyword sqlFunction contained gin_extract_query_timetz syn keyword sqlFunction contained gin_extract_query_varbit gin_extract_value_anyenum syn keyword sqlFunction contained gin_extract_value_bit gin_extract_value_bytea syn keyword sqlFunction contained gin_extract_value_char gin_extract_value_cidr syn keyword sqlFunction contained gin_extract_value_date gin_extract_value_float4 syn keyword sqlFunction contained gin_extract_value_float8 gin_extract_value_inet syn keyword sqlFunction contained gin_extract_value_int2 gin_extract_value_int4 syn keyword sqlFunction contained gin_extract_value_int8 gin_extract_value_interval syn keyword sqlFunction contained gin_extract_value_macaddr gin_extract_value_macaddr8 syn keyword sqlFunction contained gin_extract_value_money gin_extract_value_numeric syn keyword sqlFunction contained gin_extract_value_oid gin_extract_value_text syn keyword sqlFunction contained gin_extract_value_time gin_extract_value_timestamp syn keyword sqlFunction contained gin_extract_value_timestamptz gin_extract_value_timetz syn keyword sqlFunction contained gin_extract_value_varbit gin_numeric_cmp endif " btree_gin " Extension: plpython3u (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'plpython3u') == -1 syn keyword sqlFunction contained plpython3_call_handler plpython3_inline_handler syn keyword sqlFunction contained plpython3_validator endif " plpython3u " Extension: ltree (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'ltree') == -1 syn keyword sqlFunction contained index lca lquery_in lquery_out syn keyword sqlFunction contained lt_q_regex lt_q_rregex ltq_regex syn keyword sqlFunction contained ltq_rregex ltree2text ltree_addltree syn keyword sqlFunction contained ltree_addtext ltree_cmp ltree_compress syn keyword sqlFunction contained ltree_consistent ltree_decompress ltree_eq ltree_ge syn keyword sqlFunction contained ltree_gist_in ltree_gist_out ltree_gt syn keyword sqlFunction contained ltree_in ltree_isparent ltree_le syn keyword sqlFunction contained ltree_lt ltree_ne ltree_out ltree_penalty syn keyword sqlFunction contained ltree_picksplit ltree_risparent ltree_same syn keyword sqlFunction contained ltree_textadd ltree_union ltreeparentsel syn keyword sqlFunction contained ltxtq_exec ltxtq_in ltxtq_out syn keyword sqlFunction contained ltxtq_rexec nlevel subltree subpath syn keyword sqlFunction contained text2ltree syn keyword sqlType contained lquery ltree ltree_gist ltxtquery endif " ltree " Extension: tsm_system_rows (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'tsm_system_rows') == -1 syn keyword sqlFunction contained system_rows endif " tsm_system_rows " Extension: adminpack (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'adminpack') == -1 syn keyword sqlFunction contained pg_file_length pg_file_read pg_file_rename pg_file_unlink syn keyword sqlFunction contained pg_file_write pg_logdir_ls pg_logfile_rotate endif " adminpack " Extension: dict_xsyn (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'dict_xsyn') == -1 syn keyword sqlFunction contained dxsyn_init dxsyn_lexize endif " dict_xsyn " Extension: address_standardizer (v2.4.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'address_standardizer') == -1 syn keyword sqlFunction contained parse_address standardize_address syn keyword sqlType contained stdaddr endif " address_standardizer " Extension: hstore_plperlu (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'hstore_plperlu') == -1 syn keyword sqlFunction contained hstore_to_plperlu plperlu_to_hstore endif " hstore_plperlu " Extension: xml2 (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'xml2') == -1 syn keyword sqlFunction contained xml_encode_special_chars xml_valid syn keyword sqlFunction contained xpath_bool xpath_list xpath_nodeset syn keyword sqlFunction contained xpath_number xpath_string xpath_table xslt_process endif " xml2 " Extension: hstore (v1.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'hstore') == -1 syn keyword sqlFunction contained akeys avals defined delete syn keyword sqlFunction contained each exist exists_all exists_any syn keyword sqlFunction contained fetchval ghstore_compress ghstore_consistent syn keyword sqlFunction contained ghstore_decompress ghstore_in ghstore_out syn keyword sqlFunction contained ghstore_penalty ghstore_picksplit syn keyword sqlFunction contained ghstore_same ghstore_union gin_consistent_hstore syn keyword sqlFunction contained gin_extract_hstore gin_extract_hstore_query syn keyword sqlFunction contained hs_concat hs_contained hs_contains hstore syn keyword sqlFunction contained hstore_cmp hstore_eq hstore_ge syn keyword sqlFunction contained hstore_gt hstore_hash hstore_in hstore_le syn keyword sqlFunction contained hstore_lt hstore_ne hstore_out hstore_recv syn keyword sqlFunction contained hstore_send hstore_to_array syn keyword sqlFunction contained hstore_to_json hstore_to_json_loose hstore_to_jsonb syn keyword sqlFunction contained hstore_to_jsonb_loose hstore_to_matrix syn keyword sqlFunction contained hstore_version_diag isdefined isexists syn keyword sqlFunction contained populate_record skeys slice slice_array svals syn keyword sqlFunction contained tconvert syn keyword sqlType contained ghstore hstore endif " hstore " Extension: pg_visibility (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'pg_visibility') == -1 syn keyword sqlFunction contained pg_check_frozen pg_check_visible syn keyword sqlFunction contained pg_truncate_visibility_map pg_visibility syn keyword sqlFunction contained pg_visibility_map pg_visibility_map_summary endif " pg_visibility " Extension: cube (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'cube') == -1 syn keyword sqlFunction contained cube cube_cmp cube_contained syn keyword sqlFunction contained cube_contains cube_coord cube_coord_llur syn keyword sqlFunction contained cube_dim cube_distance cube_enlarge cube_eq syn keyword sqlFunction contained cube_ge cube_gt cube_in cube_inter syn keyword sqlFunction contained cube_is_point cube_le cube_ll_coord syn keyword sqlFunction contained cube_lt cube_ne cube_out cube_overlap syn keyword sqlFunction contained cube_size cube_subset cube_union syn keyword sqlFunction contained cube_ur_coord distance_chebyshev distance_taxicab syn keyword sqlFunction contained g_cube_compress g_cube_consistent syn keyword sqlFunction contained g_cube_decompress g_cube_distance g_cube_penalty syn keyword sqlFunction contained g_cube_picksplit g_cube_same g_cube_union syn keyword sqlType contained cube endif " cube " Extension: postgis_tiger_geocoder (v2.4.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'postgis_tiger_geocoder') == -1 syn keyword sqlFunction contained count_words create_census_base_tables syn keyword sqlFunction contained cull_null diff_zip syn keyword sqlFunction contained drop_dupe_featnames_generate_script drop_indexes_generate_script syn keyword sqlFunction contained drop_nation_tables_generate_script drop_state_tables_generate_script syn keyword sqlFunction contained end_soundex geocode geocode_address syn keyword sqlFunction contained geocode_intersection geocode_location syn keyword sqlFunction contained get_geocode_setting get_last_words get_tract greatest_hn syn keyword sqlFunction contained includes_address install_geocode_settings syn keyword sqlFunction contained install_missing_indexes install_pagc_tables syn keyword sqlFunction contained interpolate_from_address is_pretype least_hn syn keyword sqlFunction contained levenshtein_ignore_case loader_generate_census_script syn keyword sqlFunction contained loader_generate_nation_script loader_generate_script syn keyword sqlFunction contained loader_load_staged_data loader_macro_replace syn keyword sqlFunction contained location_extract location_extract_countysub_exact syn keyword sqlFunction contained location_extract_countysub_fuzzy syn keyword sqlFunction contained location_extract_place_exact location_extract_place_fuzzy syn keyword sqlFunction contained missing_indexes_generate_script normalize_address syn keyword sqlFunction contained nullable_levenshtein numeric_streets_equal syn keyword sqlFunction contained pagc_normalize_address pprint_addy rate_attributes syn keyword sqlFunction contained reverse_geocode set_geocode_setting setsearchpathforinstall syn keyword sqlFunction contained state_extract topology_load_tiger utmzone syn keyword sqlFunction contained zip_range syn keyword sqlTable contained addr addrfeat bg county syn keyword sqlTable contained county_lookup countysub_lookup cousub syn keyword sqlTable contained direction_lookup edges faces featnames syn keyword sqlTable contained geocode_settings geocode_settings_default loader_lookuptables syn keyword sqlTable contained loader_platform loader_variables pagc_gaz syn keyword sqlTable contained pagc_lex pagc_rules place place_lookup syn keyword sqlTable contained secondary_unit_lookup state state_lookup syn keyword sqlTable contained street_type_lookup tabblock tract zcta5 syn keyword sqlTable contained zip_lookup zip_lookup_all zip_lookup_base syn keyword sqlTable contained zip_state zip_state_loc syn keyword sqlType contained norm_addy endif " postgis_tiger_geocoder " Extension: seg (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'seg') == -1 syn keyword sqlFunction contained gseg_compress gseg_consistent syn keyword sqlFunction contained gseg_decompress gseg_penalty gseg_picksplit syn keyword sqlFunction contained gseg_same gseg_union seg_center seg_cmp syn keyword sqlFunction contained seg_contained seg_contains seg_different syn keyword sqlFunction contained seg_ge seg_gt seg_in seg_inter syn keyword sqlFunction contained seg_le seg_left seg_lower seg_lt seg_out syn keyword sqlFunction contained seg_over_left seg_over_right seg_overlap syn keyword sqlFunction contained seg_right seg_same seg_size syn keyword sqlFunction contained seg_union seg_upper syn keyword sqlType contained seg endif " seg " Extension: intagg (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'intagg') == -1 syn keyword sqlFunction contained int_agg_final_array int_agg_state syn keyword sqlFunction contained int_array_aggregate int_array_enum endif " intagg " Extension: tcn (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'tcn') == -1 syn keyword sqlFunction contained triggered_change_notification endif " tcn " Extension: isn (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'isn') == -1 syn keyword sqlFunction contained btean13cmp btisbn13cmp btisbncmp syn keyword sqlFunction contained btismn13cmp btismncmp btissn13cmp syn keyword sqlFunction contained btissncmp btupccmp ean13_in ean13_out syn keyword sqlFunction contained hashean13 hashisbn hashisbn13 hashismn syn keyword sqlFunction contained hashismn13 hashissn hashissn13 hashupc syn keyword sqlFunction contained is_valid isbn isbn13 isbn13_in syn keyword sqlFunction contained isbn_in ismn ismn13 ismn13_in syn keyword sqlFunction contained ismn_in isn_out isn_weak isneq isnge syn keyword sqlFunction contained isngt isnle isnlt isnne issn syn keyword sqlFunction contained issn13 issn13_in issn_in make_valid syn keyword sqlFunction contained upc upc_in syn keyword sqlType contained ean13 isbn isbn13 ismn syn keyword sqlType contained ismn13 issn issn13 upc endif " isn " Extension: tsm_system_time (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'tsm_system_time') == -1 syn keyword sqlFunction contained system_time endif " tsm_system_time " Extension: lo (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'lo') == -1 syn keyword sqlFunction contained lo_manage lo_oid syn keyword sqlType contained lo endif " lo " Extension: pgrowlocks (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'pgrowlocks') == -1 syn keyword sqlFunction contained pgrowlocks endif " pgrowlocks " Extension: sslinfo (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'sslinfo') == -1 syn keyword sqlFunction contained ssl_cipher ssl_client_cert_present syn keyword sqlFunction contained ssl_client_dn ssl_client_dn_field ssl_client_serial syn keyword sqlFunction contained ssl_extension_info ssl_is_used syn keyword sqlFunction contained ssl_issuer_dn ssl_issuer_field ssl_version endif " sslinfo " Extension: pgstattuple (v1.5) if index(get(g:, 'pgsql_disabled_extensions', []), 'pgstattuple') == -1 syn keyword sqlFunction contained pg_relpages pgstatginindex syn keyword sqlFunction contained pgstathashindex pgstatindex pgstattuple syn keyword sqlFunction contained pgstattuple_approx endif " pgstattuple " Extension: chkpass (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'chkpass') == -1 syn keyword sqlFunction contained chkpass_in chkpass_out eq ne syn keyword sqlFunction contained raw syn keyword sqlType contained chkpass endif " chkpass " Extension: autoinc (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'autoinc') == -1 syn keyword sqlFunction contained autoinc endif " autoinc " Extension: address_standardizer_data_us (v2.4.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'address_standardizer_data_us') == -1 syn keyword sqlTable contained us_gaz us_lex us_rules endif " address_standardizer_data_us " Extension: hstore_plpython3u (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'hstore_plpython3u') == -1 syn keyword sqlFunction contained hstore_to_plpython3 plpython3_to_hstore endif " hstore_plpython3u " Extension: postgis_topology (v2.4.4) if index(get(g:, 'pgsql_disabled_extensions', []), 'postgis_topology') == -1 syn keyword sqlFunction contained addedge addface addnode syn keyword sqlFunction contained addtopogeometrycolumn addtosearchpath asgml syn keyword sqlFunction contained astopojson cleartopogeom syn keyword sqlFunction contained copytopology createtopogeom createtopology syn keyword sqlFunction contained droptopogeometrycolumn droptopology equals syn keyword sqlFunction contained geometry geometrytype getedgebypoint syn keyword sqlFunction contained getfacebypoint getnodebypoint syn keyword sqlFunction contained getnodeedges getringedges syn keyword sqlFunction contained gettopogeomelementarray gettopogeomelements gettopologyid syn keyword sqlFunction contained gettopologyname gettopologysrid intersects syn keyword sqlFunction contained layertrigger polygonize syn keyword sqlFunction contained populate_topology_layer postgis_topology_scripts_installed syn keyword sqlFunction contained relationtrigger st_addedgemodface syn keyword sqlFunction contained st_addedgenewfaces st_addisoedge st_addisonode syn keyword sqlFunction contained st_changeedgegeom st_createtopogeo syn keyword sqlFunction contained st_geometrytype st_getfaceedges syn keyword sqlFunction contained st_getfacegeometry st_inittopogeo st_modedgeheal syn keyword sqlFunction contained st_modedgesplit st_moveisonode syn keyword sqlFunction contained st_newedgeheal st_newedgessplit st_remedgemodface syn keyword sqlFunction contained st_remedgenewface st_remisonode syn keyword sqlFunction contained st_removeisoedge st_removeisonode st_simplify syn keyword sqlFunction contained topoelementarray_agg topoelementarray_append syn keyword sqlFunction contained topogeo_addgeometry topogeo_addlinestring syn keyword sqlFunction contained topogeo_addpoint topogeo_addpolygon syn keyword sqlFunction contained topogeom_addelement topogeom_remelement syn keyword sqlFunction contained topologysummary totopogeom validatetopology syn keyword sqlTable contained layer topology syn keyword sqlType contained getfaceedges_returntype topoelement syn keyword sqlType contained topoelementarray topogeometry syn keyword sqlType contained validatetopology_returntype endif " postgis_topology " Extension: pg_freespacemap (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'pg_freespacemap') == -1 syn keyword sqlFunction contained pg_freespace endif " pg_freespacemap " Extension: file_fdw (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'file_fdw') == -1 syn keyword sqlFunction contained file_fdw_handler file_fdw_validator endif " file_fdw " Extension: pg_buffercache (v1.3) if index(get(g:, 'pgsql_disabled_extensions', []), 'pg_buffercache') == -1 syn keyword sqlFunction contained pg_buffercache_pages syn keyword sqlView contained pg_buffercache endif " pg_buffercache " Extension: dblink (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'dblink') == -1 syn keyword sqlFunction contained dblink dblink_build_sql_delete syn keyword sqlFunction contained dblink_build_sql_insert dblink_build_sql_update syn keyword sqlFunction contained dblink_cancel_query dblink_close dblink_connect syn keyword sqlFunction contained dblink_connect_u dblink_current_query syn keyword sqlFunction contained dblink_disconnect dblink_error_message dblink_exec syn keyword sqlFunction contained dblink_fdw_validator dblink_fetch syn keyword sqlFunction contained dblink_get_connections dblink_get_notify dblink_get_pkey syn keyword sqlFunction contained dblink_get_result dblink_is_busy syn keyword sqlFunction contained dblink_open dblink_send_query syn keyword sqlType contained dblink_pkey_results endif " dblink " Extension: pg_stat_statements (v1.5) if index(get(g:, 'pgsql_disabled_extensions', []), 'pg_stat_statements') == -1 syn keyword sqlFunction contained pg_stat_statements pg_stat_statements_reset syn keyword sqlView contained pg_stat_statements endif " pg_stat_statements " Extension: insert_username (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'insert_username') == -1 syn keyword sqlFunction contained insert_username endif " insert_username " Extension: pg_prewarm (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'pg_prewarm') == -1 syn keyword sqlFunction contained pg_prewarm endif " pg_prewarm " Extension: pgtap (v0.98.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'pgtap') == -1 syn keyword sqlFunction contained is add_result alike syn keyword sqlFunction contained any_column_privs_are bag_eq bag_has bag_hasnt syn keyword sqlFunction contained bag_ne can cast_context_is casts_are syn keyword sqlFunction contained check_test cmp_ok col_default_is syn keyword sqlFunction contained col_has_check col_has_default col_hasnt_default syn keyword sqlFunction contained col_is_fk col_is_null col_is_pk syn keyword sqlFunction contained col_is_unique col_isnt_fk col_isnt_pk syn keyword sqlFunction contained col_not_null col_type_is collect_tap syn keyword sqlFunction contained column_privs_are columns_are composite_owner_is syn keyword sqlFunction contained database_privs_are db_owner_is diag syn keyword sqlFunction contained diag_test_name display_oper do_tap doesnt_imatch syn keyword sqlFunction contained doesnt_match domain_type_is domain_type_isnt syn keyword sqlFunction contained domains_are enum_has_labels enums_are syn keyword sqlFunction contained extensions_are fail fdw_privs_are syn keyword sqlFunction contained findfuncs finish fk_ok foreign_table_owner_is syn keyword sqlFunction contained foreign_tables_are function_lang_is syn keyword sqlFunction contained function_owner_is function_privs_are syn keyword sqlFunction contained function_returns functions_are groups_are has_cast syn keyword sqlFunction contained has_check has_column has_composite syn keyword sqlFunction contained has_domain has_enum has_extension has_fk syn keyword sqlFunction contained has_foreign_table has_function has_group syn keyword sqlFunction contained has_index has_language has_leftop syn keyword sqlFunction contained has_materialized_view has_opclass has_operator syn keyword sqlFunction contained has_pk has_relation has_rightop has_role syn keyword sqlFunction contained has_rule has_schema has_sequence syn keyword sqlFunction contained has_table has_tablespace has_trigger syn keyword sqlFunction contained has_type has_unique has_user has_view syn keyword sqlFunction contained hasnt_cast hasnt_column hasnt_composite syn keyword sqlFunction contained hasnt_domain hasnt_enum hasnt_extension syn keyword sqlFunction contained hasnt_fk hasnt_foreign_table hasnt_function syn keyword sqlFunction contained hasnt_group hasnt_index hasnt_language syn keyword sqlFunction contained hasnt_materialized_view hasnt_opclass hasnt_pk syn keyword sqlFunction contained hasnt_relation hasnt_role hasnt_rule syn keyword sqlFunction contained hasnt_schema hasnt_sequence hasnt_table syn keyword sqlFunction contained hasnt_tablespace hasnt_trigger hasnt_type syn keyword sqlFunction contained hasnt_user hasnt_view ialike imatches syn keyword sqlFunction contained in_todo index_is_primary index_is_type syn keyword sqlFunction contained index_is_unique index_owner_is indexes_are syn keyword sqlFunction contained is_aggregate is_clustered is_definer syn keyword sqlFunction contained is_empty is_indexed is_member_of is_strict syn keyword sqlFunction contained is_superuser isa_ok isnt syn keyword sqlFunction contained isnt_aggregate isnt_definer isnt_empty isnt_strict syn keyword sqlFunction contained isnt_superuser language_is_trusted syn keyword sqlFunction contained language_owner_is language_privs_are languages_are syn keyword sqlFunction contained lives_ok matches materialized_view_owner_is syn keyword sqlFunction contained materialized_views_are no_plan num_failed syn keyword sqlFunction contained ok opclass_owner_is opclasses_are syn keyword sqlFunction contained operators_are os_name pass performs_ok syn keyword sqlFunction contained performs_within pg_version pg_version_num syn keyword sqlFunction contained pgtap_version plan relation_owner_is syn keyword sqlFunction contained results_eq results_ne roles_are row_eq syn keyword sqlFunction contained rule_is_instead rule_is_on rules_are syn keyword sqlFunction contained runtests schema_owner_is schema_privs_are syn keyword sqlFunction contained schemas_are sequence_owner_is syn keyword sqlFunction contained sequence_privs_are sequences_are server_privs_are set_eq syn keyword sqlFunction contained set_has set_hasnt set_ne skip syn keyword sqlFunction contained table_owner_is table_privs_are tables_are syn keyword sqlFunction contained tablespace_owner_is tablespace_privs_are syn keyword sqlFunction contained tablespaces_are throws_ilike throws_imatching syn keyword sqlFunction contained throws_like throws_matching throws_ok syn keyword sqlFunction contained todo todo_end todo_start trigger_is syn keyword sqlFunction contained triggers_are type_owner_is types_are syn keyword sqlFunction contained unalike unialike users_are view_owner_is syn keyword sqlFunction contained views_are volatility_is syn keyword sqlView contained pg_all_foreign_keys tap_funky endif " pgtap " Extension: earthdistance (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'earthdistance') == -1 syn keyword sqlFunction contained earth earth_box earth_distance syn keyword sqlFunction contained gc_to_sec geo_distance latitude ll_to_earth syn keyword sqlFunction contained longitude sec_to_gc syn keyword sqlType contained earth endif " earthdistance " Extension: uuid-ossp (v1.1) if index(get(g:, 'pgsql_disabled_extensions', []), 'uuid-ossp') == -1 syn keyword sqlFunction contained uuid_generate_v1 uuid_generate_v1mc syn keyword sqlFunction contained uuid_generate_v3 uuid_generate_v4 uuid_generate_v5 syn keyword sqlFunction contained uuid_nil uuid_ns_dns uuid_ns_oid syn keyword sqlFunction contained uuid_ns_url uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) if index(get(g:, 'pgsql_disabled_extensions', []), 'plperlu') == -1 syn keyword sqlFunction contained plperlu_call_handler plperlu_inline_handler syn keyword sqlFunction contained plperlu_validator endif " plperlu " Extension: intarray (v1.2) if index(get(g:, 'pgsql_disabled_extensions', []), 'intarray') == -1 syn keyword sqlFunction contained boolop bq= -.aude ty) iie tyeywocompress e tyey_consistenyword sqlFunction contained boolop bq= -.aun keyword -.aun_penalty -.aution contained ltree_picksplit ltree_risp -.aun keywo -.abi 'seg') == contained ltree_picksplit ltree_risp -.abi 'secompress e tyebi 'onsistent styebi 'n contained g_cube_decompress g_cube_distance tyebi 'n_penalty -.abi 'eyword -.abi 'ord sqlFunction contained cube_size cube_s syn t4'secompress esyn t4'eyworforinsted isnt_aggregate isnt_definer isnt_emf_sys idxtained plkeyw_typetion contained in_todo index_is_primaryned plkpush -1 syn ed plkpush typesyn qlFunction contained xpath_bool xpath_liyn qlFap yword yn qlFaord s typeseyworqlFunction contained ltq_rregex ltree2texrintarraso keso k_asceso k_desFunction contained uuid_generate_v1 uup -1 sis_tsyn keyword sqlFunction contained-.abi 'gwor int8 syFunction contkeywoon contained instrgmalidator endif " file_fdw " Extension: pg_buffercache (v1.3) iftrgm(get(g:, 'pgsql_disabled_extensions', []), 'btree_timestamptz rgma sqlFunction contairgm 'pgsql_disabled_extensions', []), 'btreeirgm'secompress esyeirgm'ntaiyn keyword sqlFunction contained gseg_compress irgm'sestent irgm'secompressd sqlFunction contained gseg_compress irgm'onsistent irgm'oword sqlFirgm'ord irgm' keyword sqlFunction contained boolop bq=irgm'n keywordirgm'n_penalty irgm'tion contained ltree_picksplit ltree_risp irgm'ame seg_t_immd sqhlFuimmd unction contained uuid_generate_v1 uuphlFu rgmasmmdlarghstsmmdlarghs'oworunction contained uuid_generate_v1 uupmmdlarghs'rrantai_pmmdlarghsunction contained uuid_generate_v1 uuntai_pmmdlarghs'sesmutler 'rrantai_pmmdlarghs'owor'sesmutler 'rrunction contained uuid_generate_v1 uuntai_pmmdlarghs'owor'rrantai_pmmdlarghs'rrunction contained d sqlTable contairgm == -1 synirgm ite pg_logdir_ls pi raster_rotate endif " adminpack " Extension: dict_xsyn (v1.0) if iidex(get(g:, 'pgsql_disabled_extensions', []), 'dide if iid') =ide if i syn keyword sqlFuniunaccent unaccenamare hantained chkpass endif " chkpass " Extension: autoinc (v1.0) mare h index(get(g:, 'pgsql_disabled_extensions', [])finer _are ha])finer _sqlFun_are hsyn keywormare haccent unaccent_init ustesults endif " dblink " Extension: pg_stat_statements (v1.5)t_init ustex(get(g:, 'pgsql_disabled_extensions', []), 'asyn keyompokeywor n cont'oworunction contained uuid_generate_v1 uu syn keywor g])fbiaude ty) iie])fbiaudecompressd sqlFunction contained gseg_compress ])fbiaun keyword])fbiaununction contained gseg_decompress gseg_penalty])fbiaueyword])fbiaun keywo])fbpsyn 'seg') == contained ltree_picksplit ltree_risp ])fbpsyn 'secompress e])fbn co'seg') == contained ltree_picksplit ltree_risp ])fbn co'secompress e])fbn co'n contained g_cube_decompress g_cube_distance])fbn co'n_penalty ])fbn co'eyword])fbn co'ord sqlFunction contained cube_size cube_s bser hhude ty) iie])fr hhudecompressd sqlFunction contained gseg_compress ])f'asyn keyd sqlF])f'asynrd sqlF])f'asynn contained g_cube_decompress g_cube_distance])f'asynn_penalty ])f'asyneyword])f'asynord sqlFunction contained cube_size cube_s bsempokede ty) iie])fmpokedecompressd sqlFunction contained gseg_compress ])fmpokeyword sqlF])fmpokerd sqlF])fmpoken contained g_cube_decompress g_cube_distance])fmpoken_penalty ])fmpoketion contained ltree_picksplit ltree_risp ])fmpoken keywo])fonsistent btd sqlFueg') == contained ltree_picksplit ltree_risp ])f sqlFuecompress e])f sqlFrd sqlF])f sqlFn contained g_cube_decompress g_cube_distance])f sqlFn_penalty ])f sqlFtion contained ltree_picksplit ltree_risp ])f sqlFn keywo])fn cont'ueg') == contained ltree_picksplit ltree_risp ])fn cont'uecompress e])fn cont'oword sqlF])fn cont'rd sqlFunction contained dblink_fdw_validaF])fn cont'n keyword])fn cont'nunction contained gseg_decompress gseg_penalty])fn cont'eyword])fn cont'n keywo])fn con8'ueg') == contained ltree_picksplit ltree_risp ])fn con8'uecompress e])fn con8n keyword sqlFunction contained earth earth_box])fn con8nrd sqlF])fn con8nn contained g_cube_decompress g_cube_distance])fn con8nn_penalty ])fn con8neyword])fn con8nord sqlFunction contained cube_size cube_s bseubeaude ty) iie])fubeaudecompressd sqlFunction contained gseg_compress ])fubeaun keyword])fubeaun_penalty ])fubeaution contained ltree_picksplit ltree_risp ])fubeaun keywo])f syn'ueg') == contained ltree_picksplit ltree_risp ])f syn'uecompress e])f syn'oword sqlF])f syn'rd sqlFunction contained dblink_fdw_validaF])f syn'n keyword])fubyn'n_penalty ])fubyn'tion contained ltree_picksplit ltree_risp ])fubyn'n keywo])f syt'ueg') == contained ltree_picksplit ltree_risp ])fn t4'secompress e])fn t4'oword sqlF])f syt'rd sqlFunction contained dblink_fdw_validaF])f syt'n keyword])fubyt'nunction contained gseg_decompress gseg_penalty])fubyt'eyword])fubyt'n keywo])f sy8'ueg') == contained ltree_picksplit ltree_risp ])f sy8'uecompress e])fn t8n keyword sqlFunction contained earth earth_box])fn t8nrd sqlF])fn t8nn keyword])fuby8'nunction contained gseg_decompress gseg_penalty])fuby8'eyword])fuby8'n keywo])f syv'ueg') == contained ltree_picksplit ltree_risp ])f syv'uecompress e])fn tvy_consistenyword sqlFunction contained boolop bq=])fn tvy_word sqlF])f syv'rd sqlFunction contained dblink_fdw_validaF])f syvnn keyword])fubyv'n_penalty ])fubyv'tion contained ltree_picksplit ltree_risp ])fubyv'n keywo])fontai8'ueg') == contained ltree_picksplit ltree_risp ])fontai8'uecompress e])fontai8'rd sqlF])fontai8'n contained g_cube_decompress g_cube_distance])fontai8'n_penalty ])fontai8'tion contained ltree_picksplit ltree_risp ])fontai8'n keywo])fontaiude ty) iie])fontaiudecompressd sqlFunction contained gseg_compress ])fontaiurd sqlF])fontai'n contained g_cube_decompress g_cube_distance])fontai'n_penalty ])fontai'eyword])fontai'ord sqlFunction contained cube_size cube_s bsed sqlFunce ty) iie])fd sqlFuncecompressd sqlFunction contained gseg_compress ])fd sqlFunn keyword])fd sqlFunnunction contained gseg_decompress gseg_penalty])fn keywordyword])fn keyworn keywo])foid'ueg') == contained ltree_picksplit ltree_risp ])foid'uecompress e])foid' keyword sqlFunction contained earth earth_box])foid'rd sqlF])foid'n keyword])foid'nunction contained gseg_decompress gseg_penalty])foid'dyword])foid'n keywo])fsyn kueg') == contained ltree_picksplit ltree_risp ])fsyn kuecompress e])fsyn kn contained g_cube_decompress g_cube_distance])fsyn kn_penalty ])fsyn kdyword])fsyn kord sqlFunction contained cube_size cube_s bsesqlFnce ty) iie])fsqlFncecompressd sqlFunction contained gseg_compress ])fsqlFn_word sqlF])fsqlFnrd sqlF])fsqlFnn contained g_cube_decompress g_cube_distance])fsqlFnn_penalty ])fsqlFntion contained ltree_picksplit ltree_risp ])fsqlFnn keywo])fsned gnce ty) iie])fsqlF gncecompressd sqlFunction contained gseg_compress ])fssnce ty) iie])fssncecompressd sqlFunction contained gseg_compress ])fssn_word sqlF])fssnrd sqlF])fssnn contained g_cube_decompress g_cube_distance])fssnn_penalty ])fsskdyword])fsskord sqlFunction contained cube_size cube_s bsess gnce ty) iie])fss gncecompressd sqlFunction contained gseg_compress ])fss gn_word sqlF])f_oid ce ty) iie])f_oid cecompressd sqlFunction contained gseg_compress ])f_oid rd sqlF])f_oid n contained g_cube_decompress g_cube_distance])f_oid n_penalty ])f_oid dyword])f_oid ord sqlFunction contained cube_size cube_s bsevarfonsistent btdvarfrd sqlF])reeion16word sqlFunction contained isbn_in ismn F])reeion16wsyn F])reeion32'ord ])reeion32' keyword sqlFunction contained boolop bq=])reeion4'ord ])reeion4' keyword sqlFunction contained boolop bq=])reeion8'ord ])reeion8wsyn F])reeiondvarford sqlFunction contained isbn_in ismn F])reeiondvarf3_in syn'owor n t4'owor n t8n keyunction contained xpath_bool xpath_liyn ontai'owor oid' key sqlFn_worunction contained todo todo_end todo_ss' key ss gn_worunction contained d sqlTable conta])reeion16d ])reeion32d ])reeion4unction contained d sqlTable conta])reeion8 F])reeiondvaron contained gin_snaccent unaccen1 in== -tesult6or endif " file_fdw " Extension: pg_buffercache (v1.3) in== -t index(get(g:, 'pgsql_disabled_extensions', []rin_lF apyn kel ]rin_pyn ketem= contained ltree_picksplit ltree_risp]rin_pyn k has_]rin_revqlFusyn k])foelFunction contained col_not_null col_typ])fpyn ketem=p])fpyn ksqlVs fsmfpyn kll cw con sqlFunction contained isbn_in ismn Fget_awfpyn esyeleafpyn ketem= contained ltree_picksplit ltree_rispgin_lF apyn kel gin_pyn kopaqu kel atgifbiaqlFusl_iscontained ltree_picksplit ltree_rispatgiflF apyn kel atgifpyn ketem= contained ltree_picksplit ltree_rispatgifpyn ksqlVs atgifpyn k has_telFupyn ketemion c= contained ltree_picksplit ltree_rispaelFupyn ketemrd sqe_are hsumd sqe_aeldn contained plperlu_call_handler plperlgstatt us_gtion c== -1 s in== -t contained uuid_tcurl uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) itcurex(get(g:, 'pgsql_disabled_extensions', []), 'ptcuru') == -1 s syn keywotcurqlType contained stdaddr enif " address_standardizer " Extension: hstore_plperlu (v1.0) if index(getg:, 'pgsql_disabled_extensions', []), 'hstore_plperlu') == -1yword syword sqlFunction contained hstoqlType containmodray tissn issn13 upc endif " isn " Extension: tsm_system_time (v1.0)modray tissg:, 'pgsql_disabled_extensions', []), 'hstoremodray tissunction cmodray tissuction containelocastrnt_imad earth endif " earthdistance " Extension: uuid-ossp (v1.1)elocastrnt_imx(get(g:, 'pgsql_disabled_extensions', []), 'dilFunctsqldlF aphonqldlF aphonq_antained col_has_check col_has_default caddress sypretype leaslqlTaction contained nullable_levenshtein numerlF aphonqlerate_scsyn kdrate_sunction colocastrnt_imunction containt ltre " address_standardizer_data_us " Extension: hstore_plpython3u (v1.0)nt ltre " addresf index(get(g:, 'pgsql_disabled_extensions', [rent l') == -1 d sqlType contstore_to_plpython3 plpythot_fusqlFuif "6_prewarm endif " pg_prewarm " Extension: pgtap (v0.98.0) i_fusqlFget(g:, 'pgsql_disabled_extensions', []), 'pgrow_anpatgiapegrow_aconyzegraph'pgsql_disabled_extensions', []), 'pgrow_aconyzeonqwaygrow_apspjohnath row_apspwargiarse_geocode set_geocode_setting setsearrow_articun keywtringsrrow_asyn e_geocode set_geocode_setting setsearrow_asyn coey row_asyn coeyqlFunc row_bdasyn e_geocode set_geocode_setting setsearrow_bdasyn coey row_bdasyn coeyqlFunc row_bddijkstrae_geocode set_geocode_setting setsearrow_bddijkstracoey row_bddijkstracoeyqlFunction contained hstore_to_jsonb_loose row_baiynch ed sqlFnengsrrow_boykovkolmogoron contained hstore_lt hstore_ne hstorerow_brid') == r_iynch ed sqlFnengs contained hstore_lt hstore_ne hstorerow__ne ctiographerow__d sqlFunction contained copytopology createtopogeorow__d sql_arriceskeyworrow_dijkstrarrow_dijkstracoey contained copytopology createtopogeorow_dijkstracoeyqlFuncorow_dijkstraviae_geocode set_geocode_setting setsearrow_drivqlF_word sqlrow_ayer_wojringlFunslrow_aymondskarunction contained col_not_null col_typrow_anstring row_aucensiangsp row_flipword sqlFunction contained st_geometrytyperow_floydwargiarserow_f " syn nion contained ltree_picksplit ltree_risprow_f "keywo syn ow_fsoc_vrppdtnction contained has_type has_unique h ow_nt_qsyn iner s ow_nt_qsyn inkeyworrow_johnathction contained has_type has_unique h ow_kdijkstracoey row_kdijkstralFuncrow_ksunction contained col_not_null col_typrow_n keygrapherow_sqlFgrapherow_sqlFgraphfurse_geocode set_geocode_setting setsearrow_maxcontaer_itynt_imarow_maxflonction contained has_type has_unique h ow_maxflonboykovkolmogoronh ow_maxflonaymondskarunction contained col_not_null col_typrow_maxflonpushsyn keyprow_maximumcontaer_itynt_im contained tablespaces_are throws_ilike row_d sqnetblek row_tringsasrd sqlFunction contained topogeo_addpoint torow_tringstodqlFuncorow_tringstovid sqlFunction contained st_geometrytyperow_tringtonoded sqlrow_tushsyn keyprow_quot kedessd sqlFunction contained gseg_compressrow_syn ktring row_strong sqlFnengsrrow_syn Funcings contained hstore_lt hstore_ne hstorerow_ c=perow_ c=pviaword sqlFunction contained st_geometrytyperow_ c=pvia_arriceserow_ =perow_syn keyworw_syn keyl == contained ltree_picksplit ltree_risporw_sid todqlFuncorow_vrpFnedeposd sqlFunction contained gseg_compressrow_ormstringsrrow_ormstringscoey contained copytopology createtopogeorow_ormstringscoeyqlFuncorow_ormstringsdeorow_ormstringsksunction contained cd sqlTable controw__n sta) == row__n sta) ==3nction contained cd sqlTable controw_ syta) == == -1 syn usqlF contained uuid_dbgapil uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) idbgapiex(get(g:, 'pgsql_disabled_extensions', []), 'pdbg_abo k_tsqlFt 'pdbg_a"kech l') orray svals syn key_extensions', []), 'pdbg_ns',inue 'pdbg_n -1 lmpresn contained plperlu_call_handler plperlu_dbg_deposion contlu_dbg_dnctib -1keyword sqlFunction contained getfacebypoinu_dbg_Fgetb -1keyworsnu_dbg_Fgetle ykel u_dbg_Fgetdrarrd sqlFunction contained earth earth_bou_dbg_Fgetdkeckou_dbg_FgettsqlFtusl_iscontained ltree_picksplit ltree_rispu_dbg_Fgetyn keyword _dbg_oid' ebuontained tablespaces_are throws_ilike r_dbg_serd sqfr syn _dbg_setib -1keyword sqlFunction contained getfacebypoinu_dbg_ sylobalib -1keywornu_dbg_ teFusltonu_dbg_ teFulFund sqlFunction contained getfacebypoinu_dbg_waiion ib -1keywornu_dbg_waiion itsqlFtd sqlFunction contained getfacebypoinu_d-osspoid' ebuontained tablespaced sqlTable contb -1keywornfr syn e ysl_iscontained ltree_pgetfaceedges_retsqlFtel varon contai idbgapipython3 plpythotcryptoalidator endif " file_fdw " Extension: pg_buffercache (v1.3) icrypto, 'pgsql_disabled_extensions', []), 'postgis_trmor crypt detrmor decrypt, 'pgsql_disabled_extensions', []), 'decrypt_isqlFgcastencrypt encrypt_isn sqlFunction contained isbn_in ismn Fgntigedomfbn cs Fgntigedomf_oid Fgntsantained col_has_check col_has_default chmachotp_trmor_aeldn shotp_iond sqlFunction contained uuid_nil uuid_nsotp_pub_decryptsotp_pub_decryptfbn coqlFunction contained uuid_nil uuid_nsotp_pub_encrypt otp_pub_encryptfbn co otp_sym_decrypt, 'pgsql_disabled_extensions', []), 'otp_sym_decryptfbn co otp_sym_encrypt, 'pgsql_disabled_extensions', []), 'otp_sym_encryptfbn co == -1 sycryptopython3 plpython3_to_hsfcgaldif " hstore_plpython3u " Extension: postgis_topology (v2.4.4) if indesfcgalex(get(g:, 'pgsql_disabled_extensions', []), 'if indesfcgalon contained populate_topology_layer postgis_topology_s'if indesfcgalosyn keywst_3da -1wst_3ddilFunctsqate_topology_layer postgis_topology_sst_3d_address syst_3dord sqlFunction contained cube_size cube_slFunple nctimedgialaxi synFuncusqlFunn celhed synn e_geocode set_geocode_setting setsear son13 sakeson13 sinkowskision contained performs_within pg_versioor'rron ca syst_strayworskywor sqlFunction contained cube_size cube_slFu cssyn kqlFunvqsyn keyword sqlType csfcgal sqlType contaiqlF ravenif " address_standardizer " Extension: hstore_plperlu (v1.0)iqlF raven(get(g:, 'pgsql_disabled_extensions', []), 'bte)fsqlF ravenise)fsqlF ravencontained plperlu_call_handler plperlgqlF ravenc= -1 syqlF ravenccontained uuid_ns_ul uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) if inex(get(g:, 'pgsql_disabled_extensions', []), 'plperu') == -1 syn keywrd sqlFunction yn keywr_handler syn keyword s sqlType contaiExtefu contained chkpass endif " chkpass " Extension: autoinc (v1.0)iExtefu cex(get(g:, 'pgsql_disabled_extensions', []), 'ynch bogeoosskeygeoosskey2:, 'pgsql_disabled_extensions', []), 'oosskey3 'oosskey4sqlFunctigedscontained ltree_pgetfaceedges_retsxtefu c_'oosskey_2etsxtefu c_'oosskey_3nction contained cd sqlTable conttsxtefu c_'oosskey_4c= -1 sysxtefu cpython3 plpython3_tta)g_freespace endif " pg_freespacemap " Extension: file_fdw (v1.0)on3_tta)g_frex(get(g:, 'pgsql_disabled_extensions', []), 'if ita)g_frunction ynif ita)g_fru_handler syn keywif ita)g_fraccent unaccentloomeespace endif " pg_freespacemap " Extension: file_fdw (v1.0)tloom index(get(g:, 'pgsql_disabled_extensions', []l -1 s syn keytloom contained uuid_tcul uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) itcuex(get(g:, 'pgsql_disabled_extensions', []), 'ptcuu') == -1 s syn keywotcution contained isyn l uuistore_plpython3u " Extension: postgis_topology (v2.4.4) isyn ex(get(g:, 'pgsql_disabled_extensions', []), 'isyn l'isyn unctl'isyn uequence_privs_are sequences_are server_'isyn uge_'isyn ug l'isyn uatgil'isyn ulsqlF e_geocode set_geocode_setting setsear'isyn ule_'isyn ul l'isyn uword sqlFunction contained chkpass_in c'isyn usmpopurc'isyn ') =isyn 3_in=isyn recsn sqlFunction contained isbn_in ismn =isyn syn max sin regexp_contained diag_test_name display_oper do_tregexp_contacs regexp_rekeywoined diag_test_name display_oper do_tregexp_tion l')-1 sregexp_tion l')keyworrekeywoined diag_test_name display_oper do_ttion pn kestrwifcsyn icimatchyn icn1 syn keyword sqlFunction contained is hyn icregexeq hyn icregexneeywonslontained dblink_buildn keyword sqlFunisyn contained isyn ccontained uuid_nensil uuid_ns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) if-ossex(get(g:, 'pgsql_disabled_extensions', []), 'pl-ossp') == -1 syn k-osspd sqlFunction contained plperlu_call_handler plperlu_i-ossp_handler syn keywor-ossccontained uuid_ne_to_uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) ife_to_uex(get(g:, 'pgsql_disabled_extensions', []), 'ple_to_p') == -1 syn ke_to_pd sqlFunction contained plperlu_call_handler plperlu_ie_to_p_handler syn keywore_to_uncontained uuid_ne_to_2uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) ife_to_2uex(get(g:, 'pgsql_disabled_extensions', []), 'ple_to_2p') == -1 syn ke_to_2pd sqlFunction contained plperlu_call_handler plperlu_ie_to_2p_handler syn keywore_to_2rqlType contained stdaddre_to_uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0)ed stdaddre_to_u 'pgsql_disabled_extensions', []), 'hstore_plpython3u') == -1 lu_ie_to_p sqlFunction contained hstore_to_rqlType contained stdaddre_to_2uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0)ed stdaddre_to_2u 'pgsql_disabled_extensions', []), 'hstore_plpython3u') == -1 2lu_ie_to_2p sqlFunction contained hstore_to_2rqlType contain contstore_to_uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) contstore_to_uf index(get(g:, 'pgsql_disabled_extensions', [rent l') == -1 d sqlType contstore_to_rqlType contain contstore_to_2uns_x500 endif " uuid-ossp " Extension: plperlu (v1.0) contstore_to_2uf index(get(g:, 'pgsql_disabled_extensions', [rent l') == -1 2d sqlType contstore_to_2rqlTCataloglespace (g:, 'pgsql_disCatalogl 'postgis_tdms_arywo sy key_au_toriza ss npllico sy keye (g:, 'pgsql_disCatalogl 'postgis_tttribu cs syn acter_ stext_iscecotray syn usqle_uFunc (g:, 'pgsql_disCatalogl 'postgis_ext_iscecotray skeywor keywosyn acter_ _npllico s seywor keywe (g:, 'pgsql_disCatalogl 'postgis_e_is cord sqlFuFunc_e_is coop ss e_is collecile') =e_is coudt_uFunc (g:, 'pgsql_disCatalogl 'postgis_e syn k cecotray sye_is couFunc_e_cotray syp syuFunc (g:, 'pgsql_disCatalogl 'postgis_ us_g_is llecile') =rd sqlFcecotray skerd sqlFudt_uFunc domain_ (g:, 'pgsql_disCatalogl 'postgis_type tog_is wordExtens keyegn_table_ us_gwrtionroop ss (g:, 'pgsql_disCatalogl 'postgis_n_table_ us_gwrtionregn_table_lFunctiop ss n_table_lFuncts (g:, 'pgsql_disCatalogl 'postgis_n_table_asnt sep ss n_table_espace el rnt_eywoyword scatalog sy (g:, 'pgsql_disCatalogl 'postgis_ionde_is couFunc_pn sytn shot isa_ok isnot imnot imopnot improc (g:, 'pgsql_disCatalogl 'postgis_pg_a"krdef_pg_a"kribu c_pg_au_t keywors_pg_au_tid (g:, 'pgsql_disCatalogl 'postgis_pg_availsnt sion: plpeosyn keys_pg_availsnt sion: plpes_pg_r haspg_rkeyw (g:, 'pgsql_disCatalogl 'postgis_pg_ywor keyw_pg_ywnfig_pg_ywnotray s_pg_ywnsyn keywordcursors_pg_mposite_ (g:, 'pgsql_disCatalogl 'postgis_pg_dby key_ sqlFupg_dkeywordaclupg_dkon cupg_dkn contd sq(g:, 'pgsql_disCatalogl 'postgis_pg_syn kpg_sveyn keyword pg_syword sqln keiey_ sqlFw (g:, 'pgsql_disCatalogl 'postgis_pg_n_table_ us_gwrtionr_pg_n_table_lFunct_pg_n_table_keyworroFunctio(g:, 'pgsql_disCatalogl 'postgis_pg_hbakeiey_ord s_pg_ keywordfiner s_pg_ kherits_pg_ kn pqlFuo(g:, 'pgsql_disCatalogl 'postgis_pg_up syn pg_upqlFobj -tepg_upqlFobj -tflF asyn kpg_uyword(g:, 'pgsql_disCatalogl 'postgis_pg_nt_re vi_pg_ sytable pg_ sqlFuncpg_ s opclacpg_ sfamilyd(g:, 'pgsql_disCatalogl 'postgis_pg_pn kitd senskeyworroFpltempl isnot polici s_pg_policyd(g:, 'pgsql_disCatalogl 'postgis_pg_prekarens') == -1 synprekarensxact synproc synpublicokeyw_pg_publicokeywss hd(g:, 'pgsql_disCatalogl 'postgis_pg_publicokeywsespace tatt_add tatteplicokeywsorigisq(g:, 'pgsql_disCatalogl 'postgis_pg_teplicokeywsorigiss') =us_pg_teplicokeywsslots_pg_tewritd tattkeye (g:, 'pgsql_disCatalogl 'postgis_tattrd s_pg_secn keypro_secn keys_pg_sen keywopg_sen keywe (g:, 'pgsql_disCatalogl 'postgis_tat sqlFw_tat hadow_tat hdkon cupg_ hdkn contd supg_ hsecn key (g:, 'pgsql_disCatalogl 'postgis_tat ord actecity_tat ord allfiner s_pg_ ord allfespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ord archinct_pg_ ord bgwritdt_pg_ ord mposite_ (g:, 'pgsql_disCatalogl 'postgis_pg_ ord mposite__ywnflic syn keywprogsqlTavacun kpg_ keywteplicokeywkpg_ keywssy (g:, 'pgsql_disCatalogl 'postgis_tat ord subn contd supg_ ord sysfiner s_pg_ ord sysfespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ord syFunction s_pg_ ord syFiner s_pg_ ord syFespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ord wnctieceinct_pg_ ord xact allfespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ord xact sysfespace_pg_ ord xact syFunction s_pg_ ord xact syFespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ordio allfiner s_pg_ ordio allfsen keywe_pg_ ordio allfespace (g:, 'pgsql_disCatalogl 'postgis_pg_ ordio sysfiner s_pg_ ordio sysfsen keywe (g:, 'pgsql_disCatalogl 'postgis_tat ordio sysfespace_pg_ ordio syFiner s_pg_ ordio syFsen keywe (g:, 'pgsql_disCatalogl 'postgis_tat ordio syFespace_tat ordistic_tat ordistic_syw_tat orde (g:, 'pgsql_disCatalogl 'postgis_tat ubn contd supg_ ubn contd sss hupg_espace_tatespace_pri (g:, 'pgsql_disCatalogl 'postgis_tatyqlFzonq_abbrevs_tatyqlFzonq_ syt_tatywons rn_tatywyword pg_ssncecfig (g:, 'pgsql_disCatalogl 'postgis_tatysncecfig_pe etatysnqlFuetatysnkarsrd pg_ssntempl isnot Funct(g:, 'pgsql_disCatalogl 'postgis_tatusrd pg_ syFpe pqlFupg_ syFpe pqlFt_tatre vit(g:, 'pgsql_disCatalogl 'postgis_reFuncttinctcecotray ske key_e_is cogra ske key_n usqle_gra skt(g:, 'pgsql_disCatalogl 'postgis_rkey_asnt sgra ske key_udt_gra ske key_uFunc_gra ske kusqle_llecile') t(g:, 'pgsql_disCatalogl 'postgis_rkusqlekeyword n ksen keywe_osspfe =urwe_ossptionpe toptd sssl_is(g:, 'pgsql_disCatalogl 'postgis_osspction con_ossp_prk con_ossp_prtn_osspsizqlFuosspsizqlFwproeiey t(g:, 'pgsql_disCatalogl 'postgis_asnt scecotray skep syn keile') =espace_ywons rn t(g:, 'pgsql_disCatalogl 'postgis_awywordensn cont_e syn k start tr udt_n keile') =uFunc_llecile') t(g:, 'pgsql_disCatalogl 'postgis_ syFyn keydg_is wo syFpe pqlFsep ss syFpe pqlFtt(g:, 'pgsql_disCatalogl 'postgis_ord se_is couFunc_ord sn usqle_uFunc_ord sp syuFuncare viqlTywordl 'dkn (Aion cix A, summarA-1)t(g:, 'pgsql_disywordC sql 'postgis_tctecenctioywonsaed_exttdms__ hutdowxttmbiguous aliatt(g:, 'pgsql_disywordC sql 'postgis_tmbiguous syn ktmbiguous unction ktmbiguous pn sytn t(g:, 'pgsql_disywordC sql 'postgis_td plk ubn conteyword eywortFunctu syn d cepykeiey_ rnt_t(g:, 'pgsql_disywordC sql 'postgis_bwonch lwonsaed_ex already actecs bag colcoercs bag colcoconnecnowt(g:, 'pgsql_disywordC sql 'postgis_bagn_ar_add__is_qlFnnn s contaer_itytreor keyw_cte__ colfratet(g:, 'pgsql_disywordC sql 'postgis_byn acter_ colin_res otoiwordxt_isreor keyw_cwor keywomiscontai(g:, 'pgsql_disywordC sql 'postgis_becfig_eiey_ewordl 'cfigur keywoimmd _sy layeet(g:, 'pgsql_disywordC sql 'postgis_betch sy_ap d_ colexkey betch sy_sy lpd_extensch sy_unctu st(g:, 'pgsql_disywordC sql 'postgis_betostgqlFsctio cols omd t), 'oasynehutdowxt us_gcorruptis_ us_gsy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_mposite__dnctpis_mpos_is misconta ray tiss_eieldulFunflonc(g:, 'pgsql_disywordC sql 'postgis_meaduywoFynth ed dkon ceyn obj -tFuncillfexkeyc(g:, 'pgsql_disywordC sql 'postgis_meon ceyn llecile')_dkn contlassncillfexkey_meoiecay dpfe =urw db_onosticsgsy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_misk_furs_miviplpeoby_zero duplicoke aliat duplicoke syn t(g:, 'pgsql_disywordC sql 'postgis_muplicoke ursor_muplicoke mposite__muplicoke eieyt(g:, 'pgsql_disywordC sql 'postgis_muplicoke unction kmuplicoke obj -temuplicoke prekarens') == -1 t(g:, 'pgsql_disywordC sql 'postgis_muplicoke hasnt_rmuplicoke keywordy sic_ta) ==_ srivs_areet(g:, 'pgsql_disywordC sql 'postgis_yword in_eywign -1 kn apeosyn acter_ywnflic t(g:, 'pgsql_disywordC sql 'postgis_yveyn keywordwproto_pk reor kis_yx slpeoseor keyw_sywornncti usqle_sy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_sywornncti usqle_invocokeywssy lpd_ext_frue_is co sy_ colfratet(g:, 'pgsql_disywordC sql 'postgis__frudy sic_pn sytn n contanlayee__fruywordt(g:, 'pgsql_disywordC sql 'postgis__fruunction Fsen keyw_ewordl_fruincecompress_dkn contla_el rnt_eywt(g:, 'pgsql_disywordC sql 'postgis__fruinvhand_a"kribu cn contl_fruinvhand_e_is co syl_fruinvhand_e_is co uywort(g:, 'pgsql_disywordC sql 'postgis__fruinvhand_ us_g_is __fruinvhand_ us_g_is _dkn contlast(g:, 'pgsql_disywordC sql 'postgis__fruinvhand_ kn contla_eielduedessieier__fruinvhand_nctiont(g:, 'pgsql_disywordC sql 'postgis__fruinvhand_ep s_ keywo_fruinvhand_ep s_ sy (g:, 'pgsql_disywordC sql 'postgis__fruinvhand_ontang_ rnt___fruinvhand_ontang_length_ ibulFun_length (g:, 'pgsql_disywordC sql 'postgis__fruinvhand_ s_ofl_isn_tringer__fruno hasnt_s__fruep s_ sy_ colfratet(g:, 'pgsql_disywordC sql 'postgis__fru us_oflmemory__fruteply_nction__fruyword s colfratet(g:, 'pgsql_disywordC sql 'postgis__frup sy colfrate__frupooFpeny_nctionst(g:, 'pgsql_disywordC sql 'postgis__fruudExte l')n -1 execud_ext_fruudExte l')n -1 teplyt(g:, 'pgsql_disywordC sql 'postgis__fruudExte l')eskeywihhudecch sy fe =urwy colsup orreuu syn qlFwpring_sy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_volatility_oseor keyw_unction Fexecudensno ivs_ars') == -1 t(g:, 'pgsql_disywordC sql 'postgis_ion contd_always sqlFuqlFwywordt(g:, 'pgsql_disywordC sql 'postgis_heldu ursor ivquita)gdywo_isor keyw_pretl id synn lwonsaed_ex sesslpeotiss key(g:, 'pgsql_disywordC sql 'postgis_tionicd _zerofbiaunaddqlFuinFunctionctioywonsaed_exy(g:, 'pgsql_disywordC sql 'postgis_tnnple lleoke accqlTam sqon ib onch lwonsaed_exy(g:, 'pgsql_disywordC sql 'postgis_tnnple lleoke isor keyw_pretlon ib onch lwonsaed_exx500 t omdnoke sr keyw_500 t omdnoke mpos_is y(g:, 'pgsql_disywordC sql 'postgis_tner _aorruptis_tneicokr 'rFunflon_tnsulFici yn llecile')y(g:, 'pgsql_disywordC sql 'postgis_tnsulFici yn ta)rarrdsiyn ogrghs'secotray syseor keyw_ingernnctywordt(g:, 'pgsql_disywordC sql 'postgis_yn ontai'eieldulFunflon invhand_argue togn ilogarghhmt(g:, 'pgsql_disywordC sql 'postgis_ynvhand_argue togn inth_ contaunction t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_argue togn intiey_ nction kynvhand_argue togn ipowsyFunction t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_argue togn iwid) ==ucketFunction t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_au_toriza s_== -ieicaion kynvhand_bdnory tepta)n ca syinvhand_eatalog sy (g:, 'pgsql_disywordC sql 'postgis_ynvhand_syn acter_ contau ir hasinvhand_e_is coyn keiion t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_e_is coreFunctce_ynvhand_eursor yn keiion _ynvhand_eursor sy (g:, 'pgsql_disywordC sql 'postgis_ynvhand_sursor ') == invhand_ us_ite__dn keiion t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_ray tiss_e rnt__ynvhand_kn apeosyn acter_ynvhand_kn apeoocteey(g:, 'pgsql_disywordC sql 'postgis_tnvhand_kn apeosen keywotnvhand_volatility_y(g:, 'pgsql_disywordC sql 'postgis_tnvhand_unction Fyn keiion _ynvhand_gra s_ s opcon _ynvhand_gra srdt(g:, 'pgsql_disywordC sql 'postgis_ynvhand_tneicokr 'pn sytn n cont_ynvhand_locokr '== -ieicaion kynvhand_ sy (g:, 'pgsql_disywordC sql 'postgis_ynvhand_obj -tfyn keiion _ynvhand_pn sytn n cont (g:, 'pgsql_disywordC sql 'postgis_ynvhand_ keygsql_ynvhand_ iecedang_ llonqlFscyn k(g:, 'pgsql_disywordC sql 'postgis_ynvhand_ rekarens') == -1 fyn keiion _ynvhand_iecun keywynvhand_iegularFextent on t(g:, 'pgsql_disywordC sql 'postgis_ynvhand_ key_ = -ieicaion kynvhand_qlFuf_sysynn immd _claue_ (g:, 'pgsql_disywordC sql 'postgis_ynvhand_ kFuf_sysynn ta) ==_off _claue_ (g:, 'pgsql_disywordC sql 'postgis_ynvhand_savepring_ = -ieicaion kynvhand_yword syn keiion _ynvhand_yword s sy (g:, 'pgsql_disywordC sql 'postgis_ynvhand_ossps) == -1 f sylynvhand_osss) ==rivs_areet(g:, 'pgsql_disywordC sql 'postgis_ynvhand_p syyn keiion _ynvhand_espaceaionp_argue tot(g:, 'pgsql_disywordC sql 'postgis_ynvhand_p seaionp_res t__ynvhand_syn utepta)n ca st(g:, 'pgsql_disywordC sql 'postgis_ynvhand_piss_zonq_d syc= -1 f cont_ynvhand_lwonsaed_ex keiioa st(g:, 'pgsql_disywordC sql 'postgis_ynvhand_pwonsaed_ex s) == invhand_pwonsaed_ex t omdnok st(g:, 'pgsql_disywordC sql 'postgis_ynvhand_ s_oflkn apeosyn acter_ynvhand_xml'sesm-1 ynvhand_xml'se cw ct(g:, 'pgsql_disywordC sql 'postgis_ynvhand_xml'docum-1 ynvhand_xml'procnt ongined rution kyotywordt(g:, 'pgsql_disywordC sql 'postgis_locokr 'sy lpd_extuywoFeiey_exkeystuywoF colavailsnt t(g:, 'pgsql_disywordC sql 'postgis_m sifyqlFsctio us_g cols omd t), mosg_ = -ieic__is misconta sy_pooFtudet(g:, 'pgsql_disywordC sql 'postgis_no tctecenctioywonsaed_ext(g:, 'pgsql_disywordC sql 'postgis_no tctecenctioywonsaed_exon ib onch lwonsaed_exxno tddqd_exai'oy sic_ta) ==_ srivs_areexno us_t(g:, 'pgsql_disywordC sql 'postgis_no us_gfrate_necotctiard_ s_oflkn apeosyn actert(g:, 'pgsql_disywordC sql 'postgis_noolan_xml'docum-1 nool_isn_seor keywt(g:, 'pgsql_disywordC sql 'postgis_nisn_scontaeimmdnontd_s__ etFunction _nisn_scontano tneicokr 'pn sytn _nisn_scontanot allonayt(g:, 'pgsql_disywordC sql 'postgis_nikeyworsconta us_oflt_add obj -tfqlFuF t(g:, 'pgsql_disywordC sql 'postgis_obj -tf colin_ptaivquisite s) == s opcla_yn ontessin _ us_oflmemory_u_i-osspywordt(g:, 'pgsql_disywordC sql 'postgis_llecile')_ colgra sis_llecile')_ colrevokayt(g:, 'pgsql_disywordC sql 'postgis_progsamoimmd _sy layee_prohibiaed_ossps) == -1 fattempsis_lloto_pk reor keywt(g:, 'pgsql_disywordC sql 'postgis_mptz cd sqlis_raise_sy lpd_ex read_onlynctioywonsaed_ext(g:, 'pgsql_disywordC sql 'postgis_readqlFsctio us_g cols omd t), ta)nnted_ sy ta)ntait reor keywt(g:, 'pgsql_disywordC sql 'postgis_savepring_sy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_yword sctit us_gt) == -1 fmixqlFs colsup orreuusen keyw_ion con ilmmd _sy layee_)nnes_aza s_unctu st(g:, 'pgsql_disywordC sql 'postgis_snapshot_pooFols_osspi usqle_sy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_ossps) == -1 f ot_yeaude tlekqlFqlcli yn udExte l')eskeywihhuFqlcecch syt(g:, 'pgsql_disywordC sql 'postgis_osslFunctirejh ed)eskeywihh -1 foflFqlcecch sy srfwproto_pk reor kist(g:, 'pgsql_disywordC sql 'postgis_okecked' k_onosticsgaccqlTed'orms us_tctecennction c(g:, 'pgsql_disywordC sql 'postgis_oke== -1 fde tlek s_unknowxtoke== -1 fpooFde tlexc(g:, 'pgsql_disywordC sql 'postgis_oktang_ us_glength_misconta oktang_ us_gryworoywncta sysuboktang_ywordt(g:, 'pgsql_disywordC sql 'postgis_succqlTfulfde tlek st(g:tax_ywordt(g:, 'pgsql_disywordC sql 'postgis_sg:tax_yword_ iaccqlTatrd yseor keyw_systemiewordlpooFpeny_argue toslpooFpeny_e syn kt(g:, 'pgsql_disywordC sql 'postgis_pooFpeny_e cch syslpooFpeny_ kFkt(g:, 'pgsql_disywordC sql 'postgis_pwonsaed_ex ke ogrghs'secotray syseor keyw_pwonsaed_ex ta)rluk s_unknowxtpwonsaed_ex t llbeckt(g:, 'pgsql_disywordC sql 'postgis_pwywordwproto_pk reor kis_awywordensa sy_sy lpd_ext(g:, 'pgsql_disywordC sql 'postgis_pwywordeit us_gar_add_seor keyw_pwimiewordlate_ keydg syn t(g:, 'pgsql_disywordC sql 'postgis_ate_ keydgeiey_ate_ keydgenction _ate_ keydgobj -teate_ keydgpn sytn t(g:, 'pgsql_disywordC sql 'postgis_ate_ keydgkeyworis_tud_seor keyw_unt omdnokedg _ontangt(g:, 'pgsql_disywordC sql 'postgis_atywonslonsnt scyn acter_wargqlF nqldonqlFsywordt(g:, 'pgsql_disywordC sql 'postgis_orms_are huep s_seor keyw_wrong_obj -tf_is _zeroflength_syn acter_ ntangt " Nuyworkt(g:,conta oqlNuywor "\<\d*\.\=[0-9_]\>"t " Vn keyword(edessieier syn kilF nqth a _ate_rscore)t(g:,conta oqlVn keywo "\<_[A-Za-z0-9][A-Za-z0-9_]*\>"t " Sntangkt(g:,regeyw_sqlIdessieier_syn k=+"+ skip=+\\\\\|\\"+ end=+"+t(g:,regeyw_sqlSntang syn k=+'+ skip=+\\\\\|\\'+ end=+'+ 'postgs=@Spellt(g:,regeyw_sqlSntang syn k=+\$HERE\$+ end=+\$HERE\$+t " Os opclakt(g:,conta oqlIsOs opcla "\%(^\|[^!?~#^@<=>%&|*/+-]\)\zs[!?~#^@<=>%&|*/+-]\+" 'postgs=oqlOs opcla t(g:,conta oqlOs opcla 'postgis_"\%(<<->>\|!\~\~\*\|\#<=\#\|\#>=\#\|<->>\|<<->\|\~<=\~\|\~>=\~\|!\~\*\|!\~\~\|\#<\#\|\#<=\|\#<>\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"t(g:,conta oqlOs opcla 'postgis_"\%(\#>\#\|\#>=\|\#>>\|&&&\|&<|\|\*<=\|\*<>\|\*>=\|->>\|-|-\|<\#>\|<->\|<<=\|<<|\|<=>\|\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"t(g:,conta oqlOs opcla 'postgis_"\%(<@>\|>>=\|?-|\|?<@\|?@>\|?||\|@-@\|@@@\|\^<@\|\^@>\||&>\||=|\||>>\|||/\|\~<\~\|\~>\~\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"t(g:,conta oqlOs opcla 'postgis_"\%(\~\~\*\|!!\|!\~\|\#\#\|\#-\|\#<\|\#=\|\#>\|%\#\|%%\|%>\|&&\|&<\|&>\|\*<\|\*=\|\*>\|->\|<%\|<<\|<=\|<>\|<@\|<\^\|>=\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"t(g:,conta oqlOs opcla 'postgis_"\%(>>\|>\^\|?\#\|?&\|?-\|?@\|?|\|?\~\|@>\|@@\|\^?\|\^@\|\^\~\||/\|||\|\~\*\|\~=\|\~>\|\~\~\|!\|\#\|%\|&\|\*\|+\|-\|/\|<\|=\|>\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"t(g:,conta oqlOs opcla 'postgis_"\%(?\|@\|\^\||\|\~\)\ze\%([^!?~#^@<=>%&|*/+-]\|$\)"tqlTCesm-1 kt(g:,regeyw_sqlCesm-1 syn k="/\*" end="\*/" 'postgs=oqlTodo,@Spellt(g:,conta _sqlCesm-1 "#\s.*$" 'postgs=oqlTodo,@Spellt(g:,conta _sqlCesm-1 "--.*$" 'postgs=oqlTodo,@Spellt " Os ss (g:, 'pgsql_disOpd_extensostgis_bli yn min_lFss con_oearch_lFun t(g:tax_cte_,contat " Pdis K'pgsqlkt(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\[aCfHhorrTxz]\>\|\\[?!]/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\c\%(\%(d\| cch \| ccel \| py\%(rywor\)\?\|oosskeyre v\)\?\)\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\d\>\|\\dS\>+\?\|\\d[ao]S\?\>\|\\d[cDgiLmnOstTuvE]\%(\>\|S\>+\?\)/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\d[AbClx]\>+\?\|\\d[py]\>\|\\dd[pS]\>\?\|\\de[tsuw]\>+\?\|\\df[antw]\?S\?\>+\?\|\\dF[dpt]\?\>+\?\|\\dqlk\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\e\%(ch \|[fv]\|ncodqlF\|ounctbose\)\?\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\g\%(exec\|set\)\?\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\ir\?\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\l\>+\?\|\\lo_\%(ex orr\|im orr\|lmpr\|u sqlk\)\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\p\%(keygsql\|oompt\|set\)\?\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\q\%(ech \)\?\>/t(g:,conta oqlPsqlCesmctil 'postgis_nextsqlFu=oqlPsqlK'pgsql,oqlNuywor,sqlSntang /\\s\>\|\\s[fv]\