Gecko [ finalhopeacademy.com ]

/ usr / share / doc / postgresql-9.2.24 / html / [ HOME SHELL ]

Name	Size	Permission
LEGALNOTICE.html	2.62 KB	-rw-r--r--
acronyms.html	15.9 KB	-rw-r--r--
admin.html	12.27 KB	-rw-r--r--
adminpack.html	7.7 KB	-rw-r--r--
app-clusterdb.html	10.35 KB	-rw-r--r--
app-createdb.html	12.55 KB	-rw-r--r--
app-createlang.html	9.67 KB	-rw-r--r--
app-createuser.html	15.27 KB	-rw-r--r--
app-dropdb.html	9.42 KB	-rw-r--r--
app-droplang.html	9.41 KB	-rw-r--r--
app-dropuser.html	9.37 KB	-rw-r--r--
app-ecpg.html	8.51 KB	-rw-r--r--
app-initdb.html	15.04 KB	-rw-r--r--
app-pg-ctl.html	21.93 KB	-rw-r--r--
app-pg-dumpall.html	20.22 KB	-rw-r--r--
app-pgbasebackup.html	19.37 KB	-rw-r--r--
app-pgconfig.html	10.83 KB	-rw-r--r--
app-pgcontroldata.html	3.89 KB	-rw-r--r--
app-pgdump.html	42.93 KB	-rw-r--r--
app-pgreceivexlog.html	10.8 KB	-rw-r--r--
app-pgresetxlog.html	11.29 KB	-rw-r--r--
app-pgrestore.html	29.56 KB	-rw-r--r--
app-postgres.html	31.08 KB	-rw-r--r--
app-postmaster.html	2.93 KB	-rw-r--r--
app-psql.html	135.62 KB	-rw-r--r--
app-reindexdb.html	11.02 KB	-rw-r--r--
app-vacuumdb.html	12.32 KB	-rw-r--r--
appendixes.html	25.71 KB	-rw-r--r--
applevel-consistency.html	10.07 KB	-rw-r--r--
archive-recovery-settings.html	7.17 KB	-rw-r--r--
arrays.html	27.42 KB	-rw-r--r--
auth-delay.html	3.69 KB	-rw-r--r--
auth-methods.html	35.35 KB	-rw-r--r--
auth-pg-hba-conf.html	29.06 KB	-rw-r--r--
auth-username-maps.html	8.4 KB	-rw-r--r--
auto-explain.html	9.66 KB	-rw-r--r--
backup-dump.html	15.55 KB	-rw-r--r--
backup-file.html	7.81 KB	-rw-r--r--
backup.html	4.38 KB	-rw-r--r--
biblio.html	11.28 KB	-rw-r--r--
bki-commands.html	9.42 KB	-rw-r--r--
bki-example.html	2.98 KB	-rw-r--r--
bki-format.html	3.38 KB	-rw-r--r--
bki-structure.html	4.22 KB	-rw-r--r--
bki.html	4.23 KB	-rw-r--r--
bookindex.html	237.47 KB	-rw-r--r--
btree-gin.html	4.49 KB	-rw-r--r--
btree-gist.html	6.72 KB	-rw-r--r--
bug-reporting.html	18.21 KB	-rw-r--r--
catalog-pg-aggregate.html	5.37 KB	-rw-r--r--
catalog-pg-am.html	10.3 KB	-rw-r--r--
catalog-pg-amop.html	7.42 KB	-rw-r--r--
catalog-pg-amproc.html	4.77 KB	-rw-r--r--
catalog-pg-attrdef.html	4.26 KB	-rw-r--r--
catalog-pg-attribute.html	10.05 KB	-rw-r--r--
catalog-pg-auth-members.html	4.16 KB	-rw-r--r--
catalog-pg-authid.html	6.66 KB	-rw-r--r--
catalog-pg-cast.html	6.79 KB	-rw-r--r--
catalog-pg-class.html	12.36 KB	-rw-r--r--
catalog-pg-collation.html	5.76 KB	-rw-r--r--
catalog-pg-constraint.html	11.31 KB	-rw-r--r--
catalog-pg-conversion.html	4.33 KB	-rw-r--r--
catalog-pg-database.html	6.86 KB	-rw-r--r--
catalog-pg-db-role-setting.htm...	3.97 KB	-rw-r--r--
catalog-pg-default-acl.html	5.14 KB	-rw-r--r--
catalog-pg-depend.html	8.43 KB	-rw-r--r--
catalog-pg-description.html	4.37 KB	-rw-r--r--
catalog-pg-enum.html	4.61 KB	-rw-r--r--
catalog-pg-extension.html	5.16 KB	-rw-r--r--
catalog-pg-foreign-data-wrappe...	4.83 KB	-rw-r--r--
catalog-pg-foreign-server.html	4.58 KB	-rw-r--r--
catalog-pg-foreign-table.html	3.94 KB	-rw-r--r--
catalog-pg-index.html	8.66 KB	-rw-r--r--
catalog-pg-inherits.html	3.8 KB	-rw-r--r--
catalog-pg-language.html	5.81 KB	-rw-r--r--
catalog-pg-largeobject-metadat...	3.54 KB	-rw-r--r--
catalog-pg-largeobject.html	5.03 KB	-rw-r--r--
catalog-pg-namespace.html	3.66 KB	-rw-r--r--
catalog-pg-opclass.html	5.73 KB	-rw-r--r--
catalog-pg-operator.html	6.49 KB	-rw-r--r--
catalog-pg-opfamily.html	4.7 KB	-rw-r--r--
catalog-pg-pltemplate.html	5.24 KB	-rw-r--r--
catalog-pg-proc.html	13.09 KB	-rw-r--r--
catalog-pg-range.html	5.06 KB	-rw-r--r--
catalog-pg-rewrite.html	5.26 KB	-rw-r--r--
catalog-pg-seclabel.html	4.41 KB	-rw-r--r--
catalog-pg-shdepend.html	6.88 KB	-rw-r--r--
catalog-pg-shdescription.html	4.15 KB	-rw-r--r--
catalog-pg-shseclabel.html	4.3 KB	-rw-r--r--
catalog-pg-statistic.html	9.31 KB	-rw-r--r--
catalog-pg-tablespace.html	4.06 KB	-rw-r--r--
catalog-pg-trigger.html	8.09 KB	-rw-r--r--
catalog-pg-ts-config-map.html	4.09 KB	-rw-r--r--
catalog-pg-ts-config.html	4.38 KB	-rw-r--r--
catalog-pg-ts-dict.html	4.61 KB	-rw-r--r--
catalog-pg-ts-parser.html	4.96 KB	-rw-r--r--
catalog-pg-ts-template.html	4.16 KB	-rw-r--r--
catalog-pg-type.html	19.44 KB	-rw-r--r--
catalog-pg-user-mapping.html	3.76 KB	-rw-r--r--
catalogs-overview.html	10.19 KB	-rw-r--r--
catalogs.html	10.14 KB	-rw-r--r--
charset.html	4.06 KB	-rw-r--r--
chkpass.html	4.29 KB	-rw-r--r--
citext.html	10.89 KB	-rw-r--r--
client-authentication-problems...	4.13 KB	-rw-r--r--
client-authentication.html	5.78 KB	-rw-r--r--
client-interfaces.html	13.4 KB	-rw-r--r--
collation.html	13.89 KB	-rw-r--r--
config-setting.html	10.88 KB	-rw-r--r--
connect-estab.html	4.21 KB	-rw-r--r--
continuous-archiving.html	48.66 KB	-rw-r--r--
contrib-dblink-build-sql-delet...	5.32 KB	-rw-r--r--
contrib-dblink-build-sql-inser...	5.91 KB	-rw-r--r--
contrib-dblink-build-sql-updat...	6.13 KB	-rw-r--r--
contrib-dblink-cancel-query.ht...	3.73 KB	-rw-r--r--
contrib-dblink-close.html	4.54 KB	-rw-r--r--
contrib-dblink-connect-u.html	4.38 KB	-rw-r--r--
contrib-dblink-connect.html	7.15 KB	-rw-r--r--
contrib-dblink-disconnect.html	3.63 KB	-rw-r--r--
contrib-dblink-error-message.h...	3.43 KB	-rw-r--r--
contrib-dblink-exec.html	5.34 KB	-rw-r--r--
contrib-dblink-fetch.html	5.84 KB	-rw-r--r--
contrib-dblink-function.html	8.43 KB	-rw-r--r--
contrib-dblink-get-connections...	3.13 KB	-rw-r--r--
contrib-dblink-get-notify.html	4.07 KB	-rw-r--r--
contrib-dblink-get-pkey.html	4.39 KB	-rw-r--r--
contrib-dblink-get-result.html	6.8 KB	-rw-r--r--
contrib-dblink-is-busy.html	3.41 KB	-rw-r--r--
contrib-dblink-open.html	5.34 KB	-rw-r--r--
contrib-dblink-send-query.html	4.07 KB	-rw-r--r--
contrib-prog-client.html	3.35 KB	-rw-r--r--
contrib-prog-server.html	3.75 KB	-rw-r--r--
contrib-prog.html	3.24 KB	-rw-r--r--
contrib-spi.html	10.97 KB	-rw-r--r--
contrib.html	8.7 KB	-rw-r--r--
creating-cluster.html	12.17 KB	-rw-r--r--
cube.html	15.57 KB	-rw-r--r--
database-roles.html	5.95 KB	-rw-r--r--
datatype-binary.html	12.59 KB	-rw-r--r--
datatype-bit.html	4.98 KB	-rw-r--r--
datatype-boolean.html	5.14 KB	-rw-r--r--
datatype-character.html	11.61 KB	-rw-r--r--
datatype-datetime.html	49.57 KB	-rw-r--r--
datatype-enum.html	6.28 KB	-rw-r--r--
datatype-geometric.html	12.21 KB	-rw-r--r--
datatype-json.html	3.36 KB	-rw-r--r--
datatype-money.html	5.35 KB	-rw-r--r--
datatype-net-types.html	10.18 KB	-rw-r--r--
datatype-numeric.html	21.83 KB	-rw-r--r--
datatype-oid.html	9.46 KB	-rw-r--r--
datatype-pseudo.html	7.11 KB	-rw-r--r--
datatype-textsearch.html	9.8 KB	-rw-r--r--
datatype-uuid.html	4.45 KB	-rw-r--r--
datatype-xml.html	11.07 KB	-rw-r--r--
datatype.html	16.22 KB	-rw-r--r--
datetime-appendix.html	3.44 KB	-rw-r--r--
datetime-config-files.html	8.77 KB	-rw-r--r--
datetime-input-rules.html	6.6 KB	-rw-r--r--
datetime-keywords.html	4.98 KB	-rw-r--r--
datetime-units-history.html	7.46 KB	-rw-r--r--
dblink.html	5.2 KB	-rw-r--r--
ddl-alter.html	10.25 KB	-rw-r--r--
ddl-basics.html	7.63 KB	-rw-r--r--
ddl-constraints.html	22.26 KB	-rw-r--r--
ddl-default.html	4.43 KB	-rw-r--r--
ddl-depend.html	6.35 KB	-rw-r--r--
ddl-foreign-data.html	4.38 KB	-rw-r--r--
ddl-inherit.html	14.95 KB	-rw-r--r--
ddl-others.html	3.01 KB	-rw-r--r--
ddl-partitioning.html	27.11 KB	-rw-r--r--
ddl-priv.html	5.92 KB	-rw-r--r--
ddl-schemas.html	17.62 KB	-rw-r--r--
ddl-system-columns.html	7.86 KB	-rw-r--r--
ddl.html	6.23 KB	-rw-r--r--
dict-int.html	4.68 KB	-rw-r--r--
dict-xsyn.html	6.33 KB	-rw-r--r--
different-replication-solution...	14.45 KB	-rw-r--r--
disk-full.html	3.43 KB	-rw-r--r--
disk-usage.html	5.53 KB	-rw-r--r--
diskusage.html	2.61 KB	-rw-r--r--
dml-delete.html	3.48 KB	-rw-r--r--
dml-insert.html	5.67 KB	-rw-r--r--
dml-returning.html	4.98 KB	-rw-r--r--
dml-update.html	5.43 KB	-rw-r--r--
dml.html	2.88 KB	-rw-r--r--
docguide-authoring.html	6.6 KB	-rw-r--r--
docguide-build.html	14.92 KB	-rw-r--r--
docguide-docbook.html	3.76 KB	-rw-r--r--
docguide-style.html	7.25 KB	-rw-r--r--
docguide-toolsets.html	20.2 KB	-rw-r--r--
docguide.html	3.54 KB	-rw-r--r--
dummy-seclabel.html	4.26 KB	-rw-r--r--
dynamic-trace.html	26.6 KB	-rw-r--r--
earthdistance.html	8.6 KB	-rw-r--r--
ecpg-commands.html	9.3 KB	-rw-r--r--
ecpg-concept.html	4.86 KB	-rw-r--r--
ecpg-connect.html	10.57 KB	-rw-r--r--
ecpg-cpp.html	9.4 KB	-rw-r--r--
ecpg-descriptors.html	34.09 KB	-rw-r--r--
ecpg-develop.html	7.78 KB	-rw-r--r--
ecpg-dynamic.html	6.36 KB	-rw-r--r--
ecpg-errors.html	25.13 KB	-rw-r--r--
ecpg-informix-compat.html	51.52 KB	-rw-r--r--
ecpg-library.html	5.66 KB	-rw-r--r--
ecpg-lo.html	5.4 KB	-rw-r--r--
ecpg-pgtypes.html	53.18 KB	-rw-r--r--
ecpg-preproc.html	8.77 KB	-rw-r--r--
ecpg-process.html	5.26 KB	-rw-r--r--
ecpg-sql-allocate-descriptor.h...	3.89 KB	-rw-r--r--
ecpg-sql-commands.html	4.59 KB	-rw-r--r--
ecpg-sql-connect.html	9.16 KB	-rw-r--r--
ecpg-sql-deallocate-descriptor...	3.68 KB	-rw-r--r--
ecpg-sql-declare.html	5.27 KB	-rw-r--r--
ecpg-sql-describe.html	4.49 KB	-rw-r--r--
ecpg-sql-disconnect.html	4.62 KB	-rw-r--r--
ecpg-sql-execute-immediate.htm...	3.79 KB	-rw-r--r--
ecpg-sql-get-descriptor.html	7.53 KB	-rw-r--r--
ecpg-sql-open.html	4.53 KB	-rw-r--r--
ecpg-sql-prepare.html	4.08 KB	-rw-r--r--
ecpg-sql-set-autocommit.html	3.25 KB	-rw-r--r--
ecpg-sql-set-connection.html	3.84 KB	-rw-r--r--
ecpg-sql-set-descriptor.html	5.38 KB	-rw-r--r--
ecpg-sql-type.html	4.91 KB	-rw-r--r--
ecpg-sql-var.html	3.46 KB	-rw-r--r--
ecpg-sql-whenever.html	4.58 KB	-rw-r--r--
ecpg-variables.html	39.34 KB	-rw-r--r--
ecpg.html	10.1 KB	-rw-r--r--
encryption-options.html	7.32 KB	-rw-r--r--
errcodes-appendix.html	36.1 KB	-rw-r--r--
error-message-reporting.html	13.79 KB	-rw-r--r--
error-style-guide.html	16.38 KB	-rw-r--r--
event-log-registration.html	4.09 KB	-rw-r--r--
executor.html	6.46 KB	-rw-r--r--
explicit-joins.html	10.76 KB	-rw-r--r--
explicit-locking.html	24.49 KB	-rw-r--r--
extend-extensions.html	31.67 KB	-rw-r--r--
extend-how.html	4.45 KB	-rw-r--r--
extend-pgxs.html	11.49 KB	-rw-r--r--
extend-type-system.html	9.87 KB	-rw-r--r--
extend.html	9.75 KB	-rw-r--r--
external-admin-tools.html	2.66 KB	-rw-r--r--
external-extensions.html	3.19 KB	-rw-r--r--
external-interfaces.html	5.38 KB	-rw-r--r--
external-pl.html	4.56 KB	-rw-r--r--
external-projects.html	2.93 KB	-rw-r--r--
fdw-callbacks.html	12.6 KB	-rw-r--r--
fdw-functions.html	4.39 KB	-rw-r--r--
fdw-helpers.html	5.85 KB	-rw-r--r--
fdw-planning.html	9.61 KB	-rw-r--r--
fdwhandler.html	3.9 KB	-rw-r--r--
features-sql-standard.html	38.19 KB	-rw-r--r--
features.html	7.39 KB	-rw-r--r--
file-fdw.html	7.53 KB	-rw-r--r--
functions-admin.html	49.21 KB	-rw-r--r--
functions-aggregate.html	21.3 KB	-rw-r--r--
functions-array.html	13.2 KB	-rw-r--r--
functions-binarystring.html	12.29 KB	-rw-r--r--
functions-bitstring.html	6.63 KB	-rw-r--r--
functions-comparison.html	10.39 KB	-rw-r--r--
functions-comparisons.html	13.21 KB	-rw-r--r--
functions-conditional.html	10.75 KB	-rw-r--r--
functions-datetime.html	47.17 KB	-rw-r--r--
functions-enum.html	5.36 KB	-rw-r--r--
functions-formatting.html	34.57 KB	-rw-r--r--
functions-geometry.html	19.87 KB	-rw-r--r--
functions-info.html	57.28 KB	-rw-r--r--
functions-json.html	3.72 KB	-rw-r--r--
functions-logical.html	4.56 KB	-rw-r--r--
functions-matching.html	73.95 KB	-rw-r--r--
functions-math.html	19.92 KB	-rw-r--r--
functions-net.html	13.19 KB	-rw-r--r--
functions-range.html	10.6 KB	-rw-r--r--
functions-sequence.html	12.62 KB	-rw-r--r--
functions-srf.html	8.63 KB	-rw-r--r--
functions-string.html	57.67 KB	-rw-r--r--
functions-subquery.html	16 KB	-rw-r--r--
functions-textsearch.html	20.01 KB	-rw-r--r--
functions-trigger.html	4.44 KB	-rw-r--r--
functions-window.html	11.8 KB	-rw-r--r--
functions-xml.html	31.42 KB	-rw-r--r--
functions.html	9.71 KB	-rw-r--r--
fuzzystrmatch.html	7.87 KB	-rw-r--r--
geqo-biblio.html	3.38 KB	-rw-r--r--
geqo-intro.html	4.31 KB	-rw-r--r--
geqo-intro2.html	5.5 KB	-rw-r--r--
geqo-pg-intro.html	8.58 KB	-rw-r--r--
geqo.html	3.53 KB	-rw-r--r--
gin-examples.html	3.24 KB	-rw-r--r--
gin-extensibility.html	14.06 KB	-rw-r--r--
gin-implementation.html	6.41 KB	-rw-r--r--
gin-intro.html	4.55 KB	-rw-r--r--
gin-limit.html	2.75 KB	-rw-r--r--
gin-tips.html	5.58 KB	-rw-r--r--
gin.html	2.86 KB	-rw-r--r--
gist-examples.html	3.66 KB	-rw-r--r--
gist-extensibility.html	23.78 KB	-rw-r--r--
gist-implementation.html	4 KB	-rw-r--r--
gist-intro.html	3.53 KB	-rw-r--r--
gist.html	2.62 KB	-rw-r--r--
git.html	4.46 KB	-rw-r--r--
high-availability.html	7.52 KB	-rw-r--r--
history.html	11.64 KB	-rw-r--r--
hot-standby.html	35.2 KB	-rw-r--r--
hstore.html	22.1 KB	-rw-r--r--
index-catalog.html	7.81 KB	-rw-r--r--
index-cost-estimation.html	9.76 KB	-rw-r--r--
index-functions.html	18.67 KB	-rw-r--r--
index-locking.html	7.86 KB	-rw-r--r--
index-scanning.html	10.46 KB	-rw-r--r--
index-unique-checks.html	8.98 KB	-rw-r--r--
index.html	7.88 KB	-rw-r--r--
indexam.html	5.12 KB	-rw-r--r--
indexes-bitmap-scans.html	6.43 KB	-rw-r--r--
indexes-collations.html	3.55 KB	-rw-r--r--
indexes-examine.html	6.99 KB	-rw-r--r--
indexes-expressional.html	4.7 KB	-rw-r--r--
indexes-intro.html	6.17 KB	-rw-r--r--
indexes-multicolumn.html	6.15 KB	-rw-r--r--
indexes-opclass.html	7.16 KB	-rw-r--r--
indexes-ordering.html	6.33 KB	-rw-r--r--
indexes-partial.html	11.54 KB	-rw-r--r--
indexes-types.html	9.99 KB	-rw-r--r--
indexes-unique.html	3.91 KB	-rw-r--r--
indexes.html	3.53 KB	-rw-r--r--
information-schema.html	10.92 KB	-rw-r--r--
infoschema-administrable-role-...	3.66 KB	-rw-r--r--
infoschema-applicable-roles.ht...	3.88 KB	-rw-r--r--
infoschema-attributes.html	12.51 KB	-rw-r--r--
infoschema-character-sets.html	6.88 KB	-rw-r--r--
infoschema-check-constraint-ro...	4.25 KB	-rw-r--r--
infoschema-check-constraints.h...	3.79 KB	-rw-r--r--
infoschema-collation-character...	4.32 KB	-rw-r--r--
infoschema-collations.html	3.79 KB	-rw-r--r--
infoschema-column-domain-usage...	4.22 KB	-rw-r--r--
infoschema-column-options.html	4.01 KB	-rw-r--r--
infoschema-column-privileges.h...	4.91 KB	-rw-r--r--
infoschema-column-udt-usage.ht...	4.48 KB	-rw-r--r--
infoschema-columns.html	17.21 KB	-rw-r--r--
infoschema-constraint-column-u...	4.76 KB	-rw-r--r--
infoschema-constraint-table-us...	4.66 KB	-rw-r--r--
infoschema-data-type-privilege...	4.97 KB	-rw-r--r--
infoschema-datatypes.html	4.13 KB	-rw-r--r--
infoschema-domain-constraints....	4.55 KB	-rw-r--r--
infoschema-domain-udt-usage.ht...	4.07 KB	-rw-r--r--
infoschema-domains.html	11.1 KB	-rw-r--r--
infoschema-element-types.html	11.11 KB	-rw-r--r--
infoschema-enabled-roles.html	3.69 KB	-rw-r--r--
infoschema-foreign-data-wrappe...	3.82 KB	-rw-r--r--
infoschema-foreign-data-wrappe...	4.13 KB	-rw-r--r--
infoschema-foreign-server-opti...	3.76 KB	-rw-r--r--
infoschema-foreign-servers.htm...	4.46 KB	-rw-r--r--
infoschema-foreign-table-optio...	3.88 KB	-rw-r--r--
infoschema-foreign-tables.html	3.98 KB	-rw-r--r--
infoschema-information-schema-...	3.28 KB	-rw-r--r--
infoschema-key-column-usage.ht...	5.06 KB	-rw-r--r--
infoschema-parameters.html	10.55 KB	-rw-r--r--
infoschema-referential-constra...	5.53 KB	-rw-r--r--
infoschema-role-column-grants....	4.9 KB	-rw-r--r--
infoschema-role-routine-grants...	5.23 KB	-rw-r--r--
infoschema-role-table-grants.h...	5.3 KB	-rw-r--r--
infoschema-role-udt-grants.htm...	4.67 KB	-rw-r--r--
infoschema-role-usage-grants.h...	4.89 KB	-rw-r--r--
infoschema-routine-privileges....	4.91 KB	-rw-r--r--
infoschema-routines.html	22.51 KB	-rw-r--r--
infoschema-schema.html	3.11 KB	-rw-r--r--
infoschema-schemata.html	4.15 KB	-rw-r--r--
infoschema-sequences.html	5.97 KB	-rw-r--r--
infoschema-sql-features.html	4.6 KB	-rw-r--r--
infoschema-sql-implementation-...	4.4 KB	-rw-r--r--
infoschema-sql-languages.html	4.97 KB	-rw-r--r--
infoschema-sql-packages.html	4.08 KB	-rw-r--r--
infoschema-sql-parts.html	3.98 KB	-rw-r--r--
infoschema-sql-sizing-profiles...	4.08 KB	-rw-r--r--
infoschema-sql-sizing.html	4 KB	-rw-r--r--
infoschema-table-constraints.h...	4.8 KB	-rw-r--r--
infoschema-table-privileges.ht...	4.98 KB	-rw-r--r--
infoschema-tables.html	5.82 KB	-rw-r--r--
infoschema-triggered-update-co...	4.45 KB	-rw-r--r--
infoschema-triggers.html	9.23 KB	-rw-r--r--
infoschema-udt-privileges.html	4.4 KB	-rw-r--r--
infoschema-usage-privileges.ht...	5.38 KB	-rw-r--r--
infoschema-user-defined-types....	9.52 KB	-rw-r--r--
infoschema-user-mapping-option...	4.34 KB	-rw-r--r--
infoschema-user-mappings.html	3.74 KB	-rw-r--r--
infoschema-view-column-usage.h...	4.62 KB	-rw-r--r--
infoschema-view-routine-usage....	4.27 KB	-rw-r--r--
infoschema-view-table-usage.ht...	4.29 KB	-rw-r--r--
infoschema-views.html	5.4 KB	-rw-r--r--
install-getsource.html	3.49 KB	-rw-r--r--
install-post.html	7.89 KB	-rw-r--r--
install-procedure.html	45.44 KB	-rw-r--r--
install-requirements.html	14.14 KB	-rw-r--r--
install-short.html	2.8 KB	-rw-r--r--
install-windows-full.html	18.82 KB	-rw-r--r--
install-windows-libpq.html	6.14 KB	-rw-r--r--
install-windows.html	6.46 KB	-rw-r--r--
installation-platform-notes.ht...	38.46 KB	-rw-r--r--
installation.html	4.06 KB	-rw-r--r--
intagg.html	6.11 KB	-rw-r--r--
intarray.html	13.43 KB	-rw-r--r--
internals.html	15.27 KB	-rw-r--r--
intro-whatis.html	3.92 KB	-rw-r--r--
isn.html	13.04 KB	-rw-r--r--
kernel-resources.html	36.94 KB	-rw-r--r--
largeobjects.html	4.57 KB	-rw-r--r--
libpq-async.html	20.53 KB	-rw-r--r--
libpq-build.html	6.22 KB	-rw-r--r--
libpq-cancel.html	6.62 KB	-rw-r--r--
libpq-connect.html	50.05 KB	-rw-r--r--
libpq-control.html	6.13 KB	-rw-r--r--
libpq-copy.html	21.92 KB	-rw-r--r--
libpq-envars.html	9.59 KB	-rw-r--r--
libpq-events.html	22.55 KB	-rw-r--r--
libpq-example.html	15.65 KB	-rw-r--r--
libpq-exec.html	63.36 KB	-rw-r--r--
libpq-fastpath.html	5.98 KB	-rw-r--r--
libpq-ldap.html	5.38 KB	-rw-r--r--
libpq-misc.html	13.49 KB	-rw-r--r--
libpq-notice-processing.html	6.14 KB	-rw-r--r--
libpq-notify.html	6.56 KB	-rw-r--r--
libpq-pgpass.html	4.75 KB	-rw-r--r--
libpq-pgservice.html	3.81 KB	-rw-r--r--
libpq-single-row-mode.html	6.2 KB	-rw-r--r--
libpq-ssl.html	19.5 KB	-rw-r--r--
libpq-status.html	17.28 KB	-rw-r--r--
libpq-threading.html	5.41 KB	-rw-r--r--
libpq.html	7.73 KB	-rw-r--r--
lo-examplesect.html	8.49 KB	-rw-r--r--
lo-funcs.html	4.53 KB	-rw-r--r--
lo-implementation.html	3.27 KB	-rw-r--r--
lo-interfaces.html	14.8 KB	-rw-r--r--
lo-intro.html	3.13 KB	-rw-r--r--
lo.html	6.47 KB	-rw-r--r--
locale.html	13.37 KB	-rw-r--r--
locking-indexes.html	4.25 KB	-rw-r--r--
log-shipping-alternative.html	10.8 KB	-rw-r--r--
logfile-maintenance.html	6.98 KB	-rw-r--r--
ltree.html	26.66 KB	-rw-r--r--
maintenance.html	5.41 KB	-rw-r--r--
manage-ag-config.html	3.66 KB	-rw-r--r--
manage-ag-createdb.html	6.16 KB	-rw-r--r--
manage-ag-dropdb.html	3.52 KB	-rw-r--r--
manage-ag-overview.html	5.02 KB	-rw-r--r--
manage-ag-tablespaces.html	9.03 KB	-rw-r--r--
manage-ag-templatedbs.html	7.97 KB	-rw-r--r--
managing-databases.html	3.2 KB	-rw-r--r--
monitoring-locks.html	3.59 KB	-rw-r--r--
monitoring-ps.html	6.62 KB	-rw-r--r--
monitoring-stats.html	56.7 KB	-rw-r--r--
monitoring.html	4.35 KB	-rw-r--r--
multibyte.html	31.22 KB	-rw-r--r--
mvcc-caveats.html	3.98 KB	-rw-r--r--
mvcc-intro.html	4.45 KB	-rw-r--r--
mvcc.html	4.2 KB	-rw-r--r--
nls-programmer.html	9.84 KB	-rw-r--r--
nls-translator.html	14.18 KB	-rw-r--r--
nls.html	3.06 KB	-rw-r--r--
non-durability.html	4.38 KB	-rw-r--r--
notation.html	4.31 KB	-rw-r--r--
oid2name.html	11.68 KB	-rw-r--r--
overview.html	4 KB	-rw-r--r--
pageinspect.html	7.93 KB	-rw-r--r--
parser-stage.html	7.93 KB	-rw-r--r--
passwordcheck.html	4.68 KB	-rw-r--r--
performance-tips.html	4.4 KB	-rw-r--r--
perm-functions.html	3.26 KB	-rw-r--r--
pgarchivecleanup.html	8.79 KB	-rw-r--r--
pgbench.html	30.11 KB	-rw-r--r--
pgbuffercache.html	7.53 KB	-rw-r--r--
pgcrypto.html	37.89 KB	-rw-r--r--
pgfreespacemap.html	5.11 KB	-rw-r--r--
pgrowlocks.html	5.94 KB	-rw-r--r--
pgstandby.html	14.85 KB	-rw-r--r--
pgstatstatements.html	15.69 KB	-rw-r--r--
pgstattuple.html	9.23 KB	-rw-r--r--
pgtestfsync.html	5.13 KB	-rw-r--r--
pgtesttiming.html	12.18 KB	-rw-r--r--
pgtrgm.html	12.04 KB	-rw-r--r--
pgupgrade.html	24.16 KB	-rw-r--r--
planner-optimizer.html	9.18 KB	-rw-r--r--
planner-stats-details.html	3.2 KB	-rw-r--r--
planner-stats-security.html	5.43 KB	-rw-r--r--
planner-stats.html	8.85 KB	-rw-r--r--
plhandler.html	13.43 KB	-rw-r--r--
plperl-builtins.html	17.85 KB	-rw-r--r--
plperl-data.html	2.81 KB	-rw-r--r--
plperl-funcs.html	13.06 KB	-rw-r--r--
plperl-global.html	4.95 KB	-rw-r--r--
plperl-triggers.html	6.29 KB	-rw-r--r--
plperl-trusted.html	6.55 KB	-rw-r--r--
plperl-under-the-hood.html	8.78 KB	-rw-r--r--
plperl.html	4.81 KB	-rw-r--r--
plpgsql-control-structures.htm...	45.1 KB	-rw-r--r--
plpgsql-cursors.html	24.99 KB	-rw-r--r--
plpgsql-declarations.html	21.24 KB	-rw-r--r--
plpgsql-development-tips.html	9.29 KB	-rw-r--r--
plpgsql-errors-and-messages.ht...	9.86 KB	-rw-r--r--
plpgsql-expressions.html	4.55 KB	-rw-r--r--
plpgsql-implementation.html	17.62 KB	-rw-r--r--
plpgsql-overview.html	8.82 KB	-rw-r--r--
plpgsql-porting.html	26.46 KB	-rw-r--r--
plpgsql-statements.html	31.47 KB	-rw-r--r--
plpgsql-structure.html	8.13 KB	-rw-r--r--
plpgsql-trigger.html	21.8 KB	-rw-r--r--
plpgsql.html	6.8 KB	-rw-r--r--
plpython-data.html	14.3 KB	-rw-r--r--
plpython-database.html	15.05 KB	-rw-r--r--
plpython-do.html	2.71 KB	-rw-r--r--
plpython-envar.html	3.79 KB	-rw-r--r--
plpython-funcs.html	5.35 KB	-rw-r--r--
plpython-python23.html	7.04 KB	-rw-r--r--
plpython-sharing.html	2.96 KB	-rw-r--r--
plpython-subtransaction.html	7.7 KB	-rw-r--r--
plpython-trigger.html	4.95 KB	-rw-r--r--
plpython-util.html	4.98 KB	-rw-r--r--
plpython.html	5.92 KB	-rw-r--r--
pltcl-data.html	2.84 KB	-rw-r--r--
pltcl-dbaccess.html	13.58 KB	-rw-r--r--
pltcl-functions.html	6.03 KB	-rw-r--r--
pltcl-global.html	4.95 KB	-rw-r--r--
pltcl-overview.html	5.16 KB	-rw-r--r--
pltcl-procnames.html	3.15 KB	-rw-r--r--
pltcl-trigger.html	9.23 KB	-rw-r--r--
pltcl-unknown.html	4.96 KB	-rw-r--r--
pltcl.html	3.32 KB	-rw-r--r--
populate.html	16.71 KB	-rw-r--r--
postgres-user.html	3.24 KB	-rw-r--r--
preface.html	4.95 KB	-rw-r--r--
preventing-server-spoofing.htm...	4.5 KB	-rw-r--r--
protocol-changes.html	6.49 KB	-rw-r--r--
protocol-error-fields.html	5.99 KB	-rw-r--r--
protocol-flow.html	45.12 KB	-rw-r--r--
protocol-message-formats.html	39.89 KB	-rw-r--r--
protocol-message-types.html	4.82 KB	-rw-r--r--
protocol-overview.html	9.44 KB	-rw-r--r--
protocol-replication.html	14.32 KB	-rw-r--r--
protocol.html	5.52 KB	-rw-r--r--
queries-limit.html	5.21 KB	-rw-r--r--
queries-order.html	7.2 KB	-rw-r--r--
queries-overview.html	4.95 KB	-rw-r--r--
queries-select-lists.html	9.09 KB	-rw-r--r--
queries-table-expressions.html	38.94 KB	-rw-r--r--
queries-union.html	4.99 KB	-rw-r--r--
queries-values.html	4.81 KB	-rw-r--r--
queries-with.html	20.39 KB	-rw-r--r--
queries.html	4.31 KB	-rw-r--r--
query-path.html	5.34 KB	-rw-r--r--
querytree.html	10.88 KB	-rw-r--r--
rangetypes.html	22.2 KB	-rw-r--r--
recovery-config.html	3.47 KB	-rw-r--r--
recovery-target-settings.html	7.58 KB	-rw-r--r--
reference-client.html	5.96 KB	-rw-r--r--
reference-server.html	3.87 KB	-rw-r--r--
reference.html	22.62 KB	-rw-r--r--
regress-coverage.html	3.25 KB	-rw-r--r--
regress-evaluation.html	12.19 KB	-rw-r--r--
regress-run.html	13.39 KB	-rw-r--r--
regress-variant.html	7.01 KB	-rw-r--r--
regress.html	4.18 KB	-rw-r--r--
release-0-01.html	2.5 KB	-rw-r--r--
release-0-02.html	4.19 KB	-rw-r--r--
release-0-03.html	7.62 KB	-rw-r--r--
release-1-0.html	4.13 KB	-rw-r--r--
release-1-01.html	9.13 KB	-rw-r--r--
release-1-02.html	6.34 KB	-rw-r--r--
release-1-09.html	2.47 KB	-rw-r--r--
release-6-0.html	7.73 KB	-rw-r--r--
release-6-1-1.html	3.63 KB	-rw-r--r--
release-6-1.html	8.81 KB	-rw-r--r--
release-6-2-1.html	4.3 KB	-rw-r--r--
release-6-2.html	8.67 KB	-rw-r--r--
release-6-3-1.html	4.34 KB	-rw-r--r--
release-6-3-2.html	4.06 KB	-rw-r--r--
release-6-3.html	15.93 KB	-rw-r--r--
release-6-4-1.html	3.97 KB	-rw-r--r--
release-6-4-2.html	2.84 KB	-rw-r--r--
release-6-4.html	14.39 KB	-rw-r--r--
release-6-5-1.html	3.75 KB	-rw-r--r--
release-6-5-2.html	4.01 KB	-rw-r--r--
release-6-5-3.html	2.98 KB	-rw-r--r--
release-6-5.html	16.98 KB	-rw-r--r--
release-7-0-1.html	3.83 KB	-rw-r--r--
release-7-0-2.html	2.82 KB	-rw-r--r--
release-7-0-3.html	4.55 KB	-rw-r--r--
release-7-0.html	22.56 KB	-rw-r--r--
release-7-1-1.html	3.19 KB	-rw-r--r--
release-7-1-2.html	2.91 KB	-rw-r--r--
release-7-1-3.html	3.07 KB	-rw-r--r--
release-7-1.html	12.71 KB	-rw-r--r--
release-7-2-1.html	3.92 KB	-rw-r--r--
release-7-2-2.html	3.7 KB	-rw-r--r--
release-7-2-3.html	3.29 KB	-rw-r--r--
release-7-2-4.html	3.5 KB	-rw-r--r--
release-7-2-5.html	3.66 KB	-rw-r--r--
release-7-2-6.html	3.54 KB	-rw-r--r--
release-7-2-7.html	3.64 KB	-rw-r--r--
release-7-2-8.html	3.86 KB	-rw-r--r--
release-7-2.html	26.46 KB	-rw-r--r--
release-7-3-1.html	4.07 KB	-rw-r--r--
release-7-3-10.html	7.32 KB	-rw-r--r--
release-7-3-11.html	4.01 KB	-rw-r--r--
release-7-3-12.html	3.44 KB	-rw-r--r--
release-7-3-13.html	4.51 KB	-rw-r--r--
release-7-3-14.html	3.84 KB	-rw-r--r--
release-7-3-15.html	6.17 KB	-rw-r--r--
release-7-3-16.html	3.34 KB	-rw-r--r--
release-7-3-17.html	3.47 KB	-rw-r--r--
release-7-3-18.html	3.56 KB	-rw-r--r--
release-7-3-19.html	3.6 KB	-rw-r--r--
release-7-3-2.html	5.08 KB	-rw-r--r--
release-7-3-20.html	3.44 KB	-rw-r--r--
release-7-3-21.html	6.07 KB	-rw-r--r--
release-7-3-3.html	10.05 KB	-rw-r--r--
release-7-3-4.html	3.42 KB	-rw-r--r--
release-7-3-5.html	4.39 KB	-rw-r--r--
release-7-3-6.html	4.32 KB	-rw-r--r--
release-7-3-7.html	3.27 KB	-rw-r--r--
release-7-3-8.html	3.49 KB	-rw-r--r--
release-7-3-9.html	3.98 KB	-rw-r--r--
release-7-3.html	32.28 KB	-rw-r--r--
release-7-4-1.html	6.95 KB	-rw-r--r--
release-7-4-10.html	3.72 KB	-rw-r--r--
release-7-4-11.html	4.74 KB	-rw-r--r--
release-7-4-12.html	4.12 KB	-rw-r--r--
release-7-4-13.html	6.8 KB	-rw-r--r--
release-7-4-14.html	3.59 KB	-rw-r--r--
release-7-4-15.html	4.17 KB	-rw-r--r--
release-7-4-16.html	3.88 KB	-rw-r--r--
release-7-4-17.html	3.92 KB	-rw-r--r--
release-7-4-18.html	3.83 KB	-rw-r--r--
release-7-4-19.html	7.07 KB	-rw-r--r--
release-7-4-2.html	8.07 KB	-rw-r--r--
release-7-4-20.html	6.45 KB	-rw-r--r--
release-7-4-21.html	3.83 KB	-rw-r--r--
release-7-4-22.html	3.98 KB	-rw-r--r--
release-7-4-23.html	4.32 KB	-rw-r--r--
release-7-4-24.html	4.19 KB	-rw-r--r--
release-7-4-25.html	4.4 KB	-rw-r--r--
release-7-4-26.html	5.33 KB	-rw-r--r--
release-7-4-27.html	5.04 KB	-rw-r--r--
release-7-4-28.html	5.5 KB	-rw-r--r--
release-7-4-29.html	6.8 KB	-rw-r--r--
release-7-4-3.html	4.51 KB	-rw-r--r--
release-7-4-30.html	6.07 KB	-rw-r--r--
release-7-4-4.html	3.99 KB	-rw-r--r--
release-7-4-5.html	3.12 KB	-rw-r--r--
release-7-4-6.html	4.62 KB	-rw-r--r--
release-7-4-7.html	4.17 KB	-rw-r--r--
release-7-4-8.html	9.92 KB	-rw-r--r--
release-7-4-9.html	5 KB	-rw-r--r--
release-7-4.html	56.03 KB	-rw-r--r--
release-8-0-1.html	4.63 KB	-rw-r--r--
release-8-0-10.html	4.64 KB	-rw-r--r--
release-8-0-11.html	3.88 KB	-rw-r--r--
release-8-0-12.html	3.06 KB	-rw-r--r--
release-8-0-13.html	4.02 KB	-rw-r--r--
release-8-0-14.html	4.41 KB	-rw-r--r--
release-8-0-15.html	8.89 KB	-rw-r--r--
release-8-0-16.html	8.74 KB	-rw-r--r--
release-8-0-17.html	3.83 KB	-rw-r--r--
release-8-0-18.html	5.45 KB	-rw-r--r--
release-8-0-19.html	4.86 KB	-rw-r--r--
release-8-0-2.html	9.34 KB	-rw-r--r--
release-8-0-20.html	4.21 KB	-rw-r--r--
release-8-0-21.html	4.4 KB	-rw-r--r--
release-8-0-22.html	6.29 KB	-rw-r--r--
release-8-0-23.html	5.88 KB	-rw-r--r--
release-8-0-24.html	6.84 KB	-rw-r--r--
release-8-0-25.html	7.25 KB	-rw-r--r--
release-8-0-26.html	7.84 KB	-rw-r--r--
release-8-0-3.html	7.25 KB	-rw-r--r--
release-8-0-4.html	6.52 KB	-rw-r--r--
release-8-0-5.html	4.7 KB	-rw-r--r--
release-8-0-6.html	5.56 KB	-rw-r--r--
release-8-0-7.html	5.77 KB	-rw-r--r--
release-8-0-8.html	7.06 KB	-rw-r--r--
release-8-0-9.html	4.21 KB	-rw-r--r--
release-8-0.html	65.25 KB	-rw-r--r--
release-8-1-1.html	5.33 KB	-rw-r--r--
release-8-1-10.html	4.67 KB	-rw-r--r--
release-8-1-11.html	9.71 KB	-rw-r--r--
release-8-1-12.html	9.12 KB	-rw-r--r--
release-8-1-13.html	4.19 KB	-rw-r--r--
release-8-1-14.html	6.74 KB	-rw-r--r--
release-8-1-15.html	6.13 KB	-rw-r--r--
release-8-1-16.html	5.15 KB	-rw-r--r--
release-8-1-17.html	5.89 KB	-rw-r--r--
release-8-1-18.html	6.29 KB	-rw-r--r--
release-8-1-19.html	6.46 KB	-rw-r--r--
release-8-1-2.html	6.19 KB	-rw-r--r--
release-8-1-20.html	7.13 KB	-rw-r--r--
release-8-1-21.html	7.04 KB	-rw-r--r--
release-8-1-22.html	8.13 KB	-rw-r--r--
release-8-1-23.html	7.75 KB	-rw-r--r--
release-8-1-3.html	6.86 KB	-rw-r--r--
release-8-1-4.html	8.67 KB	-rw-r--r--
release-8-1-5.html	5.35 KB	-rw-r--r--
release-8-1-6.html	5.21 KB	-rw-r--r--
release-8-1-7.html	4.45 KB	-rw-r--r--
release-8-1-8.html	3.04 KB	-rw-r--r--
release-8-1-9.html	4.29 KB	-rw-r--r--
release-8-1.html	60.66 KB	-rw-r--r--
release-8-2-1.html	4.95 KB	-rw-r--r--
release-8-2-10.html	7.99 KB	-rw-r--r--
release-8-2-11.html	6.98 KB	-rw-r--r--
release-8-2-12.html	6.59 KB	-rw-r--r--
release-8-2-13.html	7.18 KB	-rw-r--r--
release-8-2-14.html	7.69 KB	-rw-r--r--
release-8-2-15.html	7.96 KB	-rw-r--r--
release-8-2-16.html	9.08 KB	-rw-r--r--
release-8-2-17.html	8.02 KB	-rw-r--r--
release-8-2-18.html	10.04 KB	-rw-r--r--
release-8-2-19.html	8.39 KB	-rw-r--r--
release-8-2-2.html	5.67 KB	-rw-r--r--
release-8-2-20.html	6.1 KB	-rw-r--r--
release-8-2-21.html	5.46 KB	-rw-r--r--
release-8-2-22.html	9.39 KB	-rw-r--r--
release-8-2-23.html	9.33 KB	-rw-r--r--
release-8-2-3.html	3.02 KB	-rw-r--r--
release-8-2-4.html	5.3 KB	-rw-r--r--
release-8-2-5.html	5.85 KB	-rw-r--r--
release-8-2-6.html	10.3 KB	-rw-r--r--
release-8-2-7.html	9.09 KB	-rw-r--r--
release-8-2-8.html	7.34 KB	-rw-r--r--
release-8-2-9.html	4.18 KB	-rw-r--r--
release-8-2.html	67.77 KB	-rw-r--r--
release-8-3-1.html	10.34 KB	-rw-r--r--
release-8-3-10.html	10.47 KB	-rw-r--r--
release-8-3-11.html	8.75 KB	-rw-r--r--
release-8-3-12.html	11.83 KB	-rw-r--r--
release-8-3-13.html	9.28 KB	-rw-r--r--
release-8-3-14.html	6.1 KB	-rw-r--r--
release-8-3-15.html	6.23 KB	-rw-r--r--
release-8-3-16.html	10.76 KB	-rw-r--r--
release-8-3-17.html	10.34 KB	-rw-r--r--
release-8-3-18.html	11 KB	-rw-r--r--
release-8-3-19.html	8.27 KB	-rw-r--r--
release-8-3-2.html	11.92 KB	-rw-r--r--
release-8-3-20.html	9.03 KB	-rw-r--r--
release-8-3-21.html	4.92 KB	-rw-r--r--
release-8-3-22.html	10.34 KB	-rw-r--r--
release-8-3-23.html	6.14 KB	-rw-r--r--
release-8-3-3.html	4.17 KB	-rw-r--r--
release-8-3-4.html	11.01 KB	-rw-r--r--
release-8-3-5.html	8.49 KB	-rw-r--r--
release-8-3-6.html	8.98 KB	-rw-r--r--
release-8-3-7.html	9.5 KB	-rw-r--r--
release-8-3-8.html	9.04 KB	-rw-r--r--
release-8-3-9.html	9.97 KB	-rw-r--r--
release-8-3.html	68.14 KB	-rw-r--r--
release-8-4-1.html	9.34 KB	-rw-r--r--
release-8-4-10.html	11.65 KB	-rw-r--r--
release-8-4-11.html	13.46 KB	-rw-r--r--
release-8-4-12.html	9.75 KB	-rw-r--r--
release-8-4-13.html	9.49 KB	-rw-r--r--
release-8-4-14.html	5 KB	-rw-r--r--
release-8-4-15.html	10.38 KB	-rw-r--r--
release-8-4-16.html	7.16 KB	-rw-r--r--
release-8-4-17.html	9.35 KB	-rw-r--r--
release-8-4-18.html	6.88 KB	-rw-r--r--
release-8-4-19.html	7.6 KB	-rw-r--r--
release-8-4-2.html	15.33 KB	-rw-r--r--
release-8-4-20.html	15.88 KB	-rw-r--r--
release-8-4-21.html	5.32 KB	-rw-r--r--
release-8-4-22.html	11.04 KB	-rw-r--r--
release-8-4-3.html	13.6 KB	-rw-r--r--
release-8-4-4.html	10.48 KB	-rw-r--r--
release-8-4-5.html	15.56 KB	-rw-r--r--
release-8-4-6.html	10.19 KB	-rw-r--r--
release-8-4-7.html	6.07 KB	-rw-r--r--
release-8-4-8.html	8.64 KB	-rw-r--r--
release-8-4-9.html	14.19 KB	-rw-r--r--
release-8-4.html	85.91 KB	-rw-r--r--
release-9-0-1.html	5.81 KB	-rw-r--r--
release-9-0-10.html	5.56 KB	-rw-r--r--
release-9-0-11.html	12.37 KB	-rw-r--r--
release-9-0-12.html	8.62 KB	-rw-r--r--
release-9-0-13.html	11.4 KB	-rw-r--r--
release-9-0-14.html	8.55 KB	-rw-r--r--
release-9-0-15.html	8.93 KB	-rw-r--r--
release-9-0-16.html	17 KB	-rw-r--r--
release-9-0-17.html	6.19 KB	-rw-r--r--
release-9-0-18.html	11.6 KB	-rw-r--r--
release-9-0-19.html	25.99 KB	-rw-r--r--
release-9-0-2.html	13.32 KB	-rw-r--r--
release-9-0-20.html	15.46 KB	-rw-r--r--
release-9-0-21.html	5.04 KB	-rw-r--r--
release-9-0-22.html	4.22 KB	-rw-r--r--
release-9-0-23.html	15.78 KB	-rw-r--r--
release-9-0-3.html	7.09 KB	-rw-r--r--
release-9-0-4.html	11.08 KB	-rw-r--r--
release-9-0-5.html	17.5 KB	-rw-r--r--
release-9-0-6.html	13.11 KB	-rw-r--r--
release-9-0-7.html	17.67 KB	-rw-r--r--
release-9-0-8.html	10.74 KB	-rw-r--r--
release-9-0-9.html	11.47 KB	-rw-r--r--
release-9-0.html	93.87 KB	-rw-r--r--
release-9-1-1.html	3.58 KB	-rw-r--r--
release-9-1-10.html	10.11 KB	-rw-r--r--
release-9-1-11.html	9.36 KB	-rw-r--r--
release-9-1-12.html	18.12 KB	-rw-r--r--
release-9-1-13.html	6.53 KB	-rw-r--r--
release-9-1-14.html	12.73 KB	-rw-r--r--
release-9-1-15.html	28.29 KB	-rw-r--r--
release-9-1-16.html	18.67 KB	-rw-r--r--
release-9-1-17.html	4.83 KB	-rw-r--r--
release-9-1-18.html	4.01 KB	-rw-r--r--
release-9-1-19.html	17.2 KB	-rw-r--r--
release-9-1-2.html	21.07 KB	-rw-r--r--
release-9-1-20.html	17.13 KB	-rw-r--r--
release-9-1-21.html	7.42 KB	-rw-r--r--
release-9-1-22.html	7.09 KB	-rw-r--r--
release-9-1-23.html	12.36 KB	-rw-r--r--
release-9-1-24.html	8.53 KB	-rw-r--r--
release-9-1-3.html	20.66 KB	-rw-r--r--
release-9-1-4.html	15.64 KB	-rw-r--r--
release-9-1-5.html	13.71 KB	-rw-r--r--
release-9-1-6.html	9.3 KB	-rw-r--r--
release-9-1-7.html	14.59 KB	-rw-r--r--
release-9-1-8.html	9.92 KB	-rw-r--r--
release-9-1-9.html	12.38 KB	-rw-r--r--
release-9-1.html	77.11 KB	-rw-r--r--
release-9-2-1.html	6.94 KB	-rw-r--r--
release-9-2-10.html	31.61 KB	-rw-r--r--
release-9-2-11.html	19.82 KB	-rw-r--r--
release-9-2-12.html	5.01 KB	-rw-r--r--
release-9-2-13.html	4.01 KB	-rw-r--r--
release-9-2-14.html	17.96 KB	-rw-r--r--
release-9-2-15.html	18.17 KB	-rw-r--r--
release-9-2-16.html	7.42 KB	-rw-r--r--
release-9-2-17.html	8 KB	-rw-r--r--
release-9-2-18.html	12.42 KB	-rw-r--r--
release-9-2-19.html	10.27 KB	-rw-r--r--
release-9-2-2.html	22.46 KB	-rw-r--r--
release-9-2-20.html	13.02 KB	-rw-r--r--
release-9-2-21.html	13.87 KB	-rw-r--r--
release-9-2-22.html	15.49 KB	-rw-r--r--
release-9-2-23.html	7.94 KB	-rw-r--r--
release-9-2-24.html	7.69 KB	-rw-r--r--
release-9-2-3.html	13.06 KB	-rw-r--r--
release-9-2-4.html	14.45 KB	-rw-r--r--
release-9-2-5.html	11.72 KB	-rw-r--r--
release-9-2-6.html	11.41 KB	-rw-r--r--
release-9-2-7.html	19.55 KB	-rw-r--r--
release-9-2-8.html	7.2 KB	-rw-r--r--
release-9-2-9.html	15.25 KB	-rw-r--r--
release-9-2.html	77.66 KB	-rw-r--r--
release.html	22.35 KB	-rw-r--r--
resources.html	4.13 KB	-rw-r--r--
role-attributes.html	7.67 KB	-rw-r--r--
role-membership.html	8.19 KB	-rw-r--r--
role-removal.html	5.18 KB	-rw-r--r--
routine-reindex.html	3.54 KB	-rw-r--r--
routine-vacuuming.html	37.13 KB	-rw-r--r--
row-estimation-examples.html	20.28 KB	-rw-r--r--
rowtypes.html	22.86 KB	-rw-r--r--
rule-system.html	4.02 KB	-rw-r--r--
rules-privileges.html	11.39 KB	-rw-r--r--
rules-status.html	4.41 KB	-rw-r--r--
rules-triggers.html	9.25 KB	-rw-r--r--
rules-update.html	31.85 KB	-rw-r--r--
rules-views.html	26.26 KB	-rw-r--r--
rules.html	4.83 KB	-rw-r--r--
runtime-config-autovacuum.html	10.72 KB	-rw-r--r--
runtime-config-client.html	32.05 KB	-rw-r--r--
runtime-config-compatible.html	14.48 KB	-rw-r--r--
runtime-config-connection.html	22.93 KB	-rw-r--r--
runtime-config-custom.html	3.46 KB	-rw-r--r--
runtime-config-developer.html	13.74 KB	-rw-r--r--
runtime-config-error-handling....	3.49 KB	-rw-r--r--
runtime-config-file-locations....	6.81 KB	-rw-r--r--
runtime-config-locks.html	7.46 KB	-rw-r--r--
runtime-config-logging.html	44.38 KB	-rw-r--r--
runtime-config-preset.html	8.51 KB	-rw-r--r--
runtime-config-query.html	24.37 KB	-rw-r--r--
runtime-config-replication.htm...	17.87 KB	-rw-r--r--
runtime-config-resource.html	27.25 KB	-rw-r--r--
runtime-config-short.html	6.53 KB	-rw-r--r--
runtime-config-statistics.html	8.41 KB	-rw-r--r--
runtime-config-wal.html	26.46 KB	-rw-r--r--
runtime-config.html	8.06 KB	-rw-r--r--
runtime.html	5.12 KB	-rw-r--r--
seg.html	15.11 KB	-rw-r--r--
sepgsql.html	30.11 KB	-rw-r--r--
server-programming.html	9.39 KB	-rw-r--r--
server-shutdown.html	6.32 KB	-rw-r--r--
server-start.html	13.88 KB	-rw-r--r--
source-format.html	5.01 KB	-rw-r--r--
source.html	3.98 KB	-rw-r--r--
sourcerepo.html	3.33 KB	-rw-r--r--
spgist-examples.html	2.64 KB	-rw-r--r--
spgist-extensibility.html	30.55 KB	-rw-r--r--
spgist-implementation.html	7.91 KB	-rw-r--r--
spgist-intro.html	4.22 KB	-rw-r--r--
spgist.html	2.9 KB	-rw-r--r--
spi-examples.html	6.07 KB	-rw-r--r--
spi-interface-support.html	3.68 KB	-rw-r--r--
spi-interface.html	5.86 KB	-rw-r--r--
spi-memory.html	6.92 KB	-rw-r--r--
spi-realloc.html	3.54 KB	-rw-r--r--
spi-spi-connect.html	3.96 KB	-rw-r--r--
spi-spi-copytuple.html	3.37 KB	-rw-r--r--
spi-spi-cursor-close.html	3.26 KB	-rw-r--r--
spi-spi-cursor-fetch.html	4.01 KB	-rw-r--r--
spi-spi-cursor-find.html	3.38 KB	-rw-r--r--
spi-spi-cursor-move.html	3.8 KB	-rw-r--r--
spi-spi-cursor-open-with-args....	6.03 KB	-rw-r--r--
spi-spi-cursor-open-with-param...	4.92 KB	-rw-r--r--
spi-spi-cursor-open.html	5.6 KB	-rw-r--r--
spi-spi-exec.html	3.51 KB	-rw-r--r--
spi-spi-execp.html	4.75 KB	-rw-r--r--
spi-spi-execute-plan-with-para...	4.78 KB	-rw-r--r--
spi-spi-execute-plan.html	5.76 KB	-rw-r--r--
spi-spi-execute-with-args.html	6.08 KB	-rw-r--r--
spi-spi-execute.html	12.3 KB	-rw-r--r--
spi-spi-finish.html	3.57 KB	-rw-r--r--
spi-spi-fname.html	3.68 KB	-rw-r--r--
spi-spi-fnumber.html	3.84 KB	-rw-r--r--
spi-spi-freeplan.html	3.42 KB	-rw-r--r--
spi-spi-freetuple.html	3.2 KB	-rw-r--r--
spi-spi-freetupletable.html	3.54 KB	-rw-r--r--
spi-spi-getargcount.html	3.61 KB	-rw-r--r--
spi-spi-getargtypeid.html	4.04 KB	-rw-r--r--
spi-spi-getbinval.html	4.19 KB	-rw-r--r--
spi-spi-getnspname.html	3.39 KB	-rw-r--r--
spi-spi-getrelname.html	3.27 KB	-rw-r--r--
spi-spi-gettype.html	3.63 KB	-rw-r--r--
spi-spi-gettypeid.html	3.63 KB	-rw-r--r--
spi-spi-getvalue.html	4.07 KB	-rw-r--r--
spi-spi-is-cursor-plan.html	4.45 KB	-rw-r--r--
spi-spi-keepplan.html	3.79 KB	-rw-r--r--
spi-spi-modifytuple.html	5.5 KB	-rw-r--r--
spi-spi-palloc.html	3.08 KB	-rw-r--r--
spi-spi-pfree.html	3.2 KB	-rw-r--r--
spi-spi-pop.html	2.68 KB	-rw-r--r--
spi-spi-prepare-cursor.html	4.94 KB	-rw-r--r--
spi-spi-prepare-params.html	4.31 KB	-rw-r--r--
spi-spi-prepare.html	7.48 KB	-rw-r--r--
spi-spi-push.html	3.65 KB	-rw-r--r--
spi-spi-returntuple.html	4 KB	-rw-r--r--
spi-spi-saveplan.html	4.47 KB	-rw-r--r--
spi-spi-scroll-cursor-fetch.ht...	4.7 KB	-rw-r--r--
spi-spi-scroll-cursor-move.htm...	4.78 KB	-rw-r--r--
spi-visibility.html	4.05 KB	-rw-r--r--
spi.html	10.59 KB	-rw-r--r--
sql-abort.html	4.08 KB	-rw-r--r--
sql-alteraggregate.html	5.97 KB	-rw-r--r--
sql-altercollation.html	4.96 KB	-rw-r--r--
sql-alterconversion.html	5.05 KB	-rw-r--r--
sql-alterdatabase.html	8.57 KB	-rw-r--r--
sql-alterdefaultprivileges.htm...	9.19 KB	-rw-r--r--
sql-alterdomain.html	10.85 KB	-rw-r--r--
sql-alterextension.html	11.47 KB	-rw-r--r--
sql-alterforeigndatawrapper.ht...	7.21 KB	-rw-r--r--
sql-alterforeigntable.html	12.41 KB	-rw-r--r--
sql-alterfunction.html	12.54 KB	-rw-r--r--
sql-altergroup.html	5.12 KB	-rw-r--r--
sql-alterindex.html	7.48 KB	-rw-r--r--
sql-alterlanguage.html	3.93 KB	-rw-r--r--
sql-alterlargeobject.html	3.64 KB	-rw-r--r--
sql-alteropclass.html	4.99 KB	-rw-r--r--
sql-alteroperator.html	5.31 KB	-rw-r--r--
sql-alteropfamily.html	13.25 KB	-rw-r--r--
sql-alterrole.html	12.72 KB	-rw-r--r--
sql-alterschema.html	4.21 KB	-rw-r--r--
sql-altersequence.html	12.73 KB	-rw-r--r--
sql-alterserver.html	5.79 KB	-rw-r--r--
sql-altertable.html	42.52 KB	-rw-r--r--
sql-altertablespace.html	5.73 KB	-rw-r--r--
sql-altertrigger.html	4.54 KB	-rw-r--r--
sql-altertsconfig.html	7.94 KB	-rw-r--r--
sql-altertsdictionary.html	6.39 KB	-rw-r--r--
sql-altertsparser.html	4.16 KB	-rw-r--r--
sql-altertstemplate.html	4.12 KB	-rw-r--r--
sql-altertype.html	10.93 KB	-rw-r--r--
sql-alteruser.html	4.61 KB	-rw-r--r--
sql-alterusermapping.html	5.58 KB	-rw-r--r--
sql-alterview.html	6.81 KB	-rw-r--r--
sql-analyze.html	10.42 KB	-rw-r--r--
sql-begin.html	6.54 KB	-rw-r--r--
sql-checkpoint.html	3.67 KB	-rw-r--r--
sql-close.html	4.87 KB	-rw-r--r--
sql-cluster.html	9.18 KB	-rw-r--r--
sql-commands.html	18.37 KB	-rw-r--r--
sql-comment.html	13.48 KB	-rw-r--r--
sql-commit-prepared.html	4.41 KB	-rw-r--r--
sql-commit.html	3.9 KB	-rw-r--r--
sql-copy.html	36.57 KB	-rw-r--r--
sql-createaggregate.html	13.5 KB	-rw-r--r--
sql-createcast.html	19.17 KB	-rw-r--r--
sql-createcollation.html	6.58 KB	-rw-r--r--
sql-createconversion.html	6.38 KB	-rw-r--r--
sql-createdatabase.html	11.85 KB	-rw-r--r--
sql-createdomain.html	8.34 KB	-rw-r--r--
sql-createextension.html	8.87 KB	-rw-r--r--
sql-createforeigndatawrapper.h...	7.87 KB	-rw-r--r--
sql-createforeigntable.html	7.54 KB	-rw-r--r--
sql-createfunction.html	30.35 KB	-rw-r--r--
sql-creategroup.html	3.92 KB	-rw-r--r--
sql-createindex.html	25.33 KB	-rw-r--r--
sql-createlanguage.html	14.54 KB	-rw-r--r--
sql-createopclass.html	12.38 KB	-rw-r--r--
sql-createoperator.html	10.44 KB	-rw-r--r--
sql-createopfamily.html	5.49 KB	-rw-r--r--
sql-createrole.html	18.87 KB	-rw-r--r--
sql-createrule.html	12.36 KB	-rw-r--r--
sql-createschema.html	8.12 KB	-rw-r--r--
sql-createsequence.html	13.54 KB	-rw-r--r--
sql-createserver.html	6.1 KB	-rw-r--r--
sql-createtable.html	57.79 KB	-rw-r--r--
sql-createtableas.html	12.47 KB	-rw-r--r--
sql-createtablespace.html	5.96 KB	-rw-r--r--
sql-createtrigger.html	22.63 KB	-rw-r--r--
sql-createtsconfig.html	5.23 KB	-rw-r--r--
sql-createtsdictionary.html	5.4 KB	-rw-r--r--
sql-createtsparser.html	5.81 KB	-rw-r--r--
sql-createtstemplate.html	5.31 KB	-rw-r--r--
sql-createtype.html	38.54 KB	-rw-r--r--
sql-createuser.html	4.42 KB	-rw-r--r--
sql-createusermapping.html	5.37 KB	-rw-r--r--
sql-createview.html	10.31 KB	-rw-r--r--
sql-deallocate.html	3.7 KB	-rw-r--r--
sql-declare.html	15.04 KB	-rw-r--r--
sql-delete.html	11.5 KB	-rw-r--r--
sql-discard.html	4.21 KB	-rw-r--r--
sql-do.html	5.08 KB	-rw-r--r--
sql-drop-owned.html	4.94 KB	-rw-r--r--
sql-dropaggregate.html	4.45 KB	-rw-r--r--
sql-dropcast.html	4.24 KB	-rw-r--r--
sql-dropcollation.html	4.31 KB	-rw-r--r--
sql-dropconversion.html	4.33 KB	-rw-r--r--
sql-dropdatabase.html	4.24 KB	-rw-r--r--
sql-dropdomain.html	4.16 KB	-rw-r--r--
sql-dropextension.html	4.67 KB	-rw-r--r--
sql-dropforeigndatawrapper.htm...	4.42 KB	-rw-r--r--
sql-dropforeigntable.html	4.45 KB	-rw-r--r--
sql-dropfunction.html	5.7 KB	-rw-r--r--
sql-dropgroup.html	2.98 KB	-rw-r--r--
sql-dropindex.html	5.06 KB	-rw-r--r--
sql-droplanguage.html	4.73 KB	-rw-r--r--
sql-dropopclass.html	5.54 KB	-rw-r--r--
sql-dropoperator.html	5.1 KB	-rw-r--r--
sql-dropopfamily.html	5.16 KB	-rw-r--r--
sql-droprole.html	5.04 KB	-rw-r--r--
sql-droprule.html	4.05 KB	-rw-r--r--
sql-dropschema.html	4.42 KB	-rw-r--r--
sql-dropsequence.html	4.26 KB	-rw-r--r--
sql-dropserver.html	4.17 KB	-rw-r--r--
sql-droptable.html	4.91 KB	-rw-r--r--
sql-droptablespace.html	4.48 KB	-rw-r--r--
sql-droptrigger.html	4.6 KB	-rw-r--r--
sql-droptsconfig.html	4.66 KB	-rw-r--r--
sql-droptsdictionary.html	4.58 KB	-rw-r--r--
sql-droptsparser.html	4.49 KB	-rw-r--r--
sql-droptstemplate.html	4.46 KB	-rw-r--r--
sql-droptype.html	4.36 KB	-rw-r--r--
sql-dropuser.html	3.11 KB	-rw-r--r--
sql-dropusermapping.html	4.57 KB	-rw-r--r--
sql-dropview.html	4.16 KB	-rw-r--r--
sql-end.html	4.06 KB	-rw-r--r--
sql-execute.html	4.95 KB	-rw-r--r--
sql-explain.html	16.69 KB	-rw-r--r--
sql-expressions.html	46.68 KB	-rw-r--r--
sql-fetch.html	13.92 KB	-rw-r--r--
sql-grant.html	28.56 KB	-rw-r--r--
sql-insert.html	12.56 KB	-rw-r--r--
sql-keywords-appendix.html	104.04 KB	-rw-r--r--
sql-listen.html	5.76 KB	-rw-r--r--
sql-load.html	4.11 KB	-rw-r--r--
sql-lock.html	11.59 KB	-rw-r--r--
sql-move.html	4.87 KB	-rw-r--r--
sql-notify.html	10.69 KB	-rw-r--r--
sql-prepare-transaction.html	8.44 KB	-rw-r--r--
sql-prepare.html	8.97 KB	-rw-r--r--
sql-reassign-owned.html	5.22 KB	-rw-r--r--
sql-reindex.html	10.84 KB	-rw-r--r--
sql-release-savepoint.html	4.89 KB	-rw-r--r--
sql-reset.html	4.88 KB	-rw-r--r--
sql-revoke.html	14.53 KB	-rw-r--r--
sql-rollback-prepared.html	4.52 KB	-rw-r--r--
sql-rollback-to.html	6.25 KB	-rw-r--r--
sql-rollback.html	3.9 KB	-rw-r--r--
sql-savepoint.html	5.47 KB	-rw-r--r--
sql-security-label.html	8.67 KB	-rw-r--r--
sql-select.html	77.68 KB	-rw-r--r--
sql-selectinto.html	7.46 KB	-rw-r--r--
sql-set-constraints.html	6.9 KB	-rw-r--r--
sql-set-role.html	6.75 KB	-rw-r--r--
sql-set-session-authorization....	5.92 KB	-rw-r--r--
sql-set-transaction.html	12.4 KB	-rw-r--r--
sql-set.html	11.77 KB	-rw-r--r--
sql-show.html	6.69 KB	-rw-r--r--
sql-start-transaction.html	4.87 KB	-rw-r--r--
sql-syntax-calling-funcs.html	7.89 KB	-rw-r--r--
sql-syntax-lexical.html	42.35 KB	-rw-r--r--
sql-syntax.html	5.3 KB	-rw-r--r--
sql-truncate.html	9.14 KB	-rw-r--r--
sql-unlisten.html	4.81 KB	-rw-r--r--
sql-update.html	15.3 KB	-rw-r--r--
sql-vacuum.html	10.42 KB	-rw-r--r--
sql-values.html	10.39 KB	-rw-r--r--
sql.html	13.25 KB	-rw-r--r--
ssh-tunnels.html	6.12 KB	-rw-r--r--
ssl-tcp.html	13.16 KB	-rw-r--r--
sslinfo.html	7.42 KB	-rw-r--r--
standby-settings.html	5.3 KB	-rw-r--r--
storage-file-layout.html	12.63 KB	-rw-r--r--
storage-fsm.html	3.73 KB	-rw-r--r--
storage-init.html	2.7 KB	-rw-r--r--
storage-page-layout.html	13.57 KB	-rw-r--r--
storage-toast.html	11.21 KB	-rw-r--r--
storage-vm.html	3.46 KB	-rw-r--r--
storage.html	2.88 KB	-rw-r--r--
stylesheet.css	1.5 KB	-rw-r--r--
supported-platforms.html	4.92 KB	-rw-r--r--
tablefunc.html	31.44 KB	-rw-r--r--
tcn.html	4.86 KB	-rw-r--r--
test-parser.html	4.42 KB	-rw-r--r--
textsearch-configuration.html	6.11 KB	-rw-r--r--
textsearch-controls.html	26.33 KB	-rw-r--r--
textsearch-debugging.html	16.82 KB	-rw-r--r--
textsearch-dictionaries.html	30.53 KB	-rw-r--r--
textsearch-features.html	20.81 KB	-rw-r--r--
textsearch-indexes.html	7.21 KB	-rw-r--r--
textsearch-intro.html	18.02 KB	-rw-r--r--
textsearch-limitations.html	3.77 KB	-rw-r--r--
textsearch-migration.html	4.92 KB	-rw-r--r--
textsearch-parsers.html	8.99 KB	-rw-r--r--
textsearch-psql.html	9.13 KB	-rw-r--r--
textsearch-tables.html	9.52 KB	-rw-r--r--
textsearch.html	5.74 KB	-rw-r--r--
transaction-iso.html	26.6 KB	-rw-r--r--
trigger-datachanges.html	4.95 KB	-rw-r--r--
trigger-definition.html	15.14 KB	-rw-r--r--
trigger-example.html	7.57 KB	-rw-r--r--
trigger-interface.html	10.47 KB	-rw-r--r--
triggers.html	3.71 KB	-rw-r--r--
tsearch2.html	9.72 KB	-rw-r--r--
tutorial-accessdb.html	6.88 KB	-rw-r--r--
tutorial-advanced-intro.html	3.26 KB	-rw-r--r--
tutorial-advanced.html	2.79 KB	-rw-r--r--
tutorial-agg.html	7.42 KB	-rw-r--r--
tutorial-arch.html	4.74 KB	-rw-r--r--
tutorial-concepts.html	3.75 KB	-rw-r--r--
tutorial-conclusion.html	2.78 KB	-rw-r--r--
tutorial-createdb.html	8.98 KB	-rw-r--r--
tutorial-delete.html	3.43 KB	-rw-r--r--
tutorial-fk.html	4.32 KB	-rw-r--r--
tutorial-inheritance.html	5.99 KB	-rw-r--r--
tutorial-install.html	4.42 KB	-rw-r--r--
tutorial-join.html	9.46 KB	-rw-r--r--
tutorial-populate.html	4.73 KB	-rw-r--r--
tutorial-select.html	7.84 KB	-rw-r--r--
tutorial-sql-intro.html	4.79 KB	-rw-r--r--
tutorial-sql.html	2.99 KB	-rw-r--r--
tutorial-start.html	2.57 KB	-rw-r--r--
tutorial-table.html	5.57 KB	-rw-r--r--
tutorial-transactions.html	9.71 KB	-rw-r--r--
tutorial-update.html	3.08 KB	-rw-r--r--
tutorial-views.html	3.3 KB	-rw-r--r--
tutorial-window.html	12.19 KB	-rw-r--r--
tutorial.html	5.09 KB	-rw-r--r--
typeconv-func.html	11.88 KB	-rw-r--r--
typeconv-oper.html	14.56 KB	-rw-r--r--
typeconv-overview.html	8.11 KB	-rw-r--r--
typeconv-query.html	5.32 KB	-rw-r--r--
typeconv-union-case.html	6.46 KB	-rw-r--r--
typeconv.html	3.63 KB	-rw-r--r--
unaccent.html	6.58 KB	-rw-r--r--
unsupported-features-sql-stand...	34.29 KB	-rw-r--r--
upgrading.html	12.5 KB	-rw-r--r--
user-manag.html	3.89 KB	-rw-r--r--
using-explain.html	40.84 KB	-rw-r--r--
uuid-ossp.html	7.06 KB	-rw-r--r--
vacuumlo.html	7.37 KB	-rw-r--r--
view-pg-available-extension-ve...	4.53 KB	-rw-r--r--
view-pg-available-extensions.h...	3.85 KB	-rw-r--r--
view-pg-cursors.html	5.54 KB	-rw-r--r--
view-pg-group.html	3.81 KB	-rw-r--r--
view-pg-indexes.html	4.06 KB	-rw-r--r--
view-pg-locks.html	14.11 KB	-rw-r--r--
view-pg-prepared-statements.ht...	4.94 KB	-rw-r--r--
view-pg-prepared-xacts.html	4.8 KB	-rw-r--r--
view-pg-roles.html	5.93 KB	-rw-r--r--
view-pg-rules.html	3.91 KB	-rw-r--r--
view-pg-seclabels.html	5 KB	-rw-r--r--
view-pg-settings.html	10.35 KB	-rw-r--r--
view-pg-shadow.html	5.25 KB	-rw-r--r--
view-pg-stats.html	8.68 KB	-rw-r--r--
view-pg-tables.html	4.72 KB	-rw-r--r--
view-pg-timezone-abbrevs.html	3.77 KB	-rw-r--r--
view-pg-timezone-names.html	4.08 KB	-rw-r--r--
view-pg-user-mappings.html	5.04 KB	-rw-r--r--
view-pg-user.html	4.41 KB	-rw-r--r--
view-pg-views.html	3.76 KB	-rw-r--r--
views-overview.html	6.39 KB	-rw-r--r--
wal-async-commit.html	8.8 KB	-rw-r--r--
wal-configuration.html	14.61 KB	-rw-r--r--
wal-internals.html	6.01 KB	-rw-r--r--
wal-intro.html	5.4 KB	-rw-r--r--
wal-reliability.html	11.21 KB	-rw-r--r--
wal.html	2.86 KB	-rw-r--r--
warm-standby-failover.html	5.96 KB	-rw-r--r--
warm-standby.html	33.83 KB	-rw-r--r--
xaggr.html	9.67 KB	-rw-r--r--
xfunc-c.html	76.68 KB	-rw-r--r--
xfunc-internal.html	3.91 KB	-rw-r--r--
xfunc-overload.html	5.77 KB	-rw-r--r--
xfunc-pl.html	2.92 KB	-rw-r--r--
xfunc-sql.html	37.14 KB	-rw-r--r--
xfunc-volatility.html	9.61 KB	-rw-r--r--
xfunc.html	4.41 KB	-rw-r--r--
xindex.html	43.55 KB	-rw-r--r--
xml2.html	16.5 KB	-rw-r--r--
xoper-optimization.html	22.6 KB	-rw-r--r--
xoper.html	4.72 KB	-rw-r--r--
xplang-install.html	10.87 KB	-rw-r--r--
xplang.html	4.14 KB	-rw-r--r--
xtypes.html	11.83 KB	-rw-r--r--

