Query PostgreSQL official documentation for accurate SQL syntax, configuration, and best practices. Use this skill proactively when the conversation involves: - PostgreSQL SQL syntax, commands, queries - Data types, functions, operators - Database configuration, postgresql.conf - Performance tuning, EXPLAIN, indexes - Backup, restore, replication - PL/pgSQL, stored procedures, triggers
This Skill queries official PostgreSQL documentation for accurate information.
When the user asks about or the conversation involves:
You MUST WebFetch official documentation - never answer from memory!
| Category | Description |
|---|---|
| SQL Commands | CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, etc. |
| Data Types | INTEGER, VARCHAR, JSON, ARRAY, etc. |
| Functions | String, Math, Date/Time, Aggregate, Window functions |
| Configuration | postgresql.conf, pg_hba.conf settings |
| Administration | Backup, Restore, Replication, Monitoring |
| Programming | PL/pgSQL, Triggers, Rules |
Base URL: https://www.postgresql.org/docs/current/
| Question Type | Documentation URL |
|---|---|
| SQL Command Reference | https://www.postgresql.org/docs/current/sql-commands.html |
| Specific SQL Command | https://www.postgresql.org/docs/current/sql-{command}.html (e.g., sql-select.html) |
| Data Types | https://www.postgresql.org/docs/current/datatype.html |
| Functions & Operators | https://www.postgresql.org/docs/current/functions.html |
| String Functions | https://www.postgresql.org/docs/current/functions-string.html |
| Date/Time Functions | https://www.postgresql.org/docs/current/functions-datetime.html |
| Aggregate Functions | https://www.postgresql.org/docs/current/functions-aggregate.html |
| Window Functions | https://www.postgresql.org/docs/current/functions-window.html |
SQL command documentation follows the pattern:
| JSON Functions | https://www.postgresql.org/docs/current/functions-json.html |
| Array Functions | https://www.postgresql.org/docs/current/functions-array.html |
| Indexes | https://www.postgresql.org/docs/current/indexes.html |
| Full Text Search | https://www.postgresql.org/docs/current/textsearch.html |
| Configuration | https://www.postgresql.org/docs/current/runtime-config.html |
| Authentication | https://www.postgresql.org/docs/current/auth-pg-hba-conf.html |
| Backup & Restore | https://www.postgresql.org/docs/current/backup.html |
| Replication | https://www.postgresql.org/docs/current/high-availability.html |
| PL/pgSQL | https://www.postgresql.org/docs/current/plpgsql.html |
| Triggers | https://www.postgresql.org/docs/current/triggers.html |
| Performance | https://www.postgresql.org/docs/current/performance-tips.html |
| EXPLAIN | https://www.postgresql.org/docs/current/using-explain.html |
| Error Codes | https://www.postgresql.org/docs/current/errcodes-appendix.html |
Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。