Extensions
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 AvailabilityPackage PatternDependencies
EL
PGDG
1.4.0
18
17
16
15
14
13
timestamp9_$v*-
Debian
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
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
d12.aarch64
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u22.aarch64
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u24.x86_64
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
u24.aarch64
MISS
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PIGSTY 1.4.0
PackageVersionOSORGSIZEFile URL
timestamp9_181.4.0el8.x86_64pgdg17.6 KiBtimestamp9_18-1.4.0-3PGDG.rhel8.x86_64.rpm
timestamp9_181.4.0el8.aarch64pgdg17.4 KiBtimestamp9_18-1.4.0-3PGDG.rhel8.aarch64.rpm
timestamp9_181.4.0el9.x86_64pgdg17.6 KiBtimestamp9_18-1.4.0-3PGDG.rhel9.x86_64.rpm
timestamp9_181.4.0el9.aarch64pgdg17.3 KiBtimestamp9_18-1.4.0-3PGDG.rhel9.aarch64.rpm
timestamp9_181.4.0el10.x86_64pgdg18.2 KiBtimestamp9_18-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_181.4.0el10.aarch64pgdg18.2 KiBtimestamp9_18-1.4.0-3PGDG.rhel10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
timestamp9_171.4.0el8.x86_64pgdg17.5 KiBtimestamp9_17-1.4.0-2PGDG.rhel8.x86_64.rpm
timestamp9_171.4.0el8.aarch64pgdg17.3 KiBtimestamp9_17-1.4.0-2PGDG.rhel8.aarch64.rpm
timestamp9_171.4.0el9.x86_64pgdg17.7 KiBtimestamp9_17-1.4.0-2PGDG.rhel9.x86_64.rpm
timestamp9_171.4.0el9.aarch64pgdg17.6 KiBtimestamp9_17-1.4.0-2PGDG.rhel9.aarch64.rpm
timestamp9_171.4.0el10.x86_64pgdg18.2 KiBtimestamp9_17-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_171.4.0el10.aarch64pgdg18.2 KiBtimestamp9_17-1.4.0-3PGDG.rhel10.aarch64.rpm
postgresql-17-timestamp91.4.0d12.x86_64pigsty8.4 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-timestamp91.4.0d12.aarch64pigsty8.5 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-timestamp91.4.0u22.x86_64pigsty9.1 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~jammy_amd64.deb
postgresql-17-timestamp91.4.0u22.aarch64pigsty9.1 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~jammy_arm64.deb
postgresql-17-timestamp91.4.0u24.x86_64pigsty9.1 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~noble_amd64.deb
postgresql-17-timestamp91.4.0u24.aarch64pigsty9.2 KiBpostgresql-17-timestamp9_1.4.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
timestamp9_161.4.0el8.x86_64pgdg17.5 KiBtimestamp9_16-1.4.0-2PGDG.rhel8.x86_64.rpm
timestamp9_161.4.0el8.aarch64pgdg17.3 KiBtimestamp9_16-1.4.0-2PGDG.rhel8.aarch64.rpm
timestamp9_161.4.0el9.x86_64pgdg17.6 KiBtimestamp9_16-1.4.0-2PGDG.rhel9.x86_64.rpm
timestamp9_161.4.0el9.aarch64pgdg17.2 KiBtimestamp9_16-1.4.0-2PGDG.rhel9.aarch64.rpm
timestamp9_161.4.0el10.x86_64pgdg18.2 KiBtimestamp9_16-1.4.0-3PGDG.rhel10.x86_64.rpm
timestamp9_161.4.0el10.aarch64pgdg18.2 KiBtimestamp9_16-1.4.0-3PGDG.rhel10.aarch64.rpm
postgresql-16-timestamp91.4.0d12.x86_64pigsty8.4 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-timestamp91.4.0d12.aarch64pigsty8.6 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-timestamp91.4.0u22.x86_64pigsty9.1 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~jammy_amd64.deb
postgresql-16-timestamp91.4.0u22.aarch64pigsty9.1 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~jammy_arm64.deb
postgresql-16-timestamp91.4.0u24.x86_64pigsty9.1 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~noble_amd64.deb
postgresql-16-timestamp91.4.0u24.aarch64pigsty9.2 KiBpostgresql-16-timestamp9_1.4.0-1PIGSTY~noble_arm64.deb
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.6 KiBpostgresql-15-timestamp9_1.4.0-1PIGSTY~bookworm_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.1 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.6 KiBpostgresql-14-timestamp9_1.4.0-1PIGSTY~bookworm_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.1 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.6 KiBpostgresql-13-timestamp9_1.4.0-1PIGSTY~bookworm_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.1 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 get timestamp9; # get timestamp9 source code
pig build dep timestamp9; # install build dependencies
pig build pkg timestamp9; # build extension rpm or deb
pig build ext timestamp9; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install timestamp9; # install by extension name, for the current active PG version
pig ext install timestamp9; # install via package alias, for the active PG version
pig ext install timestamp9 -v 18;   # install for PG 18
pig ext install timestamp9 -v 17;   # install for PG 17
pig ext install timestamp9 -v 16;   # install for PG 16
pig ext install timestamp9 -v 15;   # install for PG 15
pig ext install timestamp9 -v 14;   # install for PG 14
pig ext install timestamp9 -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION timestamp9;
Last updated on
pg_rrulechkpass