Code Editor : plpgsql-statements.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Basic Statements</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="PL/pgSQL - SQL Procedural Language"
HREF="plpgsql.html"><LINK
REL="PREVIOUS"
TITLE="Expressions"
HREF="plpgsql-expressions.html"><LINK
REL="NEXT"
TITLE="Control Structures"
HREF="plpgsql-control-structures.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Expressions"
HREF="plpgsql-expressions.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="plpgsql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 39. PL/pgSQL - <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> Procedural Language</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Control Structures"
HREF="plpgsql-control-structures.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="PLPGSQL-STATEMENTS"
>39.5. Basic Statements</A
></H1
> In this section and the following ones, we describe all the statement
 types that are explicitly understood by
 PL/pgSQL.
 Anything not recognized as one of these statement types is presumed
 to be an SQL command and is sent to the main database engine to execute,
 as described in <A
HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT"
>Section 39.5.2</A
>
 and <A
HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW"
>Section 39.5.3</A
>.
 <DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-ASSIGNMENT"
>39.5.1. Assignment</A
></H2
> An assignment of a value to a PL/pgSQL
 variable is written as:
<PRE
CLASS="SYNOPSIS"
><TT
CLASS="REPLACEABLE"
>variable</TT
> := <TT
CLASS="REPLACEABLE"
>expression</TT
>;</PRE
>
 As explained previously, the expression in such a statement is evaluated
 by means of an SQL <TT
