PostgreSQL 正體中文使用手冊
16
PostgreSQL.TW
官方使用手冊
小島故事
加入社團
Search
⌃
K
Links
簡介
前言
I. 新手教學
II. SQL 查詢語言
III. 系統管理
IV. 用戶端介面
V. 資料庫程式設計
VI. 參考資訊
I. SQL 指令
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER EXTENSION
ALTER FUNCTION
ALTER INDEX
ALTER LANGUAGE
ALTER MATERIALIZED VIEW
ALTER POLICY
ALTER PUBLICATION
ALTER ROLE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER STATISTICS
ALTER SUBSCRIPTION
ALTER SYSTEM
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ANALYZE
CLUSTER
COMMENT
COMMIT PREPARED
COPY
CREATE ACCESS METHOD
CREATE CAST
CREATE DATABASE
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN TABLE
CREATE FOREIGN DATA WRAPPER
CREATE FUNCTION
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE DOMAIN
CREATE POLICY
CREATE PROCEDURE
CREATE PUBLICATION
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE STATISTICS
CREATE SUBSCRIPTION
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
DEALLOCATE
DELETE
DO
DROP ACCESS METHOD
DROP DATABASE
DROP EXTENSION
DROP FUNCTION
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OWNED
DROP POLICY
DROP PUBLICATION
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP STATISTICS
DROP SUBSCRIPTION
DROP TABLE
DROP TABLESPACE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
EXECUTE
EXPLAIN
GRANT
IMPORT FOREIGN SCHEMA
INSERT
LISTEN
LOAD
MERGE
NOTIFY
PREPARE
PREPARE TRANSACTION
REASSIGN OWNED
REFRESH MATERIALIZED VIEW
REINDEX
RESET
REVOKE
ROLLBACK PREPARED
SECURITY LABEL
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
TRUNCATE
UNLISTEN
UPDATE
VACUUM
VALUES
II. PostgreSQL 用戶端工具
III. PostgreSQL 伺服器應用程式
VII. 資料庫進階
VIII. 附錄
參考書目
Powered By
GitBook
SET ROLE
SET ROLE — 設定目前連線的目前使用者識別
語法
SET
[
SESSION
|
LOCAL
]
ROLE role_name
SET
[
SESSION
|
LOCAL
]
ROLE NONE
RESET ROLE
說明