Extensions
timestamp9

timestamp9

timestamp9 : timestamp nanosecond resolution

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
3890
timestamp9
timestamp9
1.4.0
TYPE
MIT
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
MIXED
1.4.0
18
17
16
15
14
13
timestamp9-
RPM
PGDG
1.4.0
18
17
16
15
14
13
timestamp9_$v*-
DEB
PIGSTY
1.4.0
18
17
16
15
14
13
postgresql-$v-timestamp9-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.3.0
PGDG 1.3.0
PGDG 1.3.0
el8.aarch64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.3.0
PGDG 1.3.0
PGDG 1.3.0
el9.x86_64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.3.0
PGDG 1.3.0
PGDG 1.3.0
el9.aarch64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.3.0
PGDG 1.3.0
PGDG 1.3.0
el10.x86_64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
el10.aarch64
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
PGDG 1.4.0
d12.x86_64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
d12.aarch64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
d13.x86_64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
d13.aarch64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u22.x86_64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u22.aarch64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u24.x86_64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u24.aarch64
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PackageVersionOSORGSIZEFile URL
timestamp9_151.3.0el8.x86_64pgdg17.3 KiBtimestamp9_15-1.3.0-1.rhel8.x86_64.rpm
timestamp9_151.1.0el8.x86_64pgdg16.4 KiBtimestamp9_15-1.1.0-1.rhel8.x86_64.rpm
timestamp9_151.3.0el8.aarch64pgdg17.1 KiBtimestamp9_15-1.3.0-1.rhel8.aarch64.rpm
timestamp9_151.1.0el8.aarch64pgdg16.3 KiBtimestamp9_15-1.1.0-1.rhel8.aarch64.rpm
timestamp9_151.3.0el9.x86_64pgdg17.4 KiBtimestamp9_15-1.3.0-1.rhel9.x86_64.rpm
timestamp9_151.1.0el9.x86_64pgdg16.8 KiBtimestamp9_15-1.1.0-1.rhel9.x86_64.rpm
timestamp9_151.3.0el9.aarch64pgdg17.0 KiBtimestamp9_15-1.3.0-1.rhel9.aarch64.rpm
timestamp9_151.1.0el9.aarch64pgdg16.6 KiBtimestamp9_15-1.1.0-1.rhel9.aarch64.rpm
timestamp9_151.4.0el10.x86_64pgdg18.3 KiBtimestamp9_15-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_151.4.0el10.aarch64pgdg18.3 KiBtimestamp9_15-1.4.0-3PGDG.rhel10.aarch64.rpm
postgresql-15-timestamp91.4.0d12.x86_64pigsty8.5 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-timestamp91.4.0d12.aarch64pigsty8.7 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-timestamp91.4.0d13.x86_64pigsty8.6 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~trixie_amd64.deb
postgresql-15-timestamp91.4.0d13.aarch64pigsty8.6 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~trixie_arm64.deb
postgresql-15-timestamp91.4.0u22.x86_64pigsty9.2 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~jammy_amd64.deb
postgresql-15-timestamp91.4.0u22.aarch64pigsty9.2 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~jammy_arm64.deb
postgresql-15-timestamp91.4.0u24.x86_64pigsty9.2 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~noble_amd64.deb
postgresql-15-timestamp91.4.0u24.aarch64pigsty9.3 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
timestamp9_141.3.0el8.x86_64pgdg17.3 KiBtimestamp9_14-1.3.0-1.rhel8.x86_64.rpm
timestamp9_141.1.0el8.x86_64pgdg16.4 KiBtimestamp9_14-1.1.0-1.rhel8.x86_64.rpm
timestamp9_141.3.0el8.aarch64pgdg17.1 KiBtimestamp9_14-1.3.0-1.rhel8.aarch64.rpm
timestamp9_141.1.0el8.aarch64pgdg16.3 KiBtimestamp9_14-1.1.0-1.rhel8.aarch64.rpm
timestamp9_141.3.0el9.x86_64pgdg17.4 KiBtimestamp9_14-1.3.0-1.rhel9.x86_64.rpm
timestamp9_141.1.0el9.x86_64pgdg16.7 KiBtimestamp9_14-1.1.0-1.rhel9.x86_64.rpm
timestamp9_141.3.0el9.aarch64pgdg16.9 KiBtimestamp9_14-1.3.0-1.rhel9.aarch64.rpm
timestamp9_141.1.0el9.aarch64pgdg16.5 KiBtimestamp9_14-1.1.0-1.rhel9.aarch64.rpm
timestamp9_141.4.0el10.x86_64pgdg18.3 KiBtimestamp9_14-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_141.4.0el10.aarch64pgdg18.3 KiBtimestamp9_14-1.4.0-3PGDG.rhel10.aarch64.rpm
postgresql-14-timestamp91.4.0d12.x86_64pigsty8.5 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-timestamp91.4.0d12.aarch64pigsty8.7 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-timestamp91.4.0d13.x86_64pigsty8.6 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~trixie_amd64.deb
postgresql-14-timestamp91.4.0d13.aarch64pigsty8.6 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~trixie_arm64.deb
postgresql-14-timestamp91.4.0u22.x86_64pigsty9.2 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~jammy_amd64.deb
postgresql-14-timestamp91.4.0u22.aarch64pigsty9.2 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~jammy_arm64.deb
postgresql-14-timestamp91.4.0u24.x86_64pigsty9.2 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~noble_amd64.deb
postgresql-14-timestamp91.4.0u24.aarch64pigsty9.3 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
timestamp9_131.3.0el8.x86_64pgdg17.2 KiBtimestamp9_13-1.3.0-1.rhel8.x86_64.rpm
timestamp9_131.1.0el8.x86_64pgdg16.2 KiBtimestamp9_13-1.1.0-1.rhel8.x86_64.rpm
timestamp9_131.3.0el8.aarch64pgdg17.1 KiBtimestamp9_13-1.3.0-1.rhel8.aarch64.rpm
timestamp9_131.1.0el8.aarch64pgdg16.3 KiBtimestamp9_13-1.1.0-1.rhel8.aarch64.rpm
timestamp9_131.3.0el9.x86_64pgdg17.4 KiBtimestamp9_13-1.3.0-1.rhel9.x86_64.rpm
timestamp9_131.1.0el9.x86_64pgdg16.7 KiBtimestamp9_13-1.1.0-1.rhel9.x86_64.rpm
timestamp9_131.3.0el9.aarch64pgdg17.0 KiBtimestamp9_13-1.3.0-1.rhel9.aarch64.rpm
timestamp9_131.1.0el9.aarch64pgdg16.5 KiBtimestamp9_13-1.1.0-1.rhel9.aarch64.rpm
timestamp9_131.4.0el10.x86_64pgdg18.3 KiBtimestamp9_13-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_131.4.0el10.aarch64pgdg18.3 KiBtimestamp9_13-1.4.0-3PGDG.rhel10.aarch64.rpm
postgresql-13-timestamp91.4.0d12.x86_64pigsty8.5 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-timestamp91.4.0d12.aarch64pigsty8.7 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-timestamp91.4.0d13.x86_64pigsty8.6 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~trixie_amd64.deb
postgresql-13-timestamp91.4.0d13.aarch64pigsty8.6 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~trixie_arm64.deb
postgresql-13-timestamp91.4.0u22.x86_64pigsty9.2 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~jammy_amd64.deb
postgresql-13-timestamp91.4.0u22.aarch64pigsty9.2 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~jammy_arm64.deb
postgresql-13-timestamp91.4.0u24.x86_64pigsty9.2 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~noble_amd64.deb
postgresql-13-timestamp91.4.0u24.aarch64pigsty9.2 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/optiver/timestamp9
Source Tarball
timestamp9-timestamp9-1.4.0.tar.gz
pig build pkg timestamp9;		# build spec not ready

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install timestamp9;		# install via package name, for the active PG version

pig install timestamp9 -v 18;   # install for PG 18
pig install timestamp9 -v 17;   # install for PG 17
pig install timestamp9 -v 16;   # install for PG 16
pig install timestamp9 -v 15;   # install for PG 15
pig install timestamp9 -v 14;   # install for PG 14
pig install timestamp9 -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION timestamp9;
Last updated on
pg_rrulechkpass