CLASS="COMMAND"
>SELECT</TT
> command sent to the main
 database engine. The expression must yield a single value (possibly
 a row value, if the variable is a row or record variable). The target
 variable can be a simple variable (optionally qualified with a block
 name), a field of a row or record variable, or an element of an array
 that is a simple variable or field.
 If the expression's result data type doesn't match the variable's
 data type, or the variable has a specific size/precision
 (like <TT
CLASS="TYPE"
>char(20)</TT
>), the result value will be implicitly
 converted by the PL/pgSQL interpreter using
 the result type's output-function and
 the variable type's input-function. Note that this could potentially
 result in run-time errors generated by the input function, if the
 string form of the result value is not acceptable to the input function.
 Examples:
<PRE
CLASS="PROGRAMLISTING"
>tax := subtotal * 0.06;
my_record.user_id := 20;</PRE
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-SQL-NORESULT"
>39.5.2. Executing a Command With No Result</A
></H2
> For any SQL command that does not return rows, for example
 <TT
CLASS="COMMAND"
>INSERT</TT
> without a <TT
CLASS="LITERAL"
>RETURNING</TT
> clause, you can
 execute the command within a PL/pgSQL function
 just by writing the command.
 Any PL/pgSQL variable name appearing
 in the command text is treated as a parameter, and then the
 current value of the variable is provided as the parameter value
 at run time. This is exactly like the processing described earlier
 for expressions; for details see <A
