53
LISTEN .......................................................................................................................1538
LOAD..........................................................................................................................1540
LOCK..........................................................................................................................1541
MOVE..........................................................................................................................1544
NOTIFY.......................................................................................................................1546
PREPARE....................................................................................................................1549
PREPARE TRANSACTION.......................................................................................1552
REASSIGNOWNED..................................................................................................1554
REFRESH MATERIALIZED VIEW..........................................................................1556
REINDEX....................................................................................................................1558
RELEASE SAVEPOINT.............................................................................................1561
RESET.........................................................................................................................1563
REVOKE.....................................................................................................................1565
ROLLBACK................................................................................................................1569
ROLLBACK PREPARED...........................................................................................1570
ROLLBACK TO SAVEPOINT...................................................................................1572
SAVEPOINT ...............................................................................................................1574
SECURITYLABEL....................................................................................................1576
SELECT ......................................................................................................................1579
SELECT INTO............................................................................................................1599
SET..............................................................................................................................1601
SET CONSTRAINTS .................................................................................................1604
SET ROLE...................................................................................................................1606
SET SESSION AUTHORIZATION............................................................................1608
SET TRANSACTION.................................................................................................1610
SHOW .........................................................................................................................1613
START TRANSACTION............................................................................................1615
TRUNCATE ................................................................................................................1616
UNLISTEN..................................................................................................................1619
UPDATE......................................................................................................................1621
VACUUM....................................................................................................................1625
VALUES......................................................................................................................1628
II. PostgreSQL Client Applications......................................................................................1631
clusterdb ......................................................................................................................1632
createdb........................................................................................................................1635
createlang.....................................................................................................................1639
createuser.....................................................................................................................1642
dropdb..........................................................................................................................1647
droplang.......................................................................................................................1650
dropuser .......................................................................................................................1653
ecpg..............................................................................................................................1656
pg_basebackup ............................................................................................................1659
pg_config.....................................................................................................................1665
pg_dump......................................................................................................................1668
pg_dumpall..................................................................................................................1679
pg_isready....................................................................................................................1685
pg_receivexlog.............................................................................................................1688
pg_recvlogical .............................................................................................................1691
pg_restore ....................................................................................................................1695
psql..............................................................................................................................1703
reindexdb.....................................................................................................................1734
vacuumdb.....................................................................................................................1737
xxviii
114
III. PostgreSQL Server Applications ....................................................................................1741
initdb............................................................................................................................1742
pg_controldata.............................................................................................................1746
pg_ctl...........................................................................................................................1747
pg_resetxlog ................................................................................................................1753
postgres........................................................................................................................1755
postmaster....................................................................................................................1763
VII. Internals.................................................................................................................................1764
47. Overview of PostgreSQL Internals .................................................................................1766
47.1. The Path of a Query............................................................................................1766
47.2. How Connections are Established......................................................................1766
47.3. The Parser Stage.................................................................................................1767
47.3.1. Parser......................................................................................................1767
47.3.2. Transformation Process..........................................................................1768
47.4. The PostgreSQL Rule System............................................................................1768
47.5. Planner/Optimizer...............................................................................................1768
47.5.1. Generating Possible Plans......................................................................1769
47.6. Executor..............................................................................................................1770
48. System Catalogs..............................................................................................................1772
48.1. Overview ............................................................................................................1772
48.2.
pg_aggregate
..................................................................................................1773
48.3.
pg_am
.................................................................................................................1775
48.4.
pg_amop
.............................................................................................................1778
48.5.
pg_amproc
.........................................................................................................1779
48.6.
pg_attrdef
.......................................................................................................1779
48.7.
pg_attribute
..................................................................................................1780
48.8.
pg_authid
.........................................................................................................1783
48.9.
pg_auth_members
............................................................................................1784
48.10.
pg_cast
...........................................................................................................1785
48.11.
pg_class
.........................................................................................................1786
48.12.
pg_collation
................................................................................................1790
48.13.
pg_constraint
..............................................................................................1791
48.14.
pg_conversion
..............................................................................................1794
48.15.
pg_database
..................................................................................................1795
48.16.
pg_db_role_setting
...................................................................................1797
48.17.
pg_default_acl
............................................................................................1797
48.18.
pg_depend
.......................................................................................................1798
48.19.
pg_description
............................................................................................1800
48.20.
pg_enum
...........................................................................................................1800
48.21.
pg_event_trigger
........................................................................................1801
48.22.
pg_extension
................................................................................................1802
48.23.
pg_foreign_data_wrapper
........................................................................1802
48.24.
pg_foreign_server
.....................................................................................1803
48.25.
pg_foreign_table
........................................................................................1804
48.26.
pg_index
.........................................................................................................1804
48.27.
pg_inherits
..................................................................................................1808
48.28.
pg_language
..................................................................................................1808
48.29.
pg_largeobject
............................................................................................1810
48.30.
pg_largeobject_metadata
........................................................................1810
48.31.
pg_namespace
................................................................................................1811
48.32.
pg_opclass
.....................................................................................................1811
xxix
137
48.33.
pg_operator
..................................................................................................1812
48.34.
pg_opfamily
..................................................................................................1813
48.35.
pg_pltemplate
..............................................................................................1814
48.36.
pg_proc
...........................................................................................................1814
48.37.
pg_range
.........................................................................................................1819
48.38.
pg_rewrite
.....................................................................................................1819
48.39.
pg_replication_slots
...............................................................................1820
48.40.
pg_seclabel
..................................................................................................1821
48.41.
pg_shdepend
..................................................................................................1822
48.42.
pg_shdescription
........................................................................................1823
48.43.
pg_shseclabel
..............................................................................................1824
48.44.
pg_statistic
................................................................................................1825
48.45.
pg_tablespace
..............................................................................................1827
48.46.
pg_trigger
.....................................................................................................1827
48.47.
pg_ts_config
................................................................................................1829
48.48.
pg_ts_config_map
........................................................................................1830
48.49.
pg_ts_dict
.....................................................................................................1830
48.50.
pg_ts_parser
................................................................................................1831
48.51.
pg_ts_template
............................................................................................1832
48.52.
pg_type
...........................................................................................................1832
48.53.
pg_user_mapping
..........................................................................................1840
48.54. System Views ...................................................................................................1841
48.55.
pg_available_extensions
........................................................................1842
48.56.
pg_available_extension_versions
.......................................................1842
48.57.
pg_cursors
.....................................................................................................1843
48.58.
pg_group
.........................................................................................................1844
48.59.
pg_indexes
.....................................................................................................1844
48.60.
pg_locks
.........................................................................................................1845
48.61.
pg_matviews
..................................................................................................1848
48.62.
pg_prepared_statements
...........................................................................1849
48.63.
pg_prepared_xacts
.....................................................................................1850
48.64.
pg_roles
.........................................................................................................1850
48.65.
pg_rules
.........................................................................................................1852
48.66.
pg_seclabels
................................................................................................1852
48.67.
pg_settings
..................................................................................................1853
48.68.
pg_shadow
.......................................................................................................1855
48.69.
pg_stats
.........................................................................................................1856
48.70.
pg_tables
.......................................................................................................1859
48.71.
pg_timezone_abbrevs
.................................................................................1860
48.72.
pg_timezone_names
.....................................................................................1860
48.73.
pg_user
...........................................................................................................1860
48.74.
pg_user_mappings
........................................................................................1861
48.75.
pg_views
.........................................................................................................1862
49. Frontend/Backend Protocol.............................................................................................1863
49.1. Overview ............................................................................................................1863
49.1.1. Messaging Overview..............................................................................1863
49.1.2. Extended Query Overview.....................................................................1864
49.1.3. Formats and Format Codes....................................................................1864
49.2. Message Flow.....................................................................................................1865
49.2.1. Start-up...................................................................................................1865
49.2.2. Simple Query.........................................................................................1867
49.2.3. Extended Query .....................................................................................1868
xxx
Documents you may be interested
Documents you may be interested