Documentação do PostgreSQL 8.2.0

Projeto de Tradução para o Português do Brasil

GitLab: Documentação da versão 14

The PostgreSQL Global Development Group


Sumário
Prefácio
O que é o PostgreSQL?
Uma breve história do PostgreSQL
Conventions
Further Information
Bug Reporting Guidelines
I. Tutorial
1. Início
2. A linguagem SQL
3. Funcionalidades avançadas
II. A linguagem SQL
4. SQL Syntax
5. Data Definition
6. Data Manipulation
7. Queries
8. Data Types
9. Functions and Operators
10. Type Conversion
11. Indexes
12. Concurrency Control
13. Performance Tips
III. Administração do servidor
14. Installation Instructions
15. Client-Only Installation on Windows
16. Operating System Environment
17. Server Configuration
18. Database Roles and Privileges
19. Managing Databases
20. Client Authentication
21. Localization
22. Routine Database Maintenance Tasks
23. Backup and Restore
24. High Availability and Load Balancing
25. Monitoring Database Activity
26. Monitoring Disk Usage
27. Reliability and the Write-Ahead Log
28. Regression Tests
IV. Interfaces cliente
29. libpq - C Library
30. Large Objects
31. ECPG - Embedded SQL in C
32. The Information Schema
V. Programação servidor
33. Extending SQL
34. Triggers
35. The Rule System
36. Procedural Languages
37. PL/pgSQL - SQL Procedural Language
38. PL/Tcl - Tcl Procedural Language
39. PL/Perl - Perl Procedural Language
40. PL/Python - Python Procedural Language
41. Server Programming Interface
VI. Referência
I. Comandos SQL
II. Aplicativos cliente do PostgreSQL
III. Aplicativos do servidor PostgreSQL
VII. Internamente
42. Overview of PostgreSQL Internals
43. System Catalogs
44. Frontend/Backend Protocol
45. PostgreSQL Coding Conventions
46. Native Language Support
47. Writing A Procedural Language Handler
48. Genetic Query Optimizer
49. Index Access Method Interface Definition
50. GiST Indexes
51. GIN Indexes
52. Database Physical Storage
53. BKI Backend Interface
54. How the Planner Uses Statistics
VIII. Apêndices
A. PostgreSQL Error Codes
B. Date/Time Support
C. SQL Key Words
D. SQL Conformance
E. Release Notes
F. The CVS Repository
G. Documentation
H. External Projects
Bibliografia
Índice Remissivo
Lista de Tabelas
4-1. Operator Precedence (decreasing)
8-1. Data Types
8-2. Numeric Types
8-3. Monetary Types
8-4. Character Types
8-5. Special Character Types
8-6. Binary Data Types
8-7. bytea Literal Escaped Octets
8-8. bytea Output Escaped Octets
8-9. Date/Time Types
8-10. Date Input
8-11. Time Input
8-12. Time Zone Input
8-13. Special Date/Time Inputs
8-14. Date/Time Output Styles
8-15. Date Order Conventions
8-16. Geometric Types
8-17. Network Address Types
8-18. cidr Type Input Examples
8-19. Object Identifier Types
8-20. Pseudo-Types
9-1. Comparison Operators
9-2. Mathematical Operators
9-3. Mathematical Functions
9-4. Trigonometric Functions
9-5. SQL String Functions and Operators
9-6. Other String Functions
9-7. Built-in Conversions
9-8. SQL Binary String Functions and Operators
9-9. Other Binary String Functions
9-10. Bit String Operators
9-11. Regular Expression Match Operators
9-12. Regular Expression Atoms
9-13. Regular Expression Quantifiers
9-14. Regular Expression Constraints
9-15. Regular Expression Character-Entry Escapes
9-16. Regular Expression Class-Shorthand Escapes
9-17. Regular Expression Constraint Escapes
9-18. Regular Expression Back References
9-19. ARE Embedded-Option Letters
9-20. Formatting Functions
9-21. Template Patterns for Date/Time Formatting
9-22. Template Pattern Modifiers for Date/Time Formatting
9-23. Template Patterns for Numeric Formatting
9-24. to_char Examples
9-25. Date/Time Operators
9-26. Date/Time Functions
9-27. AT TIME ZONE Variants
9-28. Geometric Operators
9-29. Geometric Functions
9-30. Geometric Type Conversion Functions
9-31. cidr and inet Operators
9-32. cidr and inet Functions
9-33. macaddr Functions
9-34. Sequence Functions
9-35. array Operators
9-36. array Functions
9-37. General-Purpose Aggregate Functions
9-38. Aggregate Functions for Statistics
9-39. Series Generating Functions
9-40. Session Information Functions
9-41. Access Privilege Inquiry Functions
9-42. Schema Visibility Inquiry Functions
9-43. System Catalog Information Functions
9-44. Comment Information Functions
9-45. Configuration Settings Functions
9-46. Server Signalling Functions
9-47. Backup Control Functions
9-48. Database Object Size Functions
9-49. Generic File Access Functions
9-50. Advisory Lock Functions
12-1. SQL Transaction Isolation Levels
16-1. System V IPC parameters
16-2. Configuration parameters affecting PostgreSQL's shared memory usage
17-1. Short option key
21-1. PostgreSQL Character Sets
21-2. Client/Server Character Set Conversions
25-1. Standard Statistics Views
25-2. Statistics Access Functions
25-3. Built-in Trace Points
31-1. Valid input formats for PGTYPESdate_from_asc
31-2. Valid input formats for PGTYPESdate_fmt_asc
31-3. Valid input formats for rdefmtdate
31-4. Valid input formats for PGTYPEStimestamp_from_asc
32-1. information_schema_catalog_name Columns
32-2. administrable_role_authorizations Columns
32-3. applicable_roles Columns
32-4. attributes Columns
32-5. check_constraint_routine_usage Columns
32-6. check_constraints Columns
32-7. column_domain_usage Columns
32-8. column_privileges Columns
32-9. column_udt_usage Columns
32-10. columns Columns
32-11. constraint_column_usage Columns
32-12. constraint_table_usage Columns
32-13. data_type_privileges Columns
32-14. domain_constraints Columns
32-15. domain_udt_usage Columns
32-16. domains Columns
32-17. element_types Columns
32-18. enabled_roles Columns
32-19. key_column_usage Columns
32-20. parameters Columns
32-21. referential_constraints Columns
32-22. role_column_grants Columns
32-23. role_routine_grants Columns
32-24. role_table_grants Columns
32-25. role_usage_grants Columns
32-26. routine_privileges Columns
32-27. routines Columns
32-28. schemata Columns
32-29. sequences Columns
32-30. sql_features Columns
32-31. sql_implementation_info Columns
32-32. sql_languages Columns
32-33. sql_packages Columns
32-34. sql_parts Columns
32-35. sql_sizing Columns
32-36. sql_sizing_profiles Columns
32-37. table_constraints Columns
32-38. table_privileges Columns
32-39. tables Columns
32-40. triggers Columns
32-41. usage_privileges Columns
32-42. view_column_usage Columns
32-43. view_routine_usage Columns
32-44. view_table_usage Columns
32-45. views Columns
33-1. Equivalent C Types for Built-In SQL Types
33-2. B-tree Strategies
33-3. Hash Strategies
33-4. GiST Two-Dimensional "R-tree" Strategies
33-5. GIN Array Strategies
33-6. B-tree Support Functions
33-7. Hash Support Functions
33-8. GiST Support Functions
33-9. GIN Support Functions
43-1. System Catalogs
43-2. pg_aggregate Columns
43-3. pg_am Columns
43-4. pg_amop Columns
43-5. pg_amproc Columns
43-6. pg_attrdef Columns
43-7. pg_attribute Columns
43-8. pg_authid Columns
43-9. pg_auth_members Columns
43-10. pg_autovacuum Columns
43-11. pg_cast Columns
43-12. pg_class Columns
43-13. pg_constraint Columns
43-14. pg_conversion Columns
43-15. pg_database Columns
43-16. pg_depend Columns
43-17. pg_description Columns
43-18. pg_index Columns
43-19. pg_inherits Columns
43-20. pg_language Columns
43-21. pg_largeobject Columns
43-22. pg_listener Columns
43-23. pg_namespace Columns
43-24. pg_opclass Columns
43-25. pg_operator Columns
43-26. pg_pltemplate Columns
43-27. pg_proc Columns
43-28. pg_rewrite Columns
43-29. pg_shdepend Columns
43-30. pg_shdescription Columns
43-31. pg_statistic Columns
43-32. pg_tablespace Columns
43-33. pg_trigger Columns
43-34. pg_type Columns
43-35. System Views
43-36. pg_cursors Columns
43-37. pg_group Columns
43-38. pg_indexes Columns
43-39. pg_locks Columns
43-40. pg_prepared_statements Columns
43-41. pg_prepared_xacts Columns
43-42. pg_roles Columns
43-43. pg_rules Columns
43-44. pg_settings Columns
43-45. pg_shadow Columns
43-46. pg_stats Columns
43-47. pg_tables Columns
43-48. pg_timezone_abbrevs Columns
43-49. pg_timezone_names Columns
43-50. pg_user Columns
43-51. pg_views Columns
52-1. Contents of PGDATA
52-2. Overall Page Layout
52-3. PageHeaderData Layout
52-4. HeapTupleHeaderData Layout
A-1. PostgreSQL Error Codes
B-1. Month Names
B-2. Day of the Week Names
B-3. Date/Time Field Modifiers
C-1. SQL Key Words
H-1. Externally Maintained Client Interfaces
H-2. Externally Maintained Procedural Languages
Lista de Figuras
48-1. Structured Diagram of a Genetic Algorithm
Lista de Exemplos
8-1. Using the character types
8-2. Using the boolean type
8-3. Using the bit string types
10-1. Exponentiation Operator Type Resolution
10-2. String Concatenation Operator Type Resolution
10-3. Absolute-Value and Negation Operator Type Resolution
10-4. Rounding Function Argument Type Resolution
10-5. Substring Function Type Resolution
10-6. character Storage Type Conversion
10-7. Type Resolution with Underspecified Types in a Union
10-8. Type Resolution in a Simple Union
10-9. Type Resolution in a Transposed Union
11-1. Setting up a Partial Index to Exclude Common Values
11-2. Setting up a Partial Index to Exclude Uninteresting Values
11-3. Setting up a Partial Unique Index
20-1. Example pg_hba.conf entries
20-2. An example pg_ident.conf file
29-1. libpq Example Program 1
29-2. libpq Example Program 2
29-3. libpq Example Program 3
30-1. Large Objects with libpq Example Program
33-1. Função para agregar texto
33-2. Função para agregar texto com dois parâmetros
33-3. Função para gerar histograma
33-4. Função para listar inteiros
36-1. Manual Installation of PL/pgSQL
37-1. Exceptions with UPDATE/INSERT
37-2. A PL/pgSQL Trigger Procedure
37-3. A PL/pgSQL Trigger Procedure For Auditing
37-4. A PL/pgSQL Trigger Procedure For Maintaining A Summary Table
37-5. Porting a Simple Function from PL/SQL to PL/pgSQL
37-6. Porting a Function that Creates Another Function from PL/SQL to PL/pgSQL
37-7. Porting a Procedure With String Manipulation and OUT Parameters from PL/SQL to PL/pgSQL
37-8. Porting a Procedure from PL/SQL to PL/pgSQL
SourceForge.net Logo CSS válido!