HREF="plpgsql-implementation.html#PLPGSQL-VAR-SUBST"
>Section 39.10.1</A
>.
 When executing a SQL command in this way,
 PL/pgSQL may cache and re-use the execution
 plan for the command, as discussed in
 <A
HREF="plpgsql-implementation.html#PLPGSQL-PLAN-CACHING"
>Section 39.10.2</A
>.
 Sometimes it is useful to evaluate an expression or <TT
CLASS="COMMAND"
>SELECT</TT
>
 query but discard the result, for example when calling a function
 that has side-effects but no useful result value. To do
 this in PL/pgSQL, use the
 <TT
CLASS="COMMAND"
>PERFORM</TT
> statement:

<PRE
CLASS="SYNOPSIS"
>PERFORM <TT
CLASS="REPLACEABLE"
>query</TT
>;</PRE
>

This executes <TT
CLASS="REPLACEABLE"
>query</TT
> and discards the
 result. Write the <TT
CLASS="REPLACEABLE"
>query</TT
> the same
 way you would write an SQL <TT
CLASS="COMMAND"
>SELECT</TT
> command, but replace the
 initial keyword <TT
CLASS="COMMAND"
>SELECT</TT
> with <TT
CLASS="COMMAND"
>PERFORM</TT
>.
 For <TT
