Linux server.kiran-academy.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
: 194.233.91.196 | : 216.73.216.9
Cant Read [ /etc/named.conf ]
7.4.32
finalho
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
share /
doc /
postgresql-9.2.24 /
html /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ecpg-pgtypes.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >pgtypes Library</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="ECPG - Embedded SQL in C" HREF="ecpg.html"><LINK REL="PREVIOUS" TITLE="Dynamic SQL" HREF="ecpg-dynamic.html"><LINK REL="NEXT" TITLE="Using Descriptor Areas" HREF="ecpg-descriptors.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="Dynamic SQL" HREF="ecpg-dynamic.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="ecpg.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Chapter 33. <SPAN CLASS="APPLICATION" >ECPG</SPAN > - Embedded <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > in C</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Using Descriptor Areas" HREF="ecpg-descriptors.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="ECPG-PGTYPES" >33.6. pgtypes Library</A ></H1 ><P > The pgtypes library maps <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > database types to C equivalents that can be used in C programs. It also offers functions to do basic calculations with those types within C, i.e., without the help of the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server. See the following example: </P><PRE CLASS="PROGRAMLISTING" >EXEC SQL BEGIN DECLARE SECTION; date date1; timestamp ts1, tsout; interval iv1; char *out; EXEC SQL END DECLARE SECTION; PGTYPESdate_today(&date1); EXEC SQL SELECT started, duration INTO :ts1, :iv1 FROM datetbl WHERE d=:date1; PGTYPEStimestamp_add_interval(&ts1, &iv1, &tsout); out = PGTYPEStimestamp_to_asc(&tsout); printf("Started + duration: %s\n", out); free(out);</PRE ><P> </P ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-NUMERIC" >33.6.1. The numeric Type</A ></H2 ><P > The numeric type offers to do calculations with arbitrary precision. See <A HREF="datatype-numeric.html" >Section 8.1</A > for the equivalent type in the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server. Because of the arbitrary precision this variable needs to be able to expand and shrink dynamically. That's why you can only create numeric variables on the heap, by means of the <CODE CLASS="FUNCTION" >PGTYPESnumeric_new</CODE > and <CODE CLASS="FUNCTION" >PGTYPESnumeric_free</CODE > functions. The decimal type, which is similar but limited in precision, can be created on the stack as well as on the heap. </P ><P > The following functions can be used to work with the numeric type: <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_new</CODE ></DT ><DD ><P > Request a pointer to a newly allocated numeric variable. </P><PRE CLASS="SYNOPSIS" >numeric *PGTYPESnumeric_new(void);</PRE ><P> </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_free</CODE ></DT ><DD ><P > Free a numeric type, release all of its memory. </P><PRE CLASS="SYNOPSIS" >void PGTYPESnumeric_free(numeric *var);</PRE ><P> </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_from_asc</CODE ></DT ><DD ><P > Parse a numeric type from its string notation. </P><PRE CLASS="SYNOPSIS" >numeric *PGTYPESnumeric_from_asc(char *str, char **endptr);</PRE ><P> Valid formats are for example: <TT CLASS="LITERAL" >-2</TT >, <TT CLASS="LITERAL" >.794</TT >, <TT CLASS="LITERAL" >+3.44</TT >, <TT CLASS="LITERAL" >592.49E07</TT > or <TT CLASS="LITERAL" >-32.84e-4</TT >. If the value could be parsed successfully, a valid pointer is returned, else the NULL pointer. At the moment ECPG always parses the complete string and so it currently does not support to store the address of the first invalid character in <TT CLASS="LITERAL" >*endptr</TT >. You can safely set <TT CLASS="LITERAL" >endptr</TT > to NULL. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_to_asc</CODE ></DT ><DD ><P > Returns a pointer to a string allocated by <CODE CLASS="FUNCTION" >malloc</CODE > that contains the string representation of the numeric type <TT CLASS="LITERAL" >num</TT >. </P><PRE CLASS="SYNOPSIS" >char *PGTYPESnumeric_to_asc(numeric *num, int dscale);</PRE ><P> The numeric value will be printed with <TT CLASS="LITERAL" >dscale</TT > decimal digits, with rounding applied if necessary. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_add</CODE ></DT ><DD ><P > Add two numeric variables into a third one. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_add(numeric *var1, numeric *var2, numeric *result);</PRE ><P> The function adds the variables <TT CLASS="LITERAL" >var1</TT > and <TT CLASS="LITERAL" >var2</TT > into the result variable <TT CLASS="LITERAL" >result</TT >. The function returns 0 on success and -1 in case of error. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_sub</CODE ></DT ><DD ><P > Subtract two numeric variables and return the result in a third one. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_sub(numeric *var1, numeric *var2, numeric *result);</PRE ><P> The function subtracts the variable <TT CLASS="LITERAL" >var2</TT > from the variable <TT CLASS="LITERAL" >var1</TT >. The result of the operation is stored in the variable <TT CLASS="LITERAL" >result</TT >. The function returns 0 on success and -1 in case of error. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_mul</CODE ></DT ><DD ><P > Multiply two numeric variables and return the result in a third one. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_mul(numeric *var1, numeric *var2, numeric *result);</PRE ><P> The function multiplies the variables <TT CLASS="LITERAL" >var1</TT > and <TT CLASS="LITERAL" >var2</TT >. The result of the operation is stored in the variable <TT CLASS="LITERAL" >result</TT >. The function returns 0 on success and -1 in case of error. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_div</CODE ></DT ><DD ><P > Divide two numeric variables and return the result in a third one. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result);</PRE ><P> The function divides the variables <TT CLASS="LITERAL" >var1</TT > by <TT CLASS="LITERAL" >var2</TT >. The result of the operation is stored in the variable <TT CLASS="LITERAL" >result</TT >. The function returns 0 on success and -1 in case of error. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_cmp</CODE ></DT ><DD ><P > Compare two numeric variables. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_cmp(numeric *var1, numeric *var2)</PRE ><P> This function compares two numeric variables. In case of error, <TT CLASS="LITERAL" >INT_MAX</TT > is returned. On success, the function returns one of three possible results: <P ></P ></P><UL ><LI ><P > 1, if <TT CLASS="LITERAL" >var1</TT > is bigger than <TT CLASS="LITERAL" >var2</TT > </P ></LI ><LI ><P > -1, if <TT CLASS="LITERAL" >var1</TT > is smaller than <TT CLASS="LITERAL" >var2</TT > </P ></LI ><LI ><P > 0, if <TT CLASS="LITERAL" >var1</TT > and <TT CLASS="LITERAL" >var2</TT > are equal </P ></LI ></UL ><P> </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_from_int</CODE ></DT ><DD ><P > Convert an int variable to a numeric variable. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_from_int(signed int int_val, numeric *var);</PRE ><P> This function accepts a variable of type signed int and stores it in the numeric variable <TT CLASS="LITERAL" >var</TT >. Upon success, 0 is returned and -1 in case of a failure. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_from_long</CODE ></DT ><DD ><P > Convert a long int variable to a numeric variable. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_from_long(signed long int long_val, numeric *var);</PRE ><P> This function accepts a variable of type signed long int and stores it in the numeric variable <TT CLASS="LITERAL" >var</TT >. Upon success, 0 is returned and -1 in case of a failure. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_copy</CODE ></DT ><DD ><P > Copy over one numeric variable into another one. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_copy(numeric *src, numeric *dst);</PRE ><P> This function copies over the value of the variable that <TT CLASS="LITERAL" >src</TT > points to into the variable that <TT CLASS="LITERAL" >dst</TT > points to. It returns 0 on success and -1 if an error occurs. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_from_double</CODE ></DT ><DD ><P > Convert a variable of type double to a numeric. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_from_double(double d, numeric *dst);</PRE ><P> This function accepts a variable of type double and stores the result in the variable that <TT CLASS="LITERAL" >dst</TT > points to. It returns 0 on success and -1 if an error occurs. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_to_double</CODE ></DT ><DD ><P > Convert a variable of type numeric to double. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_to_double(numeric *nv, double *dp)</PRE ><P> The function converts the numeric value from the variable that <TT CLASS="LITERAL" >nv</TT > points to into the double variable that <TT CLASS="LITERAL" >dp</TT > points to. It returns 0 on success and -1 if an error occurs, including overflow. On overflow, the global variable <TT CLASS="LITERAL" >errno</TT > will be set to <TT CLASS="LITERAL" >PGTYPES_NUM_OVERFLOW</TT > additionally. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_to_int</CODE ></DT ><DD ><P > Convert a variable of type numeric to int. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_to_int(numeric *nv, int *ip);</PRE ><P> The function converts the numeric value from the variable that <TT CLASS="LITERAL" >nv</TT > points to into the integer variable that <TT CLASS="LITERAL" >ip</TT > points to. It returns 0 on success and -1 if an error occurs, including overflow. On overflow, the global variable <TT CLASS="LITERAL" >errno</TT > will be set to <TT CLASS="LITERAL" >PGTYPES_NUM_OVERFLOW</TT > additionally. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_to_long</CODE ></DT ><DD ><P > Convert a variable of type numeric to long. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_to_long(numeric *nv, long *lp);</PRE ><P> The function converts the numeric value from the variable that <TT CLASS="LITERAL" >nv</TT > points to into the long integer variable that <TT CLASS="LITERAL" >lp</TT > points to. It returns 0 on success and -1 if an error occurs, including overflow. On overflow, the global variable <TT CLASS="LITERAL" >errno</TT > will be set to <TT CLASS="LITERAL" >PGTYPES_NUM_OVERFLOW</TT > additionally. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_to_decimal</CODE ></DT ><DD ><P > Convert a variable of type numeric to decimal. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_to_decimal(numeric *src, decimal *dst);</PRE ><P> The function converts the numeric value from the variable that <TT CLASS="LITERAL" >src</TT > points to into the decimal variable that <TT CLASS="LITERAL" >dst</TT > points to. It returns 0 on success and -1 if an error occurs, including overflow. On overflow, the global variable <TT CLASS="LITERAL" >errno</TT > will be set to <TT CLASS="LITERAL" >PGTYPES_NUM_OVERFLOW</TT > additionally. </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESnumeric_from_decimal</CODE ></DT ><DD ><P > Convert a variable of type decimal to numeric. </P><PRE CLASS="SYNOPSIS" >int PGTYPESnumeric_from_decimal(decimal *src, numeric *dst);</PRE ><P> The function converts the decimal value from the variable that <TT CLASS="LITERAL" >src</TT > points to into the numeric variable that <TT CLASS="LITERAL" >dst</TT > points to. It returns 0 on success and -1 if an error occurs. Since the decimal type is implemented as a limited version of the numeric type, overflow cannot occur with this conversion. </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-DATE" >33.6.2. The date Type</A ></H2 ><P > The date type in C enables your programs to deal with data of the SQL type date. See <A HREF="datatype-datetime.html" >Section 8.5</A > for the equivalent type in the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server. </P ><P > The following functions can be used to work with the date type: <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="PGTYPESDATEFROMTIMESTAMP" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_from_timestamp</CODE ></DT ><DD ><P > Extract the date part from a timestamp. </P><PRE CLASS="SYNOPSIS" >date PGTYPESdate_from_timestamp(timestamp dt);</PRE ><P> The function receives a timestamp as its only argument and returns the extracted date part from this timestamp. </P ></DD ><DT ><A NAME="PGTYPESDATEFROMASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_from_asc</CODE ></DT ><DD ><P > Parse a date from its textual representation. </P><PRE CLASS="SYNOPSIS" >date PGTYPESdate_from_asc(char *str, char **endptr);</PRE ><P> The function receives a C char* string <TT CLASS="LITERAL" >str</TT > and a pointer to a C char* string <TT CLASS="LITERAL" >endptr</TT >. At the moment ECPG always parses the complete string and so it currently does not support to store the address of the first invalid character in <TT CLASS="LITERAL" >*endptr</TT >. You can safely set <TT CLASS="LITERAL" >endptr</TT > to NULL. </P ><P > Note that the function always assumes MDY-formatted dates and there is currently no variable to change that within ECPG. </P ><P > <A HREF="ecpg-pgtypes.html#ECPG-PGTYPESDATE-FROM-ASC-TABLE" >Table 33-2</A > shows the allowed input formats. </P ><DIV CLASS="TABLE" ><A NAME="ECPG-PGTYPESDATE-FROM-ASC-TABLE" ></A ><P ><B >Table 33-2. Valid Input Formats for <CODE CLASS="FUNCTION" >PGTYPESdate_from_asc</CODE ></B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Input</TH ><TH >Result</TH ></TR ></THEAD ><TBODY ><TR ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1999-01-08</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1/8/1999</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1/18/1999</TT ></TD ><TD ><TT CLASS="LITERAL" >January 18, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >01/02/03</TT ></TD ><TD ><TT CLASS="LITERAL" >February 1, 2003</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1999-Jan-08</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >Jan-08-1999</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >08-Jan-1999</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >99-Jan-08</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >08-Jan-99</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >08-Jan-06</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 2006</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >Jan-08-99</TT ></TD ><TD ><TT CLASS="LITERAL" >January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >19990108</TT ></TD ><TD ><TT CLASS="LITERAL" >ISO 8601; January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >990108</TT ></TD ><TD ><TT CLASS="LITERAL" >ISO 8601; January 8, 1999</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1999.008</TT ></TD ><TD ><TT CLASS="LITERAL" >year and day of year</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >J2451187</TT ></TD ><TD ><TT CLASS="LITERAL" >Julian day</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >January 8, 99 BC</TT ></TD ><TD ><TT CLASS="LITERAL" >year 99 before the Common Era</TT ></TD ></TR ></TBODY ></TABLE ></DIV ></DD ><DT ><A NAME="PGTYPESDATETOASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_to_asc</CODE ></DT ><DD ><P > Return the textual representation of a date variable. </P><PRE CLASS="SYNOPSIS" >char *PGTYPESdate_to_asc(date dDate);</PRE ><P> The function receives the date <TT CLASS="LITERAL" >dDate</TT > as its only parameter. It will output the date in the form <TT CLASS="LITERAL" >1999-01-18</TT >, i.e., in the <TT CLASS="LITERAL" >YYYY-MM-DD</TT > format. </P ></DD ><DT ><A NAME="PGTYPESDATEJULMDY" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_julmdy</CODE ></DT ><DD ><P > Extract the values for the day, the month and the year from a variable of type date. </P><PRE CLASS="SYNOPSIS" >void PGTYPESdate_julmdy(date d, int *mdy);</PRE ><P> The function receives the date <TT CLASS="LITERAL" >d</TT > and a pointer to an array of 3 integer values <TT CLASS="LITERAL" >mdy</TT >. The variable name indicates the sequential order: <TT CLASS="LITERAL" >mdy[0]</TT > will be set to contain the number of the month, <TT CLASS="LITERAL" >mdy[1]</TT > will be set to the value of the day and <TT CLASS="LITERAL" >mdy[2]</TT > will contain the year. </P ></DD ><DT ><A NAME="PGTYPESDATEMDYJUL" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_mdyjul</CODE ></DT ><DD ><P > Create a date value from an array of 3 integers that specify the day, the month and the year of the date. </P><PRE CLASS="SYNOPSIS" >void PGTYPESdate_mdyjul(int *mdy, date *jdate);</PRE ><P> The function receives the array of the 3 integers (<TT CLASS="LITERAL" >mdy</TT >) as its first argument and as its second argument a pointer to a variable of type date that should hold the result of the operation. </P ></DD ><DT ><A NAME="PGTYPESDATEDAYOFWEEK" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_dayofweek</CODE ></DT ><DD ><P > Return a number representing the day of the week for a date value. </P><PRE CLASS="SYNOPSIS" >int PGTYPESdate_dayofweek(date d);</PRE ><P> The function receives the date variable <TT CLASS="LITERAL" >d</TT > as its only argument and returns an integer that indicates the day of the week for this date. <P ></P ></P><UL ><LI ><P > 0 - Sunday </P ></LI ><LI ><P > 1 - Monday </P ></LI ><LI ><P > 2 - Tuesday </P ></LI ><LI ><P > 3 - Wednesday </P ></LI ><LI ><P > 4 - Thursday </P ></LI ><LI ><P > 5 - Friday </P ></LI ><LI ><P > 6 - Saturday </P ></LI ></UL ><P> </P ></DD ><DT ><A NAME="PGTYPESDATETODAY" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_today</CODE ></DT ><DD ><P > Get the current date. </P><PRE CLASS="SYNOPSIS" >void PGTYPESdate_today(date *d);</PRE ><P> The function receives a pointer to a date variable (<TT CLASS="LITERAL" >d</TT >) that it sets to the current date. </P ></DD ><DT ><A NAME="PGTYPESDATEFMTASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_fmt_asc</CODE ></DT ><DD ><P > Convert a variable of type date to its textual representation using a format mask. </P><PRE CLASS="SYNOPSIS" >int PGTYPESdate_fmt_asc(date dDate, char *fmtstring, char *outbuf);</PRE ><P> The function receives the date to convert (<TT CLASS="LITERAL" >dDate</TT >), the format mask (<TT CLASS="LITERAL" >fmtstring</TT >) and the string that will hold the textual representation of the date (<TT CLASS="LITERAL" >outbuf</TT >). </P ><P > On success, 0 is returned and a negative value if an error occurred. </P ><P > The following literals are the field specifiers you can use: <P ></P ></P><UL ><LI ><P > <TT CLASS="LITERAL" >dd</TT > - The number of the day of the month. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >mm</TT > - The number of the month of the year. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >yy</TT > - The number of the year as a two digit number. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >yyyy</TT > - The number of the year as a four digit number. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >ddd</TT > - The name of the day (abbreviated). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >mmm</TT > - The name of the month (abbreviated). </P ></LI ></UL ><P> All other characters are copied 1:1 to the output string. </P ><P > <A HREF="ecpg-pgtypes.html#ECPG-PGTYPESDATE-FMT-ASC-EXAMPLE-TABLE" >Table 33-3</A > indicates a few possible formats. This will give you an idea of how to use this function. All output lines are based on the same date: November 23, 1959. </P ><DIV CLASS="TABLE" ><A NAME="ECPG-PGTYPESDATE-FMT-ASC-EXAMPLE-TABLE" ></A ><P ><B >Table 33-3. Valid Input Formats for <CODE CLASS="FUNCTION" >PGTYPESdate_fmt_asc</CODE ></B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Format</TH ><TH >Result</TH ></TR ></THEAD ><TBODY ><TR ><TD ><TT CLASS="LITERAL" >mmddyy</TT ></TD ><TD ><TT CLASS="LITERAL" >112359</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >ddmmyy</TT ></TD ><TD ><TT CLASS="LITERAL" >231159</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yymmdd</TT ></TD ><TD ><TT CLASS="LITERAL" >591123</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy/mm/dd</TT ></TD ><TD ><TT CLASS="LITERAL" >59/11/23</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy mm dd</TT ></TD ><TD ><TT CLASS="LITERAL" >59 11 23</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy.mm.dd</TT ></TD ><TD ><TT CLASS="LITERAL" >59.11.23</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >.mm.yyyy.dd.</TT ></TD ><TD ><TT CLASS="LITERAL" >.11.1959.23.</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm. dd, yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >Nov. 23, 1959</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm dd yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >Nov 23 1959</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yyyy dd mm</TT ></TD ><TD ><TT CLASS="LITERAL" >1959 23 11</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >ddd, mmm. dd, yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >Mon, Nov. 23, 1959</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >(ddd) mmm. dd, yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >(Mon) Nov. 23, 1959</TT ></TD ></TR ></TBODY ></TABLE ></DIV ></DD ><DT ><A NAME="PGTYPESDATEDEFMTASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE ></DT ><DD ><P > Use a format mask to convert a C <TT CLASS="TYPE" >char*</TT > string to a value of type date. </P><PRE CLASS="SYNOPSIS" >int PGTYPESdate_defmt_asc(date *d, char *fmt, char *str);</PRE ><P> The function receives a pointer to the date value that should hold the result of the operation (<TT CLASS="LITERAL" >d</TT >), the format mask to use for parsing the date (<TT CLASS="LITERAL" >fmt</TT >) and the C char* string containing the textual representation of the date (<TT CLASS="LITERAL" >str</TT >). The textual representation is expected to match the format mask. However you do not need to have a 1:1 mapping of the string to the format mask. The function only analyzes the sequential order and looks for the literals <TT CLASS="LITERAL" >yy</TT > or <TT CLASS="LITERAL" >yyyy</TT > that indicate the position of the year, <TT CLASS="LITERAL" >mm</TT > to indicate the position of the month and <TT CLASS="LITERAL" >dd</TT > to indicate the position of the day. </P ><P > <A HREF="ecpg-pgtypes.html#ECPG-RDEFMTDATE-EXAMPLE-TABLE" >Table 33-4</A > indicates a few possible formats. This will give you an idea of how to use this function. </P ><DIV CLASS="TABLE" ><A NAME="ECPG-RDEFMTDATE-EXAMPLE-TABLE" ></A ><P ><B >Table 33-4. Valid Input Formats for <CODE CLASS="FUNCTION" >rdefmtdate</CODE ></B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><THEAD ><TR ><TH >Format</TH ><TH >String</TH ><TH >Result</TH ></TR ></THEAD ><TBODY ><TR ><TD ><TT CLASS="LITERAL" >ddmmyy</TT ></TD ><TD ><TT CLASS="LITERAL" >21-2-54</TT ></TD ><TD ><TT CLASS="LITERAL" >1954-02-21</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >ddmmyy</TT ></TD ><TD ><TT CLASS="LITERAL" >2-12-54</TT ></TD ><TD ><TT CLASS="LITERAL" >1954-12-02</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >ddmmyy</TT ></TD ><TD ><TT CLASS="LITERAL" >20111954</TT ></TD ><TD ><TT CLASS="LITERAL" >1954-11-20</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >ddmmyy</TT ></TD ><TD ><TT CLASS="LITERAL" >130464</TT ></TD ><TD ><TT CLASS="LITERAL" >1964-04-13</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm.dd.yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >MAR-12-1967</TT ></TD ><TD ><TT CLASS="LITERAL" >1967-03-12</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy/mm/dd</TT ></TD ><TD ><TT CLASS="LITERAL" >1954, February 3rd</TT ></TD ><TD ><TT CLASS="LITERAL" >1954-02-03</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm.dd.yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >041269</TT ></TD ><TD ><TT CLASS="LITERAL" >1969-04-12</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy/mm/dd</TT ></TD ><TD ><TT CLASS="LITERAL" >In the year 2525, in the month of July, mankind will be alive on the 28th day</TT ></TD ><TD ><TT CLASS="LITERAL" >2525-07-28</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >dd-mm-yy</TT ></TD ><TD ><TT CLASS="LITERAL" >I said on the 28th of July in the year 2525</TT ></TD ><TD ><TT CLASS="LITERAL" >2525-07-28</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm.dd.yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >9/14/58</TT ></TD ><TD ><TT CLASS="LITERAL" >1958-09-14</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >yy/mm/dd</TT ></TD ><TD ><TT CLASS="LITERAL" >47/03/29</TT ></TD ><TD ><TT CLASS="LITERAL" >1947-03-29</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmm.dd.yyyy</TT ></TD ><TD ><TT CLASS="LITERAL" >oct 28 1975</TT ></TD ><TD ><TT CLASS="LITERAL" >1975-10-28</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >mmddyy</TT ></TD ><TD ><TT CLASS="LITERAL" >Nov 14th, 1985</TT ></TD ><TD ><TT CLASS="LITERAL" >1985-11-14</TT ></TD ></TR ></TBODY ></TABLE ></DIV ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-TIMESTAMP" >33.6.3. The timestamp Type</A ></H2 ><P > The timestamp type in C enables your programs to deal with data of the SQL type timestamp. See <A HREF="datatype-datetime.html" >Section 8.5</A > for the equivalent type in the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server. </P ><P > The following functions can be used to work with the timestamp type: <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="PGTYPESTIMESTAMPFROMASC" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_from_asc</CODE ></DT ><DD ><P > Parse a timestamp from its textual representation into a timestamp variable. </P><PRE CLASS="SYNOPSIS" >timestamp PGTYPEStimestamp_from_asc(char *str, char **endptr);</PRE ><P> The function receives the string to parse (<TT CLASS="LITERAL" >str</TT >) and a pointer to a C char* (<TT CLASS="LITERAL" >endptr</TT >). At the moment ECPG always parses the complete string and so it currently does not support to store the address of the first invalid character in <TT CLASS="LITERAL" >*endptr</TT >. You can safely set <TT CLASS="LITERAL" >endptr</TT > to NULL. </P ><P > The function returns the parsed timestamp on success. On error, <TT CLASS="LITERAL" >PGTYPESInvalidTimestamp</TT > is returned and <TT CLASS="VARNAME" >errno</TT > is set to <TT CLASS="LITERAL" >PGTYPES_TS_BAD_TIMESTAMP</TT >. See <A HREF="ecpg-pgtypes.html#PGTYPESINVALIDTIMESTAMP" ><I CLASS="TERM" ><TT CLASS="LITERAL" >PGTYPESInvalidTimestamp</TT ></I ></A > for important notes on this value. </P ><P > In general, the input string can contain any combination of an allowed date specification, a whitespace character and an allowed time specification. Note that time zones are not supported by ECPG. It can parse them but does not apply any calculation as the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server does for example. Timezone specifiers are silently discarded. </P ><P > <A HREF="ecpg-pgtypes.html#ECPG-PGTYPESTIMESTAMP-FROM-ASC-EXAMPLE-TABLE" >Table 33-5</A > contains a few examples for input strings. </P ><DIV CLASS="TABLE" ><A NAME="ECPG-PGTYPESTIMESTAMP-FROM-ASC-EXAMPLE-TABLE" ></A ><P ><B >Table 33-5. Valid Input Formats for <CODE CLASS="FUNCTION" >PGTYPEStimestamp_from_asc</CODE ></B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Input</TH ><TH >Result</TH ></TR ></THEAD ><TBODY ><TR ><TD ><TT CLASS="LITERAL" >1999-01-08 04:05:06</TT ></TD ><TD ><TT CLASS="LITERAL" >1999-01-08 04:05:06</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >January 8 04:05:06 1999 PST</TT ></TD ><TD ><TT CLASS="LITERAL" >1999-01-08 04:05:06</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >1999-Jan-08 04:05:06.789-8</TT ></TD ><TD ><TT CLASS="LITERAL" >1999-01-08 04:05:06.789 (time zone specifier ignored)</TT ></TD ></TR ><TR ><TD ><TT CLASS="LITERAL" >J2451187 04:05-08:00</TT ></TD ><TD ><TT CLASS="LITERAL" >1999-01-08 04:05:00 (time zone specifier ignored)</TT ></TD ></TR ></TBODY ></TABLE ></DIV ></DD ><DT ><A NAME="PGTYPESTIMESTAMPTOASC" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_to_asc</CODE ></DT ><DD ><P > Converts a date to a C char* string. </P><PRE CLASS="SYNOPSIS" >char *PGTYPEStimestamp_to_asc(timestamp tstamp);</PRE ><P> The function receives the timestamp <TT CLASS="LITERAL" >tstamp</TT > as its only argument and returns an allocated string that contains the textual representation of the timestamp. </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPCURRENT" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_current</CODE ></DT ><DD ><P > Retrieve the current timestamp. </P><PRE CLASS="SYNOPSIS" >void PGTYPEStimestamp_current(timestamp *ts);</PRE ><P> The function retrieves the current timestamp and saves it into the timestamp variable that <TT CLASS="LITERAL" >ts</TT > points to. </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPFMTASC" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_fmt_asc</CODE ></DT ><DD ><P > Convert a timestamp variable to a C char* using a format mask. </P><PRE CLASS="SYNOPSIS" >int PGTYPEStimestamp_fmt_asc(timestamp *ts, char *output, int str_len, char *fmtstr);</PRE ><P> The function receives a pointer to the timestamp to convert as its first argument (<TT CLASS="LITERAL" >ts</TT >), a pointer to the output buffer (<TT CLASS="LITERAL" >output</TT >), the maximal length that has been allocated for the output buffer (<TT CLASS="LITERAL" >str_len</TT >) and the format mask to use for the conversion (<TT CLASS="LITERAL" >fmtstr</TT >). </P ><P > Upon success, the function returns 0 and a negative value if an error occurred. </P ><P > You can use the following format specifiers for the format mask. The format specifiers are the same ones that are used in the <CODE CLASS="FUNCTION" >strftime</CODE > function in <SPAN CLASS="PRODUCTNAME" >libc</SPAN >. Any non-format specifier will be copied into the output buffer. <P ></P ></P><UL ><LI ><P > <TT CLASS="LITERAL" >%A</TT > - is replaced by national representation of the full weekday name. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%a</TT > - is replaced by national representation of the abbreviated weekday name. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%B</TT > - is replaced by national representation of the full month name. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%b</TT > - is replaced by national representation of the abbreviated month name. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%C</TT > - is replaced by (year / 100) as decimal number; single digits are preceded by a zero. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%c</TT > - is replaced by national representation of time and date. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%D</TT > - is equivalent to <TT CLASS="LITERAL" >%m/%d/%y</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%d</TT > - is replaced by the day of the month as a decimal number (01-31). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%E*</TT > <TT CLASS="LITERAL" >%O*</TT > - POSIX locale extensions. The sequences <TT CLASS="LITERAL" >%Ec</TT > <TT CLASS="LITERAL" >%EC</TT > <TT CLASS="LITERAL" >%Ex</TT > <TT CLASS="LITERAL" >%EX</TT > <TT CLASS="LITERAL" >%Ey</TT > <TT CLASS="LITERAL" >%EY</TT > <TT CLASS="LITERAL" >%Od</TT > <TT CLASS="LITERAL" >%Oe</TT > <TT CLASS="LITERAL" >%OH</TT > <TT CLASS="LITERAL" >%OI</TT > <TT CLASS="LITERAL" >%Om</TT > <TT CLASS="LITERAL" >%OM</TT > <TT CLASS="LITERAL" >%OS</TT > <TT CLASS="LITERAL" >%Ou</TT > <TT CLASS="LITERAL" >%OU</TT > <TT CLASS="LITERAL" >%OV</TT > <TT CLASS="LITERAL" >%Ow</TT > <TT CLASS="LITERAL" >%OW</TT > <TT CLASS="LITERAL" >%Oy</TT > are supposed to provide alternative representations. </P ><P > Additionally <TT CLASS="LITERAL" >%OB</TT > implemented to represent alternative months names (used standalone, without day mentioned). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%e</TT > - is replaced by the day of month as a decimal number (1-31); single digits are preceded by a blank. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%F</TT > - is equivalent to <TT CLASS="LITERAL" >%Y-%m-%d</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%G</TT > - is replaced by a year as a decimal number with century. This year is the one that contains the greater part of the week (Monday as the first day of the week). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%g</TT > - is replaced by the same year as in <TT CLASS="LITERAL" >%G</TT >, but as a decimal number without century (00-99). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%H</TT > - is replaced by the hour (24-hour clock) as a decimal number (00-23). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%h</TT > - the same as <TT CLASS="LITERAL" >%b</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%I</TT > - is replaced by the hour (12-hour clock) as a decimal number (01-12). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%j</TT > - is replaced by the day of the year as a decimal number (001-366). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%k</TT > - is replaced by the hour (24-hour clock) as a decimal number (0-23); single digits are preceded by a blank. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%l</TT > - is replaced by the hour (12-hour clock) as a decimal number (1-12); single digits are preceded by a blank. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%M</TT > - is replaced by the minute as a decimal number (00-59). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%m</TT > - is replaced by the month as a decimal number (01-12). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%n</TT > - is replaced by a newline. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%O*</TT > - the same as <TT CLASS="LITERAL" >%E*</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%p</TT > - is replaced by national representation of either <SPAN CLASS="QUOTE" >"ante meridiem"</SPAN > or <SPAN CLASS="QUOTE" >"post meridiem"</SPAN > as appropriate. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%R</TT > - is equivalent to <TT CLASS="LITERAL" >%H:%M</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%r</TT > - is equivalent to <TT CLASS="LITERAL" >%I:%M:%S %p</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%S</TT > - is replaced by the second as a decimal number (00-60). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%s</TT > - is replaced by the number of seconds since the Epoch, UTC. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%T</TT > - is equivalent to <TT CLASS="LITERAL" >%H:%M:%S</TT > </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%t</TT > - is replaced by a tab. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%U</TT > - is replaced by the week number of the year (Sunday as the first day of the week) as a decimal number (00-53). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%u</TT > - is replaced by the weekday (Monday as the first day of the week) as a decimal number (1-7). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%V</TT > - is replaced by the week number of the year (Monday as the first day of the week) as a decimal number (01-53). If the week containing January 1 has four or more days in the new year, then it is week 1; otherwise it is the last week of the previous year, and the next week is week 1. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%v</TT > - is equivalent to <TT CLASS="LITERAL" >%e-%b-%Y</TT >. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%W</TT > - is replaced by the week number of the year (Monday as the first day of the week) as a decimal number (00-53). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%w</TT > - is replaced by the weekday (Sunday as the first day of the week) as a decimal number (0-6). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%X</TT > - is replaced by national representation of the time. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%x</TT > - is replaced by national representation of the date. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%Y</TT > - is replaced by the year with century as a decimal number. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%y</TT > - is replaced by the year without century as a decimal number (00-99). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%Z</TT > - is replaced by the time zone name. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%z</TT > - is replaced by the time zone offset from UTC; a leading plus sign stands for east of UTC, a minus sign for west of UTC, hours and minutes follow with two digits each and no delimiter between them (common form for RFC 822 date headers). </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%+</TT > - is replaced by national representation of the date and time. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%-*</TT > - GNU libc extension. Do not do any padding when performing numerical outputs. </P ></LI ><LI ><P > $_* - GNU libc extension. Explicitly specify space for padding. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%0*</TT > - GNU libc extension. Explicitly specify zero for padding. </P ></LI ><LI ><P > <TT CLASS="LITERAL" >%%</TT > - is replaced by <TT CLASS="LITERAL" >%</TT >. </P ></LI ></UL ><P> </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPSUB" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_sub</CODE ></DT ><DD ><P > Subtract one timestamp from another one and save the result in a variable of type interval. </P><PRE CLASS="SYNOPSIS" >int PGTYPEStimestamp_sub(timestamp *ts1, timestamp *ts2, interval *iv);</PRE ><P> The function will subtract the timestamp variable that <TT CLASS="LITERAL" >ts2</TT > points to from the timestamp variable that <TT CLASS="LITERAL" >ts1</TT > points to and will store the result in the interval variable that <TT CLASS="LITERAL" >iv</TT > points to. </P ><P > Upon success, the function returns 0 and a negative value if an error occurred. </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPDEFMTASC" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_defmt_asc</CODE ></DT ><DD ><P > Parse a timestamp value from its textual representation using a formatting mask. </P><PRE CLASS="SYNOPSIS" >int PGTYPEStimestamp_defmt_asc(char *str, char *fmt, timestamp *d);</PRE ><P> The function receives the textual representation of a timestamp in the variable <TT CLASS="LITERAL" >str</TT > as well as the formatting mask to use in the variable <TT CLASS="LITERAL" >fmt</TT >. The result will be stored in the variable that <TT CLASS="LITERAL" >d</TT > points to. </P ><P > If the formatting mask <TT CLASS="LITERAL" >fmt</TT > is NULL, the function will fall back to the default formatting mask which is <TT CLASS="LITERAL" >%Y-%m-%d %H:%M:%S</TT >. </P ><P > This is the reverse function to <A HREF="ecpg-pgtypes.html#PGTYPESTIMESTAMPFMTASC" ><I CLASS="TERM" ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_fmt_asc</CODE ></I ></A >. See the documentation there in order to find out about the possible formatting mask entries. </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPADDINTERVAL" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_add_interval</CODE ></DT ><DD ><P > Add an interval variable to a timestamp variable. </P><PRE CLASS="SYNOPSIS" >int PGTYPEStimestamp_add_interval(timestamp *tin, interval *span, timestamp *tout);</PRE ><P> The function receives a pointer to a timestamp variable <TT CLASS="LITERAL" >tin</TT > and a pointer to an interval variable <TT CLASS="LITERAL" >span</TT >. It adds the interval to the timestamp and saves the resulting timestamp in the variable that <TT CLASS="LITERAL" >tout</TT > points to. </P ><P > Upon success, the function returns 0 and a negative value if an error occurred. </P ></DD ><DT ><A NAME="PGTYPESTIMESTAMPSUBINTERVAL" ></A ><CODE CLASS="FUNCTION" >PGTYPEStimestamp_sub_interval</CODE ></DT ><DD ><P > Subtract an interval variable from a timestamp variable. </P><PRE CLASS="SYNOPSIS" >int PGTYPEStimestamp_sub_interval(timestamp *tin, interval *span, timestamp *tout);</PRE ><P> The function subtracts the interval variable that <TT CLASS="LITERAL" >span</TT > points to from the timestamp variable that <TT CLASS="LITERAL" >tin</TT > points to and saves the result into the variable that <TT CLASS="LITERAL" >tout</TT > points to. </P ><P > Upon success, the function returns 0 and a negative value if an error occurred. </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-INTERVAL" >33.6.4. The interval Type</A ></H2 ><P > The interval type in C enables your programs to deal with data of the SQL type interval. See <A HREF="datatype-datetime.html" >Section 8.5</A > for the equivalent type in the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > server. </P ><P > The following functions can be used to work with the interval type: <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="PGTYPESINTERVALNEW" ></A ><CODE CLASS="FUNCTION" >PGTYPESinterval_new</CODE ></DT ><DD ><P > Return a pointer to a newly allocated interval variable. </P><PRE CLASS="SYNOPSIS" >interval *PGTYPESinterval_new(void);</PRE ><P> </P ></DD ><DT ><A NAME="PGTYPESINTERVALFREE" ></A ><CODE CLASS="FUNCTION" >PGTYPESinterval_free</CODE ></DT ><DD ><P > Release the memory of a previously allocated interval variable. </P><PRE CLASS="SYNOPSIS" >void PGTYPESinterval_new(interval *intvl);</PRE ><P> </P ></DD ><DT ><A NAME="PGTYPESINTERVALFROMASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESinterval_from_asc</CODE ></DT ><DD ><P > Parse an interval from its textual representation. </P><PRE CLASS="SYNOPSIS" >interval *PGTYPESinterval_from_asc(char *str, char **endptr);</PRE ><P> The function parses the input string <TT CLASS="LITERAL" >str</TT > and returns a pointer to an allocated interval variable. At the moment ECPG always parses the complete string and so it currently does not support to store the address of the first invalid character in <TT CLASS="LITERAL" >*endptr</TT >. You can safely set <TT CLASS="LITERAL" >endptr</TT > to NULL. </P ></DD ><DT ><A NAME="PGTYPESINTERVALTOASC" ></A ><CODE CLASS="FUNCTION" >PGTYPESinterval_to_asc</CODE ></DT ><DD ><P > Convert a variable of type interval to its textual representation. </P><PRE CLASS="SYNOPSIS" >char *PGTYPESinterval_to_asc(interval *span);</PRE ><P> The function converts the interval variable that <TT CLASS="LITERAL" >span</TT > points to into a C char*. The output looks like this example: <TT CLASS="LITERAL" >@ 1 day 12 hours 59 mins 10 secs</TT >. </P ></DD ><DT ><A NAME="PGTYPESINTERVALCOPY" ></A ><CODE CLASS="FUNCTION" >PGTYPESinterval_copy</CODE ></DT ><DD ><P > Copy a variable of type interval. </P><PRE CLASS="SYNOPSIS" >int PGTYPESinterval_copy(interval *intvlsrc, interval *intvldest);</PRE ><P> The function copies the interval variable that <TT CLASS="LITERAL" >intvlsrc</TT > points to into the variable that <TT CLASS="LITERAL" >intvldest</TT > points to. Note that you need to allocate the memory for the destination variable before. </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-DECIMAL" >33.6.5. The decimal Type</A ></H2 ><P > The decimal type is similar to the numeric type. However it is limited to a maximum precision of 30 significant digits. In contrast to the numeric type which can be created on the heap only, the decimal type can be created either on the stack or on the heap (by means of the functions <CODE CLASS="FUNCTION" >PGTYPESdecimal_new</CODE > and <CODE CLASS="FUNCTION" >PGTYPESdecimal_free</CODE >). There are a lot of other functions that deal with the decimal type in the <SPAN CLASS="PRODUCTNAME" >Informix</SPAN > compatibility mode described in <A HREF="ecpg-informix-compat.html" >Section 33.15</A >. </P ><P > The following functions can be used to work with the decimal type and are not only contained in the <TT CLASS="LITERAL" >libcompat</TT > library. <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><CODE CLASS="FUNCTION" >PGTYPESdecimal_new</CODE ></DT ><DD ><P > Request a pointer to a newly allocated decimal variable. </P><PRE CLASS="SYNOPSIS" >decimal *PGTYPESdecimal_new(void);</PRE ><P> </P ></DD ><DT ><CODE CLASS="FUNCTION" >PGTYPESdecimal_free</CODE ></DT ><DD ><P > Free a decimal type, release all of its memory. </P><PRE CLASS="SYNOPSIS" >void PGTYPESdecimal_free(decimal *var);</PRE ><P> </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-ERRNO" >33.6.6. errno Values of pgtypeslib</A ></H2 ><P > <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="LITERAL" >PGTYPES_NUM_BAD_NUMERIC</TT ></DT ><DD ><P > An argument should contain a numeric variable (or point to a numeric variable) but in fact its in-memory representation was invalid. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_NUM_OVERFLOW</TT ></DT ><DD ><P > An overflow occurred. Since the numeric type can deal with almost arbitrary precision, converting a numeric variable into other types might cause overflow. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_NUM_UNDERFLOW</TT ></DT ><DD ><P > An underflow occurred. Since the numeric type can deal with almost arbitrary precision, converting a numeric variable into other types might cause underflow. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_NUM_DIVIDE_ZERO</TT ></DT ><DD ><P > A division by zero has been attempted. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_BAD_DATE</TT ></DT ><DD ><P > An invalid date string was passed to the <CODE CLASS="FUNCTION" >PGTYPESdate_from_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_ERR_EARGS</TT ></DT ><DD ><P > Invalid arguments were passed to the <CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_ERR_ENOSHORTDATE</TT ></DT ><DD ><P > An invalid token in the input string was found by the <CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_INTVL_BAD_INTERVAL</TT ></DT ><DD ><P > An invalid interval string was passed to the <CODE CLASS="FUNCTION" >PGTYPESinterval_from_asc</CODE > function, or an invalid interval value was passed to the <CODE CLASS="FUNCTION" >PGTYPESinterval_to_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_ERR_ENOTDMY</TT ></DT ><DD ><P > There was a mismatch in the day/month/year assignment in the <CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_BAD_DAY</TT ></DT ><DD ><P > An invalid day of the month value was found by the <CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_DATE_BAD_MONTH</TT ></DT ><DD ><P > An invalid month value was found by the <CODE CLASS="FUNCTION" >PGTYPESdate_defmt_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_TS_BAD_TIMESTAMP</TT ></DT ><DD ><P > An invalid timestamp string pass passed to the <CODE CLASS="FUNCTION" >PGTYPEStimestamp_from_asc</CODE > function, or an invalid timestamp value was passed to the <CODE CLASS="FUNCTION" >PGTYPEStimestamp_to_asc</CODE > function. </P ></DD ><DT ><TT CLASS="LITERAL" >PGTYPES_TS_ERR_EINFTIME</TT ></DT ><DD ><P > An infinite timestamp value was encountered in a context that cannot handle it. </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="ECPG-PGTYPES-CONSTANTS" >33.6.7. Special Constants of pgtypeslib</A ></H2 ><P > <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="PGTYPESINVALIDTIMESTAMP" ></A ><TT CLASS="LITERAL" >PGTYPESInvalidTimestamp</TT ></DT ><DD ><P > A value of type timestamp representing an invalid time stamp. This is returned by the function <CODE CLASS="FUNCTION" >PGTYPEStimestamp_from_asc</CODE > on parse error. Note that due to the internal representation of the <TT CLASS="TYPE" >timestamp</TT > data type, <TT CLASS="LITERAL" >PGTYPESInvalidTimestamp</TT > is also a valid timestamp at the same time. It is set to <TT CLASS="LITERAL" >1899-12-31 23:59:59</TT >. In order to detect errors, make sure that your application does not only test for <TT CLASS="LITERAL" >PGTYPESInvalidTimestamp</TT > but also for <TT CLASS="LITERAL" >errno != 0</TT > after each call to <CODE CLASS="FUNCTION" >PGTYPEStimestamp_from_asc</CODE >. </P ></DD ></DL ></DIV ><P> </P ></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="ecpg-dynamic.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="ecpg-descriptors.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Dynamic SQL</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ecpg.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Using Descriptor Areas</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
Close