pdf viewer for asp.net web application : How to add an image to a pdf software control project winforms web page asp.net UWP postgresql-9.4-A42-part2834

35.13.4.
JOIN
.......................................................................................................961
35.13.5.
HASHES
...................................................................................................962
35.13.6.
MERGES
...................................................................................................963
35.14. Interfacing Extensions To Indexes......................................................................963
35.14.1. Index Methods and Operator Classes ....................................................964
35.14.2. Index Method Strategies........................................................................964
35.14.3. Index Method Support Routines............................................................966
35.14.4. An Example ...........................................................................................969
35.14.5. Operator Classes and Operator Families................................................971
35.14.6. System Dependencies on Operator Classes...........................................973
35.14.7. Ordering Operators ................................................................................974
35.14.8. Special Features of Operator Classes.....................................................975
35.15. Packaging Related Objects into an Extension....................................................975
35.15.1. Extension Files.......................................................................................976
35.15.2. Extension Relocatability........................................................................978
35.15.3. Extension Configuration Tables.............................................................979
35.15.4. Extension Updates .................................................................................979
35.15.5. Extension Example ................................................................................981
35.16. Extension Building Infrastructure ......................................................................982
36. Triggers.............................................................................................................................985
36.1. Overview of Trigger Behavior..............................................................................985
36.2. Visibility of Data Changes....................................................................................987
36.3. Writing Trigger Functions in C............................................................................988
36.4. A Complete Trigger Example...............................................................................990
37. Event Triggers...................................................................................................................994
37.1. Overview of Event Trigger Behavior ...................................................................994
37.2. Event Trigger Firing Matrix.................................................................................994
37.3. Writing Event Trigger Functions in C..................................................................997
37.4. A Complete Event Trigger Example ....................................................................998
38. The Rule System .............................................................................................................1000
38.1. The Query Tree...................................................................................................1000
38.2. Views and the Rule System ................................................................................1002
38.2.1. How
SELECT
Rules Work......................................................................1002
38.2.2. View Rules in Non-
SELECT
Statements................................................1007
38.2.3. The Power of Views in PostgreSQL ......................................................1008
38.2.4. Updating a View.....................................................................................1008
38.3. Materialized Views.............................................................................................1009
38.4. Rules on
INSERT
,
UPDATE
,and
DELETE
...........................................................1011
38.4.1. How Update Rules Work.......................................................................1012
38.4.1.1. A First Rule Step by Step..........................................................1013
38.4.2. Cooperation with Views.........................................................................1016
38.5. Rules and Privileges ...........................................................................................1022
38.6. Rules and Command Status................................................................................1024
38.7. Rules Versus Triggers.........................................................................................1024
39. Procedural Languages.....................................................................................................1027
39.1. Installing Procedural Languages ........................................................................1027
40. PL/pgSQL - SQL Procedural Language.........................................................................1030
40.1. Overview ............................................................................................................1030
40.1.1. Advantages of Using PL/pgSQL ...........................................................1030
40.1.2. Supported Argument and Result Data Types.........................................1030
40.2. Structure of PL/pgSQL.......................................................................................1031
40.3. Declarations........................................................................................................1032
xxi
How to add an image to a pdf - insert images into PDF in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Sample C# code to add image, picture, logo or digital photo into PDF document page using PDF page editor control
add a picture to a pdf; add picture to pdf document
How to add an image to a pdf - VB.NET PDF insert image library: insert images into PDF in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Guide VB.NET Programmers How to Add Images in PDF Document
add an image to a pdf form; add picture to pdf form
40.3.1. Declaring Function Parameters..............................................................1033
40.3.2.
ALIAS
.....................................................................................................1035
40.3.3. Copying Types .......................................................................................1036
40.3.4. Row Types..............................................................................................1036
40.3.5. Record Types .........................................................................................1037
40.3.6. Collation of PL/pgSQL Variables..........................................................1037
40.4. Expressions.........................................................................................................1038
40.5. Basic Statements.................................................................................................1039
40.5.1. Assignment............................................................................................1039
40.5.2. Executing a Command With No Result.................................................1039
40.5.3. Executing a Query with a Single-row Result.........................................1040
40.5.4. Executing Dynamic Commands ............................................................1042
40.5.5. Obtaining the Result Status....................................................................1044
40.5.6. Doing Nothing At All............................................................................1045
40.6. Control Structures...............................................................................................1046
40.6.1. Returning From a Function....................................................................1046
40.6.1.1.
RETURN
......................................................................................1046
40.6.1.2.
RETURN NEXT
and
RETURN QUERY
.........................................1047
40.6.2. Conditionals...........................................................................................1048
40.6.2.1.
IF-THEN
....................................................................................1049
40.6.2.2.
IF-THEN-ELSE
.........................................................................1049
40.6.2.3.
IF-THEN-ELSIF
.......................................................................1050
40.6.2.4. Simple
CASE
..............................................................................1051
40.6.2.5. Searched
CASE
...........................................................................1051
40.6.3. Simple Loops.........................................................................................1052
40.6.3.1.
LOOP
..........................................................................................1052
40.6.3.2.
EXIT
..........................................................................................1052
40.6.3.3.
CONTINUE
..................................................................................1053
40.6.3.4.
WHILE
........................................................................................1053
40.6.3.5.
FOR
(Integer Variant).................................................................1054
40.6.4. Looping Through Query Results ...........................................................1054
40.6.5. Looping Through Arrays .......................................................................1055
40.6.6. Trapping Errors......................................................................................1057
40.6.6.1. Obtaining Information About an Error......................................1058
40.6.7. Obtaining Current Execution Information.............................................1060
40.7. Cursors................................................................................................................1060
40.7.1. Declaring Cursor Variables....................................................................1061
40.7.2. Opening Cursors ....................................................................................1061
40.7.2.1.
OPEN FOR query
......................................................................1061
40.7.2.2.
OPEN FOR EXECUTE
................................................................1062
40.7.2.3. Opening a Bound Cursor...........................................................1062
40.7.3. Using Cursors.........................................................................................1063
40.7.3.1.
FETCH
........................................................................................1063
40.7.3.2.
MOVE
..........................................................................................1064
40.7.3.3.
UPDATE/DELETE WHERE CURRENT OF
..................................1064
40.7.3.4.
CLOSE
........................................................................................1064
40.7.3.5. Returning Cursors .....................................................................1065
40.7.4. Looping Through a Cursor’s Result.......................................................1066
40.8. Errors and Messages...........................................................................................1066
40.9. Trigger Procedures .............................................................................................1068
40.9.1. Triggers on Data Changes......................................................................1068
40.9.2. Triggers on Events .................................................................................1075
xxii
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
Get image information, such as its location, zonal information, metadata, and so on. Able to edit, add, delete, move, and output PDF document image.
add image to pdf acrobat reader; how to add a jpg to a pdf
VB.NET PDF Password Library: add, remove, edit PDF file password
VB: Add Password to PDF with Permission Settings Applied. This VB.NET example shows how to add PDF file password with access permission setting.
add an image to a pdf acrobat; how to add jpg to pdf file
40.10. PL/pgSQL Under the Hood..............................................................................1076
40.10.1. Variable Substitution............................................................................1076
40.10.2. PlanCaching........................................................................................1078
40.11. Tips for Developing in PL/pgSQL....................................................................1079
40.11.1. Handling of Quotation Marks..............................................................1080
40.11.2. Additional Compile-time Checks ........................................................1081
40.12. Porting from Oracle PL/SQL............................................................................1082
40.12.1. Porting Examples.................................................................................1083
40.12.2. Other Things to Watch For...................................................................1088
40.12.2.1. Implicit Rollback after Exceptions..........................................1088
40.12.2.2.
EXECUTE
..................................................................................1088
40.12.2.3. Optimizing PL/pgSQL Functions............................................1089
40.12.3. Appendix..............................................................................................1089
41. PL/Tcl - Tcl Procedural Language..................................................................................1092
41.1. Overview ............................................................................................................1092
41.2. PL/Tcl Functions andArguments.......................................................................1092
41.3. Data Values in PL/Tcl.........................................................................................1093
41.4. Global Data in PL/Tcl ........................................................................................1094
41.5. Database Access from PL/Tcl............................................................................1094
41.6. Trigger Procedures in PL/Tcl.............................................................................1096
41.7. Event Trigger Procedures in PL/Tcl...................................................................1098
41.8. Modules and the
unknown
Command................................................................1098
41.9. Tcl Procedure Names .........................................................................................1099
42. PL/Perl - Perl Procedural Language................................................................................1100
42.1. PL/Perl Functions and Arguments......................................................................1100
42.2. Data Values in PL/Perl........................................................................................1104
42.3. Built-in Functions...............................................................................................1104
42.3.1. Database Access from PL/Perl...............................................................1104
42.3.2. Utility Functions in PL/Perl...................................................................1107
42.4. Global Values in PL/Perl....................................................................................1108
42.5. Trustedand Untrusted PL/Perl...........................................................................1109
42.6. PL/Perl Triggers .................................................................................................1110
42.7. PL/Perl Event Triggers .......................................................................................1112
42.8. PL/Perl Under the Hood.....................................................................................1112
42.8.1. Configuration.........................................................................................1112
42.8.2. Limitations and Missing Features..........................................................1113
43. PL/Python - Python Procedural Language......................................................................1115
43.1. Python 2 vs. Python 3.........................................................................................1115
43.2. PL/Python Functions ..........................................................................................1116
43.3. Data Values.........................................................................................................1117
43.3.1. Data Type Mapping................................................................................1118
43.3.2. Null, None..............................................................................................1118
43.3.3. Arrays, Lists...........................................................................................1119
43.3.4. Composite Types....................................................................................1119
43.3.5. Set-returning Functions..........................................................................1121
43.4. Sharing Data.......................................................................................................1122
43.5. Anonymous Code Blocks...................................................................................1123
43.6. Trigger Functions ...............................................................................................1123
43.7. Database Access.................................................................................................1124
43.7.1. Database Access Functions....................................................................1124
43.7.2. Trapping Errors......................................................................................1126
43.8. Explicit Subtransactions .....................................................................................1127
xxiii
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
DLLs for PDF Image Extraction in VB.NET. In order to run the sample code, the following steps would be necessary. Add necessary references:
adding an image to a pdf; acrobat insert image in pdf
C# PDF Password Library: add, remove, edit PDF file password in C#
C# Sample Code: Add Password to PDF with Permission Settings Applied in C#.NET. This example shows how to add PDF file password with access permission setting.
add photo to pdf for; adding images to a pdf document
43.8.1. Subtransaction Context Managers .........................................................1127
43.8.2. Older Python Versions ...........................................................................1128
43.9. Utility Functions.................................................................................................1129
43.10. Environment Variables .....................................................................................1130
44. Server Programming Interface........................................................................................1131
44.1. Interface Functions.............................................................................................1131
SPI_connect .......................................................................................................1131
SPI_finish...........................................................................................................1133
SPI_push............................................................................................................1134
SPI_pop..............................................................................................................1135
SPI_execute........................................................................................................1136
SPI_exec.............................................................................................................1139
SPI_execute_with_args......................................................................................1140
SPI_prepare........................................................................................................1142
SPI_prepare_cursor............................................................................................1144
SPI_prepare_params..........................................................................................1145
SPI_getargcount.................................................................................................1146
SPI_getargtypeid................................................................................................1147
SPI_is_cursor_plan............................................................................................1148
SPI_execute_plan...............................................................................................1149
SPI_execute_plan_with_paramlist.....................................................................1151
SPI_execp...........................................................................................................1152
SPI_cursor_open................................................................................................1153
SPI_cursor_open_with_args ..............................................................................1155
SPI_cursor_open_with_paramlist......................................................................1157
SPI_cursor_find..................................................................................................1158
SPI_cursor_fetch................................................................................................1159
SPI_cursor_move...............................................................................................1160
SPI_scroll_cursor_fetch.....................................................................................1161
SPI_scroll_cursor_move....................................................................................1162
SPI_cursor_close................................................................................................1163
SPI_keepplan.....................................................................................................1164
SPI_saveplan......................................................................................................1165
44.2. Interface Support Functions ...............................................................................1166
SPI_fname..........................................................................................................1166
SPI_fnumber ......................................................................................................1167
SPI_getvalue......................................................................................................1168
SPI_getbinval.....................................................................................................1169
SPI_gettype........................................................................................................1170
SPI_gettypeid.....................................................................................................1171
SPI_getrelname..................................................................................................1172
SPI_getnspname.................................................................................................1173
44.3. Memory Management ........................................................................................1174
SPI_palloc..........................................................................................................1174
SPI_repalloc.......................................................................................................1176
SPI_pfree............................................................................................................1177
SPI_copytuple....................................................................................................1178
SPI_returntuple..................................................................................................1179
SPI_modifytuple................................................................................................1180
SPI_freetuple......................................................................................................1182
SPI_freetuptable.................................................................................................1183
SPI_freeplan.......................................................................................................1184
xxiv
C# Create PDF from images Library to convert Jpeg, png images to
List<Bitmap> images = new List<Bitmap>(); images.Add(new Bitmap(Program.RootPath + "\\" 1.gif")); / Build a PDF document with GIF image.
adding a jpeg to a pdf; add signature image to pdf
C# PDF Sticky Note Library: add, delete, update PDF note in C#.net
C#.NET PDF SDK - Add Sticky Note to PDF Page in C#.NET. Able to add notes to PDF using C# source code in Visual Studio .NET framework.
add jpg to pdf form; adding an image to a pdf in acrobat
44.4. Visibility of Data Changes..................................................................................1185
44.5. Examples ............................................................................................................1185
45. Background Worker Processes........................................................................................1189
46. Logical Decoding............................................................................................................1192
46.1. Logical Decoding Examples...............................................................................1192
46.2. Logical Decoding Concepts ...............................................................................1194
46.2.1. Logical Decoding...................................................................................1194
46.2.2. ReplicationSlots....................................................................................1194
46.2.3. Output Plugins .......................................................................................1195
46.2.4. Exported Snapshots................................................................................1195
46.3. Streaming Replication Protocol Interface ..........................................................1195
46.4. Logical Decoding SQL Interface........................................................................1195
46.5. System Catalogs Related to Logical Decoding..................................................1196
46.6. Logical Decoding Output Plugins......................................................................1196
46.6.1. Initialization Function............................................................................1196
46.6.2. Capabilities ............................................................................................1196
46.6.3. Output Modes.........................................................................................1197
46.6.4. Output Plugin Callbacks ........................................................................1197
46.6.4.1. Startup Callback........................................................................1197
46.6.4.2. Shutdown Callback....................................................................1197
46.6.4.3. Transaction Begin Callback ......................................................1198
46.6.4.4. Transaction End Callback .........................................................1198
46.6.4.5. Change Callback .......................................................................1198
46.6.5. Functions for Producing Output.............................................................1199
46.7. Logical Decoding Output Writers......................................................................1199
46.8. Synchronous Replication Support for Logical Decoding...................................1199
VI. Reference.................................................................................................................................1200
I. SQL Commands.................................................................................................................1202
ABORT........................................................................................................................1203
ALTER AGGREGATE................................................................................................1205
ALTER COLLATION.................................................................................................1207
ALTER CONVERSION..............................................................................................1209
ALTER DATABASE ...................................................................................................1211
ALTER DEFAULT PRIVILEGES ..............................................................................1213
ALTER DOMAIN.......................................................................................................1216
ALTER EVENT TRIGGER........................................................................................1220
ALTER EXTENSION.................................................................................................1221
ALTER FOREIGN DATA WRAPPER.......................................................................1225
ALTER FOREIGN TABLE.........................................................................................1227
ALTER FUNCTION...................................................................................................1231
ALTER GROUP ..........................................................................................................1234
ALTER INDEX...........................................................................................................1236
ALTER LANGUAGE..................................................................................................1239
ALTER LARGE OBJECT...........................................................................................1240
ALTER MATERIALIZED VIEW...............................................................................1241
ALTER OPERATOR...................................................................................................1243
ALTER OPERATOR CLASS......................................................................................1245
ALTER OPERATOR FAMILY...................................................................................1246
ALTER ROLE .............................................................................................................1250
ALTER RULE .............................................................................................................1254
ALTER SCHEMA.......................................................................................................1255
xxv
C# PDF remove image library: remove, delete images from PDF in C#.
C# Read: PDF Image Extract; C# Write: Insert text into PDF; C# Write: Add Image to PDF; Remove Image from PDF Page Using C#. Add necessary references:
add image to pdf preview; add jpg to pdf file
VB.NET PDF remove image library: remove, delete images from PDF in
C# Read: PDF Image Extract; C# Write: Insert text into PDF; C# Write: Add Image to PDF; VB.NET: Remove Image from PDF Page. Add necessary references:
add a jpeg to a pdf; add jpeg signature to pdf
ALTER SEQUENCE...................................................................................................1256
ALTER SERVER.........................................................................................................1259
ALTER SYSTEM........................................................................................................1261
ALTER TABLE...........................................................................................................1263
ALTER TABLESPACE...............................................................................................1275
ALTER TEXT SEARCH CONFIGURATION...........................................................1277
ALTER TEXT SEARCH DICTIONARY...................................................................1279
ALTER TEXT SEARCH PARSER.............................................................................1281
ALTER TEXT SEARCH TEMPLATE.......................................................................1282
ALTER TRIGGER......................................................................................................1283
ALTER TYPE..............................................................................................................1285
ALTER USER .............................................................................................................1289
ALTER USER MAPPING..........................................................................................1290
ALTER VIEW.............................................................................................................1292
ANALYZE...................................................................................................................1294
BEGIN.........................................................................................................................1297
CHECKPOINT............................................................................................................1299
CLOSE ........................................................................................................................1300
CLUSTER ...................................................................................................................1302
COMMENT.................................................................................................................1305
COMMIT.....................................................................................................................1309
COMMIT PREPARED................................................................................................1310
COPY ..........................................................................................................................1312
CREATE AGGREGATE.............................................................................................1322
CREATE CAST...........................................................................................................1328
CREATE COLLATION...............................................................................................1333
CREATE CONVERSION...........................................................................................1335
CREATE DATABASE.................................................................................................1337
CREATE DOMAIN.....................................................................................................1340
CREATE EVENT TRIGGER......................................................................................1343
CREATE EXTENSION...............................................................................................1345
CREATE FOREIGN DATA WRAPPER.....................................................................1347
CREATE FOREIGN TABLE......................................................................................1349
CREATE FUNCTION.................................................................................................1352
CREATE GROUP........................................................................................................1360
CREATE INDEX.........................................................................................................1361
CREATE LANGUAGE...............................................................................................1368
CREATE MATERIALIZED VIEW............................................................................1371
CREATE OPERATOR ................................................................................................1373
CREATE OPERATOR CLASS...................................................................................1376
CREATE OPERATOR FAMILY.................................................................................1379
CREATE ROLE...........................................................................................................1381
CREATE RULE...........................................................................................................1386
CREATE SCHEMA ....................................................................................................1389
CREATE SEQUENCE................................................................................................1392
CREATE SERVER......................................................................................................1396
CREATE TABLE ........................................................................................................1398
CREATE TABLE AS ..................................................................................................1413
CREATE TABLESPACE.............................................................................................1416
CREATE TEXT SEARCH CONFIGURATION.........................................................1418
CREATE TEXT SEARCH DICTIONARY.................................................................1420
CREATE TEXT SEARCH PARSER..........................................................................1422
xxvi
CREATE TEXT SEARCH TEMPLATE.....................................................................1424
CREATE TRIGGER....................................................................................................1426
CREATE TYPE...........................................................................................................1432
CREATE USER...........................................................................................................1441
CREATE USER MAPPING........................................................................................1442
CREATE VIEW...........................................................................................................1444
DEALLOCATE...........................................................................................................1449
DECLARE...................................................................................................................1450
DELETE......................................................................................................................1454
DISCARD....................................................................................................................1457
DO...............................................................................................................................1459
DROP AGGREGATE..................................................................................................1461
DROP CAST ...............................................................................................................1463
DROP COLLATION...................................................................................................1465
DROP CONVERSION................................................................................................1466
DROP DATABASE .....................................................................................................1467
DROP DOMAIN.........................................................................................................1468
DROP EVENT TRIGGER..........................................................................................1469
DROP EXTENSION...................................................................................................1470
DROP FOREIGN DATA WRAPPER.........................................................................1472
DROP FOREIGN TABLE...........................................................................................1473
DROP FUNCTION.....................................................................................................1474
DROP GROUP ............................................................................................................1476
DROP INDEX.............................................................................................................1477
DROP LANGUAGE....................................................................................................1479
DROP MATERIALIZED VIEW.................................................................................1481
DROP OPERATOR.....................................................................................................1483
DROP OPERATOR CLASS........................................................................................1485
DROP OPERATOR FAMILY .....................................................................................1487
DROP OWNED...........................................................................................................1489
DROP ROLE ...............................................................................................................1491
DROP RULE ...............................................................................................................1493
DROP SCHEMA.........................................................................................................1495
DROP SEQUENCE.....................................................................................................1497
DROP SERVER...........................................................................................................1498
DROP TABLE.............................................................................................................1499
DROP TABLESPACE .................................................................................................1501
DROP TEXT SEARCH CONFIGURATION.............................................................1503
DROP TEXT SEARCH DICTIONARY.....................................................................1505
DROP TEXT SEARCH PARSER...............................................................................1506
DROP TEXT SEARCH TEMPLATE.........................................................................1507
DROP TRIGGER........................................................................................................1508
DROP TYPE................................................................................................................1510
DROP USER ...............................................................................................................1511
DROP USER MAPPING............................................................................................1512
DROP VIEW...............................................................................................................1514
END.............................................................................................................................1515
EXECUTE...................................................................................................................1516
EXPLAIN....................................................................................................................1518
FETCH........................................................................................................................1523
GRANT .......................................................................................................................1527
INSERT .......................................................................................................................1534
xxvii
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
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
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