我的书签
添加书签
移除书签H.2. Administration Tools
There are several administration tools available for PostgreSQL. The most popular is pgAdmin III, and there are several commercially available ones as well.
H.2. Administration Tools
- 簡介
- 前言
- I. 新手教學
- II. SQL 查詢語言
- 4. SQL 語法
- 5. 定義資料結構
- 6. 資料處理
- 7. 資料查詢
- 8. 資料型別
- 9. 函式及運算子
- 9.1. 邏輯運算子
- 9.2. 比較函式及運算子
- 9.3. 數學函式及運算子
- 9.4. 字串函式及運算子
- 9.5. 位元字串函式及運算子
- 9.6. 二元字串函式及運算子
- 9.7. 特徵比對
- 9.8. 型別轉換函式
- 9.9 日期時間函式及運算子
- 9.10. 列舉型別函式
- 9.11. 地理資訊函式及運算子
- 9.12. 網路位址函式及運算子
- 9.13. 文字檢索函式及運算子
- 9.14. XML 函式
- 9.15. JSON 函式及運算子
- 9.16. 序列函式
- 9.17. 條件表示式
- 9.18. 陣列函式及運算子
- 9.19. 範圍函式及運算子
- 9.20. 彙總函數
- 9.21. Window 函式
- 9.22. 子查詢
- 9.23. 資料列與陣列的比較運算
- 9.24. 集合回傳函式
- 9.25. 系統資訊函數
- 9.26. 系統管理函式
- 9.27. 觸發函式
- 9.28. 事件觸發函式
- 10. 型別轉換
- 11. 索引（Index）
- 12. 全文檢索
- 13. 一致性管理（MVCC）
- 14. 效能技巧
- 15. 平行查詢
- III. 系統管理
- 16. 用原始碼安裝
- 17. 用原始碼在 Windows 上安裝
- 18. 服務配置與維運
- 18.1. PostgreSQL 使用者帳號
- 18.2. Creating a Database Cluster
- 18.3. Starting the Database Server
- 18.4. 核心資源管理
- 18.5. Shutting Down the Server
- 18.6. Upgrading a PostgreSQL Cluster
- 18.7. Preventing Server Spoofing
- 18.8. Encryption Options
- 18.9. Secure TCP/IP Connections with SSL
- 18.10. Secure TCP/IP Connections with GSSAPI Encryption
- 18.11. Secure TCP/IP Connections with SSH Tunnels
- 18.12. 在 Windows 註冊事件日誌
- 19. 服務組態設定
- 19.1. Setting Parameters
- 19.2. File Locations
- 19.3. 連線與認證
- 19.4. 資源配置
- 19.5. Write Ahead Log
- 19.6. 複寫（Replication）
- 19.7. 查詢規畫
- 19.8. 錯誤回報與日誌記錄
- 19.9. 執行階段統計資訊
- 19.10. 自動資料庫清理
- 19.11. 用戶端連線預設參數
- 19.12. 交易鎖定管理
- 19.13. 版本與平台的相容性
- 19.14. Error Handling
- 19.15. 預先配置的參數
- 19.16. Customized Options
- 19.17. Developer Options
- 19.18. Short Options
- 20. 使用者認證
- 21. 資料庫角色
- 22. Managing Databases
- 23. 語系
- 24. 例行性資料庫維護工作
- 25. 備份及還原
- 26. High Availability, Load Balancing, and Replication
- 27. 監控資料庫活動
- 28. 監控磁碟使用情況
- 29. 高可靠度及預寫日誌
- 30. 邏輯複寫（Logical Replication）
- 31. Just-in-Time Compilation（JIT）
- 32. 迴歸測試
- IV. 用戶端介面
- 33. libpq - C Library
- 33.1. 資料庫連線控制函數
- 33.2. 連線狀態函數
- 33.3. Command Execution Functions
- 33.4. Asynchronous Command Processing
- 33.5. Retrieving Query Results Row-By-Row
- 33.6. Canceling Queries in Progress
- 33.7. The Fast-Path Interface
- 33.8. Asynchronous Notification
- 33.9. Functions Associated with the COPY Command
- 33.10. Control Functions
- 33.11. Miscellaneous Functions
- 33.12. Notice Processing
- 33.13. Event System
- 33.14. 環境變數
- 33.15. 密碼檔
- 33.16. The Connection Service File
- 33.17. LDAP Lookup of Connection Parameters
- 33.18. SSL Support
- 33.19. Behavior in Threaded Programs
- 33.20. Building libpq Programs
- 33.21. Example Programs
- 34. Large Objects
- 35. ECPG - Embedded SQL in C
- 36.1. The Concept
- 36.2. Managing Database Connections
- 36.3. Running SQL Commands
- 36.4. Using Host Variables
- 36.5. Dynamic SQL
- 36.6. pgtypes Library
- 36.7. Using Descriptor Areas
- 36.8. Error Handling
- 36.9. Preprocessor Directives
- 36.10. Processing Embedded SQL Programs
- 36.11. Library Functions
- 36.12. Large Objects
- 36.13. C++ Applications
- 36.14. Embedded SQL Commands
- 36.15. Informix Compatibility Mode
- 36.16. Internals
- 36. The Information Schema
- 36.1. The Schema
- 36.2. Data Types
- 36.3. information_schema_catalog_name
- 36.4. administrable_role_authorizations
- 36.5. applicable_roles
- 36.6. attributes
- 36.7. character_sets
- 36.8. check_constraint_routine_usage
- 36.9. check_constraints
- 36.10. collations
- 36.11. collation_character_set_applicability
- 36.12. column_domain_usage
- 36.13. column_options
- 36.14. column_privileges
- 36.15. column_udt_usage
- 36.16. columns
- 36.17. constraint_column_usage
- 37.18. constraint_table_usage
- 37.19. data_type_privileges
- 37.20. domain_constraints
- 37.21. domain_udt_usage
- 37.22. domains
- 37.23. element_types
- 37.24. enabled_roles
- 37.25. foreign_data_wrapper_options
- 37.26. foreign_data_wrappers
- 37.27. foreign_server_options
- 37.28. foreign_servers
- 37.29. foreign_table_options
- 37.30. foreign_tables
- 37.31. key_column_usage
- 37.32. parameters
- 37.33. referential_constraints
- 37.34. role_column_grants
- 37.35. role_routine_grants
- 37.36. role_table_grants
- 37.37. role_udt_grants
- 37.38. role_usage_grants
- 37.39. routine_privileges
- 37.40. routines
- 37.41. schemata
- 37.42. sequences
- 37.43. sql_features
- 37.44. sql_implementation_info
- 37.45. sql_languages
- 37.46. sql_packages
- 37.47. sql_parts
- 37.48. sql_sizing
- 37.49. sql_sizing_profiles
- 37.50. table_constraints
- 37.51. table_privileges
- 37.52. tables
- 37.53. transforms
- 37.54. triggered_update_columns
- 37.55. triggers
- 37.56. udt_privileges
- 37.57. usage_privileges
- 37.58. user_defined_types
- 37.59. user_mapping_options
- 37.60. user_mappings
- 37.61. view_column_usage
- 37.62. view_routine_usage
- 37.63. view_table_usage
- 37.64. views
- 33. libpq - C Library
- V. 資料庫程式設計
- 37. SQL 延伸功能
- 37.1. How Extensibility Works
- 37.2. The PostgreSQL Type System
- 37.3. 使用者自訂函數
- 37.4. User-defined Procedures
- 37.5. Query Language (SQL) Functions
- 37.6. Function Overloading
- 37.7. 函數易變性類別
- 37.8. Procedural Language Functions
- 37.9. Internal Functions
- 37.10. C-Language Functions
- 37.11. Function Optimization Information
- 37.12. User-defined Aggregates
- 37.13. User-defined Types
- 37.14. User-defined Operators
- 37.15. Operator Optimization Information
- 37.16. Interfacing Extensions To Indexes
- 37.17. 封裝相關物件到延伸功能中
- 37.18. Extension Building Infrastructure
- 38. Triggers
- 39. Event Triggers
- 40. 規則系統
- 41. Procedural Languages（程序語言）
- 43. PL/pgSQL - SQL Procedural Language
- 44. PL/Tcl - Tcl Procedural Language
- 45. PL/Perl - Perl Procedural Language
- 46. PL/Python - Python Procedural Language
- 47. Server Programming Interface
- 48. Background Worker Processes
- 49. Logical Decoding
- 50. Replication Progress Tracking
- 37. SQL 延伸功能
- 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 VIEW
- ANALYZE
- CLUSTER
- COMMENT
- COPY
- CREATE CAST
- CREATE DATABASE
- 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
- DELETE
- DO
- DROP DATABASE
- DROP EXTENSION
- DROP FUNCTION
- DROP INDEX
- DROP LANGUAGE
- DROP MATERIALIZED VIEW
- DROP OWNED
- DROP POLICY
- 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
- NOTIFY
- PREPARE TRANSACTION
- REASSIGN OWNED
- REFRESH MATERIALIZED VIEW
- REINDEX
- RESET
- REVOKE
- 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 伺服器應用程式
- I. SQL 指令
- VII. 資料庫進階
- 50. Overview of PostgreSQL Internals
- 51. 系統目錄
- 51.3. pg_am
- 51.7. pg_attribute
- 51.8. pg_authid
- 51.9. pg_auth_members
- 51.11 pg_class
- 51.12. pg_collation
- 51.13. pg_constraint
- 51.15 pg_database
- 51.22. pg_extension
- 51.26 pg_index
- 51.29. pg_language
- 51.32. pg_namespace
- 51.33. pg_opclass
- 51.38. pg_policy
- 51.39. pg_proc
- 51.44. pg_rewrite
- 51.50. pg_statistic
- 51.51. pg_statistic_ext
- 51.54. pg_tablespace
- 51.56. pg_trigger
- 51.62. pg_type
- 51.66. pg_available_extensions
- 51.67. pg_available_extension_versions
- 51.74. pg_locks
- 51.79. pg_replication_origin_status
- 51.82 pg_roles
- 51.85. pg_settings
- 51.87. pg_stats
- 52. Frontend/Backend Protocol
- 52.1. Overview
- 52.2. Message Flow
- 52.3. SASL Authentication
- 52.4. Streaming Replication Protocol
- 52.5. Logical Streaming Replication Protocol
- 52.6. Message Data Types
- 52.7. Message Formats
- 52.8. Error and Notice Message Fields
- 52.9. Logical Replication Message Formats
- 52.10. Summary of Changes since Protocol 2.0
- 53. PostgreSQL 程式撰寫慣例
- 54. Native Language Support
- 55. 撰寫程序語言的處理程序
- 56. Writing a Foreign Data Wrapper
- 64. GiST Indexes
- 65. SP-GiST Indexes
- 66. GIN 索引
- 67. BRIN Indexes
- 68. 資料庫實體儲存格式
- 70. How the Planner Uses Statistics
- VIII. 附錄
- 參考書目
暂无相关搜索结果！
本文档使用 BookStack 构建