CLASS="COMMAND"
>WITH</TT
> queries, use <TT
CLASS="COMMAND"
>PERFORM</TT
> and then
 place the query in parentheses. (In this case, the query can only
 return one row.)
 PL/pgSQL variables will be
 substituted into the query just as for commands that return no result,
 and the plan is cached in the same way. Also, the special variable
 <TT
CLASS="LITERAL"
>FOUND</TT
> is set to true if the query produced at
 least one row, or false if it produced no rows (see
 <A
HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS"
>Section 39.5.5</A
>).
 <DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
>Note: One might expect that writing <TT
CLASS="COMMAND"
>SELECT</TT
> directly
 would accomplish this result, but at
 present the only accepted way to do it is
 <TT
CLASS="COMMAND"
>PERFORM</TT
>. A SQL command that can return rows,
 such as <TT
CLASS="COMMAND"
>SELECT</TT
>, will be rejected as an error
 unless it has an <TT
CLASS="LITERAL"
>INTO</TT
> clause as discussed in the
 next section.
 </BLOCKQUOTE
></DIV
> An example:
<PRE
CLASS="PROGRAMLISTING"
>PERFORM create_mv('cs_session_page_requests_mv', my_query);</PRE
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-SQL-ONEROW"
>39.5.3. Executing a Query with a Single-row Result</A
></H2
> The result of a SQL command yielding a single row (possibly of multiple
 columns) can be assigned to a record variable, row-type variable, or list
 of scalar variables. This is done by writing the base SQL command and
 adding an <TT
