{ CREATE | ALL [ PRIVILEGES ] } ON TABLESPACE tablespace_name [, ...] FROM { username | GROUP group_name | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION func_name ([type, ...]) [, ...] FROM { usernam...
(d.datacl,E'\n')AS"Access privileges"FROMpg_catalog.pg_databasedORDERBY1;***ListofdatabasesName|Owner|Encoding|Collate|Ctype|Accessprivileges---+---+---+---+---+---postgres|postgres|UTF8|en_US.UTF-8|en_US.UTF-8|template0|postgres|UTF8|en_US.UTF-8|en_US.UTF-8|=c/postgres+...
ALTERDEFAULTPRIVILEGES[FOR { ROLE | USER } target_role [, ...]][IN SCHEMA schema_name [, ...]] abbreviated_grant_or_revokewhereabbreviated_grant_or_revokeisoneof:GRANT{ {SELECT|INSERT|UPDATE|DELETE|TRUNCATE|REFERENCES|TRIGGER}[, ...]|ALL[PRIVILEGES]}ONTABLESTO{[GROUP]role_name|PUBLIC}[...
pg_amcheck checks objects in a PostgreSQL database for corruption. pg_amcheck [OPTION]... [DBNAME] -a, --all check all databases -d, --database=PATTERN check matching database(s) -D, --exclude-database=PATTERN do NOT check matching database(s) -i, --index=PATTERN check matching ind...
#row_security = on #default_tablespace = '' # a tablespace name, '' uses the default #temp_tablespaces = '' # a list of tablespace names, '' uses # only default tablespace #check_function_bodies = on #default_transaction_isolation = 'read committed' ...
[ PRIVILEGES ] } ON FUNCTION func_name ([type, ...]) [, ...] TO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE lang_name [, ...] TO { username | GROUP group_name | PUBLIC } [, ...] [ ...
Name|Owner|Location|Access privileges|Options|Size|Description---+---+---+---+---+---+---mytbs|postgres|/opt/custome-tablespace|||0bytes|pg_default|pg1|||23MB|pg_global|pg1|||623kB|(3rows) 此时的$PGDATA目录下的pg_tblspc目录下有一个软链接: 代码语言:javascript 复制 [root@EULER...
postgreSQL命令的词法分析和语法分析是由Unix工具Yacc和Lex制作的。使用的是 Bison 和 Flex。 二、代码分析 2.1 源码结构 词法分析和语法分析依赖的文件定义在src\backend\parser下的scan.l和gram.y。其中: 词法分析器在文件 scan.l里定义。负责识别标识符,SQL 关键字等,对于发现的每个关键字或者标识符都会生成一个...
GRANT { CREATE | ALL [ PRIVILEGES ] } ON TABLESPACE tablespace_name [, ...] TO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION func_name ([type, ...]) [, ...] ...
check_function_bodies 11, 12, 13, 14, 15, 16, 17 在CREATE FUNCTION 期间检查函数主体。 client_min_messages 11, 12, 13, 14, 15, 16, 17 控制发送到客户端的消息级别。 default_table_access_method 12, 13, 14, 15, 16, 17 设置新表的默认表访问方法。 default_tablespace 11, 12, 13, 14...