CLASS="LITERAL"
>INTO</TT
> clause. For example,

<PRE
CLASS="SYNOPSIS"
>SELECT <TT
CLASS="REPLACEABLE"
>select_expressions</TT
> INTO [STRICT] <TT
CLASS="REPLACEABLE"
>target</TT
> FROM ...;
INSERT ... RETURNING <TT
CLASS="REPLACEABLE"
>expressions</TT
> INTO [STRICT] <TT
CLASS="REPLACEABLE"
>target</TT
>;
UPDATE ... RETURNING <TT
CLASS="REPLACEABLE"
>expressions</TT
> INTO [STRICT] <TT
CLASS="REPLACEABLE"
>target</TT
>;
DELETE ... RETURNING <TT
CLASS="REPLACEABLE"
>expressions</TT
> INTO [STRICT] <TT
CLASS="REPLACEABLE"
>target</TT
>;</PRE
>

where <TT
CLASS="REPLACEABLE"
>target</TT
> can be a record variable, a row
 variable, or a comma-separated list of simple variables and
 record/row fields.
 PL/pgSQL variables will be
 substituted into the rest of the query, and the plan is cached,
 just as described above for commands that do not return rows.
 This works for <TT
CLASS="COMMAND"
>SELECT</TT
>,
 <TT
CLASS="COMMAND"
>INSERT</TT
>/<TT
CLASS="COMMAND"
>UPDATE</TT
>/<TT
CLASS="COMMAND"
>DELETE</TT
> with
 <TT
CLASS="LITERAL"
>RETURNING</TT
>, and utility commands that return row-set
 results (such as <TT
CLASS="COMMAND"
>EXPLAIN</TT
>).
 Except for the <TT
CLASS="LITERAL"
>INTO</TT
> clause, the SQL command is the same
 as it would be written outside PL/pgSQL.
 <DIV
CLASS="TIP"
><BLOCKQUOTE
CLASS="TIP"
>Tip: Note that this interpretation of <TT
CLASS="COMMAND"
>SELECT</TT
> with <TT
CLASS="LITERAL"
>INTO</TT
>
 is quite different from PostgreSQL's regular
 <TT
CLASS="COMMAND"
>SELECT INTO</TT
> command, wherein the <TT
CLASS="LITERAL"
>INTO</TT
>
 target is a newly created table. If you want to create a table from a
 <TT
CLASS="COMMAND"
>SELECT</TT
> result inside a
 PL/pgSQL function, use the syntax
 <TT
CLASS="COMMAND"
>CREATE TABLE ... AS SELECT</TT
>.
 </BLOCKQUOTE
></DIV
> If a row or a variable list is used as target, the query's result columns
 must exactly match the structure of the target as to number and data
 types, or else a run-time error
 occurs. When a record variable is the target, it automatically
 configures itself to the row type of the query result columns.
 The <TT
CLASS="LITERAL"
>INTO</TT
> clause can appear almost anywhere in the SQL
 command. Customarily it is written either just before or just after
 the list of <TT
CLASS="REPLACEABLE"
>select_expressions</TT
> in a
 <TT
CLASS="COMMAND"
>SELECT</TT
> command, or at the end of the command for other
 command types. It is recommended that you follow this convention
 in case the PL/pgSQL parser becomes
 stricter in future versions.
 If <TT
CLASS="LITERAL"
>STRICT</TT
> is not specified in the <TT
CLASS="LITERAL"
>INTO</TT
>
 clause, then <TT
CLASS="REPLACEABLE"
>target</TT
> will be set to the first
 row returned by the query, or to nulls if the query returned no rows.
 (Note that "the first row" is not
 well-defined unless you've used <TT
CLASS="LITERAL"
>ORDER BY</TT
>.) Any result rows
 after the first row are discarded.
 You can check the special <TT
CLASS="LITERAL"
>FOUND</TT
> variable (see
 <A
HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS"
>Section 39.5.5</A
>) to
 determine whether a row was returned:

<PRE
CLASS="PROGRAMLISTING"
>SELECT * INTO myrec FROM emp WHERE empname = myname;
IF NOT FOUND THEN
 RAISE EXCEPTION 'employee % not found', myname;
END IF;</PRE
>

If the <TT
CLASS="LITERAL"
>STRICT</TT
> option is specified, the query must
 return exactly one row or a run-time error will be reported, either
 <TT
CLASS="LITERAL"
>NO_DATA_FOUND</TT
> (no rows) or <TT
CLASS="LITERAL"
>TOO_MANY_ROWS</TT
>
 (more than one row). You can use an exception block if you wish
 to catch the error, for example:

<PRE
CLASS="PROGRAMLISTING"
>BEGIN
 SELECT * INTO STRICT myrec FROM emp WHERE empname = myname;
 EXCEPTION
 WHEN NO_DATA_FOUND THEN
 RAISE EXCEPTION 'employee % not found', myname;
 WHEN TOO_MANY_ROWS THEN
 RAISE EXCEPTION 'employee % not unique', myname;
END;</PRE
>
 Successful execution of a command with <TT
CLASS="LITERAL"
>STRICT</TT
>
 always sets <TT
CLASS="LITERAL"
>FOUND</TT
> to true.
 For <TT
CLASS="COMMAND"
>INSERT</TT
>/<TT
CLASS="COMMAND"
>UPDATE</TT
>/<TT
CLASS="COMMAND"
>DELETE</TT
> with
 <TT
CLASS="LITERAL"
>RETURNING</TT
>, PL/pgSQL reports
 an error for more than one returned row, even when
 <TT
CLASS="LITERAL"
>STRICT</TT
> is not specified. This is because there
 is no option such as <TT
CLASS="LITERAL"
>ORDER BY</TT
> with which to determine
 which affected row should be returned.
 <DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
>Note: The <TT
CLASS="LITERAL"
>STRICT</TT
> option matches the behavior of
 Oracle PL/SQL's <TT
CLASS="COMMAND"
>SELECT INTO</TT
> and related statements.
 </BLOCKQUOTE
></DIV
> To handle cases where you need to process multiple result rows
 from a SQL query, see <A
HREF="plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING"
>Section 39.6.4</A
>.
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-EXECUTING-DYN"
>39.5.4. Executing Dynamic Commands</A
></H2
> Oftentimes you will want to generate dynamic commands inside your
 PL/pgSQL functions, that is, commands
 that will involve different tables or different data types each
 time they are executed. PL/pgSQL's
 normal attempts to cache plans for commands (as discussed in
 <A
HREF="plpgsql-implementation.html#PLPGSQL-PLAN-CACHING"
>Section 39.10.2</A
>) will not work in such
 scenarios. To handle this sort of problem, the
 <TT
CLASS="COMMAND"
>EXECUTE</TT
> statement is provided:

<PRE
CLASS="SYNOPSIS"
>EXECUTE <TT
CLASS="REPLACEABLE"
>command-string</TT
> [ INTO [STRICT] <TT
CLASS="REPLACEABLE"
>target</TT
> ] [ USING <TT
CLASS="REPLACEABLE"
>expression</TT
> [, ... ] ];</PRE
>

where <TT
CLASS="REPLACEABLE"
>command-string</TT
> is an expression
 yielding a string (of type <TT
CLASS="TYPE"
>text</TT
>) containing the
 command to be executed. The optional <TT
CLASS="REPLACEABLE"
>target</TT
>
 is a record variable, a row variable, or a comma-separated list of
 simple variables and record/row fields, into which the results of
 the command will be stored. The optional <TT
CLASS="LITERAL"
>USING</TT
> expressions
 supply values to be inserted into the command.
 No substitution of PL/pgSQL variables is done on the
 computed command string. Any required variable values must be inserted
 in the command string as it is constructed; or you can use parameters
 as described below.
 Also, there is no plan caching for commands executed via
 <TT
CLASS="COMMAND"
>EXECUTE</TT
>. Instead, the command is always planned
 each time the statement is run. Thus the command
 string can be dynamically created within the function to perform
 actions on different tables and columns.
 The <TT
CLASS="LITERAL"
>INTO</TT
> clause specifies where the results of
 a SQL command returning rows should be assigned. If a row
 or variable list is provided, it must exactly match the structure
 of the query's results (when a
 record variable is used, it will configure itself to match the
 result structure automatically). If multiple rows are returned,
 only the first will be assigned to the <TT
CLASS="LITERAL"
>INTO</TT
>
 variable. If no rows are returned, NULL is assigned to the
 <TT
CLASS="LITERAL"
>INTO</TT
> variable(s). If no <TT
CLASS="LITERAL"
>INTO</TT
>
 clause is specified, the query results are discarded.
 If the <TT
CLASS="LITERAL"
>STRICT</TT
> option is given, an error is reported
 unless the query produces exactly one row.
 The command string can use parameter values, which are referenced
 in the command as <TT
CLASS="LITERAL"
>$1</TT
>, <TT
CLASS="LITERAL"
>$2</TT
>, etc.
 These symbols refer to values supplied in the <TT
CLASS="LITERAL"
>USING</TT
>
 clause. This method is often preferable to inserting data values
 into the command string as text: it avoids run-time overhead of
 converting the values to text and back, and it is much less prone
 to SQL-injection attacks since there is no need for quoting or escaping.
 An example is:
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE 'SELECT count(*) FROM mytable WHERE inserted_by = $1 AND inserted &lt;= $2'
 INTO c
 USING checked_user, checked_date;</PRE
>
 Note that parameter symbols can only be used for data values
 &mdash; if you want to use dynamically determined table or column
 names, you must insert them into the command string textually.
 For example, if the preceding query needed to be done against a
 dynamically selected table, you could do this:
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE 'SELECT count(*) FROM '
 || tabname::regclass
 || ' WHERE inserted_by = $1 AND inserted &lt;= $2'
 INTO c
 USING checked_user, checked_date;</PRE
>
 Another restriction on parameter symbols is that they only work in
 <TT
CLASS="COMMAND"
>SELECT</TT
>, <TT
CLASS="COMMAND"
>INSERT</TT
>, <TT
CLASS="COMMAND"
>UPDATE</TT
>, and
 <TT
CLASS="COMMAND"
>DELETE</TT
> commands. In other statement
 types (generically called utility statements), you must insert
 values textually even if they are just data values.
 An <TT
CLASS="COMMAND"
>EXECUTE</TT
> with a simple constant command string and some
 <TT
CLASS="LITERAL"
>USING</TT
> parameters, as in the first example above, is
 functionally equivalent to just writing the command directly in
 PL/pgSQL and allowing replacement of
 PL/pgSQL variables to happen automatically.
 The important difference is that <TT
CLASS="COMMAND"
>EXECUTE</TT
> will re-plan
 the command on each execution, generating a plan that is specific
 to the current parameter values; whereas
 PL/pgSQL may otherwise create a generic plan
 and cache it for re-use. In situations where the best plan depends
 strongly on the parameter values, it can be helpful to use
 <TT
CLASS="COMMAND"
>EXECUTE</TT
> to positively ensure that a generic plan is not
 selected.
 <TT
CLASS="COMMAND"
>SELECT INTO</TT
> is not currently supported within
 <TT
CLASS="COMMAND"
>EXECUTE</TT
>; instead, execute a plain <TT
CLASS="COMMAND"
>SELECT</TT
>
 command and specify <TT
CLASS="LITERAL"
>INTO</TT
> as part of the <TT
CLASS="COMMAND"
>EXECUTE</TT
>
 itself.
 <DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
>Note: The PL/pgSQL
 <TT
CLASS="COMMAND"
>EXECUTE</TT
> statement is not related to the
 <A
HREF="sql-execute.html"
>EXECUTE</A
> SQL
 statement supported by the
 PostgreSQL server. The server's
 <TT
CLASS="COMMAND"
>EXECUTE</TT
> statement cannot be used directly within
 PL/pgSQL functions (and is not needed).
 </BLOCKQUOTE
></DIV
><DIV
CLASS="EXAMPLE"
><A
NAME="PLPGSQL-QUOTE-LITERAL-EXAMPLE"
></A
>Example 39-1. Quoting Values In Dynamic Queries When working with dynamic commands you will often have to handle escaping
 of single quotes. The recommended method for quoting fixed text in your
 function body is dollar quoting. (If you have legacy code that does
 not use dollar quoting, please refer to the
 overview in <A
HREF="plpgsql-development-tips.html#PLPGSQL-QUOTE-TIPS"
>Section 39.11.1</A
>, which can save you
 some effort when translating said code to a more reasonable scheme.)
 Dynamic values that are to be inserted into the constructed
 query require careful handling since they might themselves contain
 quote characters.
 An example (this assumes that you are using dollar quoting for the
 function as a whole, so the quote marks need not be doubled):
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE 'UPDATE tbl SET '
 || quote_ident(colname)
 || ' = '
 || quote_literal(newvalue)
 || ' WHERE key = '
 || quote_literal(keyvalue);</PRE
>
 This example demonstrates the use of the
 <CODE
CLASS="FUNCTION"
>quote_ident</CODE
> and
 <CODE
CLASS="FUNCTION"
>quote_literal</CODE
> functions (see <A
HREF="functions-string.html"
>Section 9.4</A
>). For safety, expressions containing column
 or table identifiers should be passed through
 <CODE
CLASS="FUNCTION"
>quote_ident</CODE
> before insertion in a dynamic query.
 Expressions containing values that should be literal strings in the
 constructed command should be passed through <CODE
CLASS="FUNCTION"
>quote_literal</CODE
>.
 These functions take the appropriate steps to return the input text
 enclosed in double or single quotes respectively, with any embedded
 special characters properly escaped.
 Because <CODE
CLASS="FUNCTION"
>quote_literal</CODE
> is labelled
 <TT
CLASS="LITERAL"
>STRICT</TT
>, it will always return null when called with a
 null argument. In the above example, if <TT
CLASS="LITERAL"
>newvalue</TT
> or
 <TT
CLASS="LITERAL"
>keyvalue</TT
> were null, the entire dynamic query string would
 become null, leading to an error from <TT
CLASS="COMMAND"
>EXECUTE</TT
>.
 You can avoid this problem by using the <CODE
CLASS="FUNCTION"
>quote_nullable</CODE
>
 function, which works the same as <CODE
CLASS="FUNCTION"
>quote_literal</CODE
> except that
 when called with a null argument it returns the string <TT
CLASS="LITERAL"
>NULL</TT
>.
 For example,
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE 'UPDATE tbl SET '
 || quote_ident(colname)
 || ' = '
 || quote_nullable(newvalue)
 || ' WHERE key = '
 || quote_nullable(keyvalue);</PRE
>
 If you are dealing with values that might be null, you should usually
 use <CODE
CLASS="FUNCTION"
>quote_nullable</CODE
> in place of <CODE
CLASS="FUNCTION"
>quote_literal</CODE
>.
 As always, care must be taken to ensure that null values in a query do
 not deliver unintended results. For example the <TT
CLASS="LITERAL"
>WHERE</TT
> clause
<PRE
CLASS="PROGRAMLISTING"
>'WHERE key = ' || quote_nullable(keyvalue)</PRE
>
 will never succeed if <TT
CLASS="LITERAL"
>keyvalue</TT
> is null, because the
 result of using the equality operator <TT
CLASS="LITERAL"
>=</TT
> with a null operand
 is always null. If you wish null to work like an ordinary key value,
 you would need to rewrite the above as
<PRE
CLASS="PROGRAMLISTING"
>'WHERE key IS NOT DISTINCT FROM ' || quote_nullable(keyvalue)</PRE
>
 (At present, <TT
CLASS="LITERAL"
>IS NOT DISTINCT FROM</TT
> is handled much less
 efficiently than <TT
CLASS="LITERAL"
>=</TT
>, so don't do this unless you must.
 See <A
HREF="functions-comparison.html"
>Section 9.2</A
> for
 more information on nulls and <TT
CLASS="LITERAL"
>IS DISTINCT</TT
>.)
 Note that dollar quoting is only useful for quoting fixed text.
 It would be a very bad idea to try to write this example as:
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE 'UPDATE tbl SET '
 || quote_ident(colname)
 || ' = $$'
 || newvalue
 || '$$ WHERE key = '
 || quote_literal(keyvalue);</PRE
>
 because it would break if the contents of <TT
CLASS="LITERAL"
>newvalue</TT
>
 happened to contain <TT
CLASS="LITERAL"
>$$</TT
>. The same objection would
 apply to any other dollar-quoting delimiter you might pick.
 So, to safely quote text that is not known in advance, you
 must use <CODE
CLASS="FUNCTION"
>quote_literal</CODE
>,
 <CODE
CLASS="FUNCTION"
>quote_nullable</CODE
>, or <CODE
CLASS="FUNCTION"
>quote_ident</CODE
>, as appropriate.
 Dynamic SQL statements can also be safely constructed using the
 <CODE
CLASS="FUNCTION"
>format</CODE
> function (see <A
HREF="functions-string.html"
>Section 9.4</A
>). For example:
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE format('UPDATE tbl SET %I = %L WHERE key = %L', colname, newvalue, keyvalue);</PRE
>
 The <CODE
CLASS="FUNCTION"
>format</CODE
> function can be used in conjunction with
 the <TT
CLASS="LITERAL"
>USING</TT
> clause:
<PRE
CLASS="PROGRAMLISTING"
>EXECUTE format('UPDATE tbl SET %I = $1 WHERE key = $2', colname)
 USING newvalue, keyvalue;</PRE
>
 This form is more efficient, because the parameters
 <TT
CLASS="LITERAL"
>newvalue</TT
> and <TT
CLASS="LITERAL"
>keyvalue</TT
> are not
 converted to text.
 </DIV
> A much larger example of a dynamic command and
 <TT
CLASS="COMMAND"
>EXECUTE</TT
> can be seen in <A
HREF="plpgsql-porting.html#PLPGSQL-PORTING-EX2"
>Example 39-8</A
>, which builds and executes a
 <TT
CLASS="COMMAND"
>CREATE FUNCTION</TT
> command to define a new function.
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-DIAGNOSTICS"
>39.5.5. Obtaining the Result Status</A
></H2
> There are several ways to determine the effect of a command. The
 first method is to use the <TT
CLASS="COMMAND"
>GET DIAGNOSTICS</TT
>
 command, which has the form:

<PRE
CLASS="SYNOPSIS"
>GET [ CURRENT ] DIAGNOSTICS <TT
CLASS="REPLACEABLE"
>variable</TT
> = <TT
CLASS="REPLACEABLE"
>item</TT
> [ , ... ];</PRE
>

This command allows retrieval of system status indicators. Each
 <TT
CLASS="REPLACEABLE"
>item</TT
> is a key word identifying a status
 value to be assigned to the specified variable (which should be
 of the right data type to receive it). The currently available
 status items are <TT
CLASS="VARNAME"
>ROW_COUNT</TT
>, the number of rows
 processed by the last <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> command sent to
 the <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> engine, and <TT
CLASS="VARNAME"
>RESULT_OID</TT
>,
 the OID of the last row inserted by the most recent
 <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> command. Note that <TT
CLASS="VARNAME"
>RESULT_OID</TT
>
 is only useful after an <TT
CLASS="COMMAND"
>INSERT</TT
> command into a
 table containing OIDs.
 An example:
<PRE
CLASS="PROGRAMLISTING"
>GET DIAGNOSTICS integer_var = ROW_COUNT;</PRE
>
 The second method to determine the effects of a command is to check the
 special variable named <TT
CLASS="LITERAL"
>FOUND</TT
>, which is of
 type <TT
CLASS="TYPE"
>boolean</TT
>. <TT
CLASS="LITERAL"
>FOUND</TT
> starts out
 false within each PL/pgSQL function call.
 It is set by each of the following types of statements:

<UL
><LI
> A <TT
CLASS="COMMAND"
>SELECT INTO</TT
> statement sets
 <TT
CLASS="LITERAL"
>FOUND</TT
> true if a row is assigned, false if no
 row is returned.
 </LI
><LI
> A <TT
CLASS="COMMAND"
>PERFORM</TT
> statement sets <TT
CLASS="LITERAL"
>FOUND</TT
>
 true if it produces (and discards) one or more rows, false if
 no row is produced.
 </LI
><LI
> <TT
CLASS="COMMAND"
>UPDATE</TT
>, <TT
CLASS="COMMAND"
>INSERT</TT
>, and <TT
CLASS="COMMAND"
>DELETE</TT
>
 statements set <TT
CLASS="LITERAL"
>FOUND</TT
> true if at least one
 row is affected, false if no row is affected.
 </LI
><LI
> A <TT
CLASS="COMMAND"
>FETCH</TT
> statement sets <TT
CLASS="LITERAL"
>FOUND</TT
>
 true if it returns a row, false if no row is returned.
 </LI
><LI
> A <TT
CLASS="COMMAND"
>MOVE</TT
> statement sets <TT
CLASS="LITERAL"
>FOUND</TT
>
 true if it successfully repositions the cursor, false otherwise.
 </LI
><LI
> A <TT
CLASS="COMMAND"
>FOR</TT
> or <TT
CLASS="COMMAND"
>FOREACH</TT
> statement sets
 <TT
CLASS="LITERAL"
>FOUND</TT
> true
 if it iterates one or more times, else false.
 <TT
CLASS="LITERAL"
>FOUND</TT
> is set this way when the
 loop exits; inside the execution of the loop,
 <TT
CLASS="LITERAL"
>FOUND</TT
> is not modified by the
 loop statement, although it might be changed by the
 execution of other statements within the loop body.
 </LI
><LI
> <TT
CLASS="COMMAND"
>RETURN QUERY</TT
> and <TT
CLASS="COMMAND"
>RETURN QUERY
 EXECUTE</TT
> statements set <TT
CLASS="LITERAL"
>FOUND</TT
>
 true if the query returns at least one row, false if no row
 is returned.
 </LI
></UL
>

Other PL/pgSQL statements do not change
 the state of <TT
CLASS="LITERAL"
>FOUND</TT
>.
 Note in particular that <TT
CLASS="COMMAND"
>EXECUTE</TT
>
 changes the output of <TT
CLASS="COMMAND"
>GET DIAGNOSTICS</TT
>, but
 does not change <TT
CLASS="LITERAL"
>FOUND</TT
>.
 <TT
CLASS="LITERAL"
>FOUND</TT
> is a local variable within each
 PL/pgSQL function; any changes to it
 affect only the current function.
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="PLPGSQL-STATEMENTS-NULL"
>39.5.6. Doing Nothing At All</A
></H2
> Sometimes a placeholder statement that does nothing is useful.
 For example, it can indicate that one arm of an if/then/else
 chain is deliberately empty. For this purpose, use the
 <TT
CLASS="COMMAND"
>NULL</TT
> statement:

<PRE
CLASS="SYNOPSIS"
>NULL;</PRE
>
 For example, the following two fragments of code are equivalent:
<PRE
CLASS="PROGRAMLISTING"
>BEGIN
 y := x / 0;
EXCEPTION
 WHEN division_by_zero THEN
 NULL; -- ignore the error
END;</PRE
>

<PRE
CLASS="PROGRAMLISTING"
>BEGIN
 y := x / 0;
EXCEPTION
 WHEN division_by_zero THEN -- ignore the error
END;</PRE
>
 Which is preferable is a matter of taste.
 <DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
>Note: In Oracle's PL/SQL, empty statement lists are not allowed, and so
 <TT
CLASS="COMMAND"
>NULL</TT
> statements are required for situations
 such as this. PL/pgSQL allows you to
 just write nothing, instead.
 </BLOCKQUOTE
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="plpgsql-expressions.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="plpgsql-control-structures.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Expressions</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="plpgsql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Control Structures</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

${this.title}

Code Editor : plpgsql-statements.html