timestamp9

纳秒分辨率时间戳

概览

扩展包名	版本	分类	许可证	语言
`timestamp9`	`1.4.0`	TYPE	MIT	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
3900	`timestamp9`	否	是	否	是	否	否	-

相关扩展	`pgcalendar` `pg_rrule` `pg_duration` `pg_bikram_sambat` `pg_when` `cron_utils` `pg_cron`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	MIXED	`1.4.0`	1817161514	`timestamp9`	-
RPM	PGDG	`1.4.0`	1817161514	`timestamp9_$v`	-
DEB	PIGSTY	`1.4.0`	1817161514	`postgresql-$v-timestamp9`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 1.4.0 el8.x86_64.pg18 : timestamp9_18 timestamp9_18-1.4.0-3PGDG.rhel8.x86_64.rpm PGDG · 1.4.0 · 17.6KiB	PGDG 1.4.0 el8.x86_64.pg17 : timestamp9_17 timestamp9_17-1.4.0-2PGDG.rhel8.x86_64.rpm PGDG · 1.4.0 · 17.5KiB	PGDG 1.4.0 el8.x86_64.pg16 : timestamp9_16 timestamp9_16-1.4.0-2PGDG.rhel8.x86_64.rpm PGDG · 1.4.0 · 17.5KiB	PGDG 1.3.0 el8.x86_64.pg15 : timestamp9_15 timestamp9_15-1.3.0-1.rhel8.x86_64.rpm PGDG · 1.3.0 · 17.3KiB timestamp9_15-1.1.0-1.rhel8.x86_64.rpm PGDG · 1.1.0 · 16.4KiB	PGDG 1.3.0 el8.x86_64.pg14 : timestamp9_14 timestamp9_14-1.3.0-1.rhel8.x86_64.rpm PGDG · 1.3.0 · 17.3KiB timestamp9_14-1.1.0-1.rhel8.x86_64.rpm PGDG · 1.1.0 · 16.4KiB
el8.aarch64	PGDG 1.4.0 el8.aarch64.pg18 : timestamp9_18 timestamp9_18-1.4.0-3PGDG.rhel8.aarch64.rpm PGDG · 1.4.0 · 17.4KiB	PGDG 1.4.0 el8.aarch64.pg17 : timestamp9_17 timestamp9_17-1.4.0-2PGDG.rhel8.aarch64.rpm PGDG · 1.4.0 · 17.3KiB	PGDG 1.4.0 el8.aarch64.pg16 : timestamp9_16 timestamp9_16-1.4.0-2PGDG.rhel8.aarch64.rpm PGDG · 1.4.0 · 17.3KiB	PGDG 1.3.0 el8.aarch64.pg15 : timestamp9_15 timestamp9_15-1.3.0-1.rhel8.aarch64.rpm PGDG · 1.3.0 · 17.1KiB timestamp9_15-1.1.0-1.rhel8.aarch64.rpm PGDG · 1.1.0 · 16.3KiB	PGDG 1.3.0 el8.aarch64.pg14 : timestamp9_14 timestamp9_14-1.3.0-1.rhel8.aarch64.rpm PGDG · 1.3.0 · 17.1KiB timestamp9_14-1.1.0-1.rhel8.aarch64.rpm PGDG · 1.1.0 · 16.3KiB
el9.x86_64	PGDG 1.4.0 el9.x86_64.pg18 : timestamp9_18 timestamp9_18-1.4.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.0 · 17.3KiB timestamp9_18-1.4.0-3PGDG.rhel9.x86_64.rpm PGDG · 1.4.0 · 17.6KiB	PGDG 1.4.0 el9.x86_64.pg17 : timestamp9_17 timestamp9_17-1.4.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.0 · 17.3KiB timestamp9_17-1.4.0-2PGDG.rhel9.x86_64.rpm PGDG · 1.4.0 · 17.7KiB	PGDG 1.4.0 el9.x86_64.pg16 : timestamp9_16 timestamp9_16-1.4.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.0 · 17.3KiB timestamp9_16-1.4.0-2PGDG.rhel9.x86_64.rpm PGDG · 1.4.0 · 17.6KiB	PGDG 1.4.0 el9.x86_64.pg15 : timestamp9_15 timestamp9_15-1.4.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.0 · 17.5KiB timestamp9_15-1.3.0-1.rhel9.x86_64.rpm PGDG · 1.3.0 · 17.4KiB timestamp9_15-1.1.0-1.rhel9.x86_64.rpm PGDG · 1.1.0 · 16.8KiB	PGDG 1.4.0 el9.x86_64.pg14 : timestamp9_14 timestamp9_14-1.4.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.4.0 · 17.5KiB timestamp9_14-1.3.0-1.rhel9.x86_64.rpm PGDG · 1.3.0 · 17.4KiB timestamp9_14-1.1.0-1.rhel9.x86_64.rpm PGDG · 1.1.0 · 16.7KiB
el9.aarch64	PGDG 1.4.0 el9.aarch64.pg18 : timestamp9_18 timestamp9_18-1.4.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.0 · 17.2KiB timestamp9_18-1.4.0-3PGDG.rhel9.aarch64.rpm PGDG · 1.4.0 · 17.3KiB	PGDG 1.4.0 el9.aarch64.pg17 : timestamp9_17 timestamp9_17-1.4.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.0 · 17.2KiB timestamp9_17-1.4.0-2PGDG.rhel9.aarch64.rpm PGDG · 1.4.0 · 17.6KiB	PGDG 1.4.0 el9.aarch64.pg16 : timestamp9_16 timestamp9_16-1.4.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.0 · 17.2KiB timestamp9_16-1.4.0-2PGDG.rhel9.aarch64.rpm PGDG · 1.4.0 · 17.2KiB	PGDG 1.4.0 el9.aarch64.pg15 : timestamp9_15 timestamp9_15-1.4.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.0 · 17.3KiB timestamp9_15-1.3.0-1.rhel9.aarch64.rpm PGDG · 1.3.0 · 17.0KiB timestamp9_15-1.1.0-1.rhel9.aarch64.rpm PGDG · 1.1.0 · 16.6KiB	PGDG 1.4.0 el9.aarch64.pg14 : timestamp9_14 timestamp9_14-1.4.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.4.0 · 17.3KiB timestamp9_14-1.3.0-1.rhel9.aarch64.rpm PGDG · 1.3.0 · 16.9KiB timestamp9_14-1.1.0-1.rhel9.aarch64.rpm PGDG · 1.1.0 · 16.5KiB
el10.x86_64	PGDG 1.4.0 el10.x86_64.pg18 : timestamp9_18 timestamp9_18-1.4.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.0 · 17.7KiB timestamp9_18-1.4.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.x86_64.pg17 : timestamp9_17 timestamp9_17-1.4.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.0 · 17.7KiB timestamp9_17-1.4.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.x86_64.pg16 : timestamp9_16 timestamp9_16-1.4.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.0 · 17.7KiB timestamp9_16-1.4.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.x86_64.pg15 : timestamp9_15 timestamp9_15-1.4.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_15-1.4.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.0 · 18.3KiB	PGDG 1.4.0 el10.x86_64.pg14 : timestamp9_14 timestamp9_14-1.4.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_14-1.4.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.4.0 · 18.3KiB
el10.aarch64	PGDG 1.4.0 el10.aarch64.pg18 : timestamp9_18 timestamp9_18-1.4.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_18-1.4.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.aarch64.pg17 : timestamp9_17 timestamp9_17-1.4.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_17-1.4.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.aarch64.pg16 : timestamp9_16 timestamp9_16-1.4.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_16-1.4.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.0 · 18.2KiB	PGDG 1.4.0 el10.aarch64.pg15 : timestamp9_15 timestamp9_15-1.4.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_15-1.4.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.0 · 18.3KiB	PGDG 1.4.0 el10.aarch64.pg14 : timestamp9_14 timestamp9_14-1.4.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.4.0 · 17.8KiB timestamp9_14-1.4.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.4.0 · 18.3KiB
d12.x86_64	PGDG 1.4.0 d12.x86_64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg12+1_amd64.deb PGDG · 1.4.0 · 9.8KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d12.x86_64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg12+1_amd64.deb PGDG · 1.4.0 · 9.8KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d12.x86_64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg12+1_amd64.deb PGDG · 1.4.0 · 9.8KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d12.x86_64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg12+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d12.x86_64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg12+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.0 · 8.6KiB
d12.aarch64	PGDG 1.4.0 d12.aarch64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg12+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d12.aarch64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg12+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.0 · 8.7KiB	PGDG 1.4.0 d12.aarch64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg12+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.0 · 8.7KiB	PGDG 1.4.0 d12.aarch64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg12+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.0 · 8.7KiB	PGDG 1.4.0 d12.aarch64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg12+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.0 · 8.7KiB
d13.x86_64	PGDG 1.4.0 d13.x86_64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg13+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~trixie_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d13.x86_64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg13+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~trixie_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d13.x86_64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg13+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~trixie_amd64.deb PIGSTY · 1.4.0 · 8.5KiB	PGDG 1.4.0 d13.x86_64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg13+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~trixie_amd64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d13.x86_64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg13+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~trixie_amd64.deb PIGSTY · 1.4.0 · 8.6KiB
d13.aarch64	PGDG 1.4.0 d13.aarch64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg13+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~trixie_arm64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d13.aarch64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg13+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~trixie_arm64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d13.aarch64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg13+1_arm64.deb PGDG · 1.4.0 · 9.9KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~trixie_arm64.deb PIGSTY · 1.4.0 · 8.6KiB	PGDG 1.4.0 d13.aarch64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg13+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~trixie_arm64.deb PIGSTY · 1.4.0 · 8.7KiB	PGDG 1.4.0 d13.aarch64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg13+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~trixie_arm64.deb PIGSTY · 1.4.0 · 8.7KiB
u22.x86_64	PGDG 1.4.0 u22.x86_64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg22.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~jammy_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.x86_64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg22.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~jammy_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.x86_64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg22.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~jammy_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.x86_64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg22.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~jammy_amd64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u22.x86_64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg22.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~jammy_amd64.deb PIGSTY · 1.4.0 · 9.3KiB
u22.aarch64	PGDG 1.4.0 u22.aarch64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg22.04+1_arm64.deb PGDG · 1.4.0 · 9.8KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~jammy_arm64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.aarch64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg22.04+1_arm64.deb PGDG · 1.4.0 · 9.9KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~jammy_arm64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.aarch64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg22.04+1_arm64.deb PGDG · 1.4.0 · 9.8KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~jammy_arm64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u22.aarch64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg22.04+1_arm64.deb PGDG · 1.4.0 · 9.9KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~jammy_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u22.aarch64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg22.04+1_arm64.deb PGDG · 1.4.0 · 9.9KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~jammy_arm64.deb PIGSTY · 1.4.0 · 9.3KiB
u24.x86_64	PGDG 1.4.0 u24.x86_64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg24.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~noble_amd64.deb PIGSTY · 1.4.0 · 9.1KiB	PGDG 1.4.0 u24.x86_64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg24.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~noble_amd64.deb PIGSTY · 1.4.0 · 9.1KiB	PGDG 1.4.0 u24.x86_64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg24.04+1_amd64.deb PGDG · 1.4.0 · 9.9KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~noble_amd64.deb PIGSTY · 1.4.0 · 9.1KiB	PGDG 1.4.0 u24.x86_64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg24.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~noble_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u24.x86_64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg24.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~noble_amd64.deb PIGSTY · 1.4.0 · 9.2KiB
u24.aarch64	PGDG 1.4.0 u24.aarch64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg24.04+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~noble_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u24.aarch64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg24.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~noble_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u24.aarch64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg24.04+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~noble_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u24.aarch64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg24.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~noble_arm64.deb PIGSTY · 1.4.0 · 9.4KiB	PGDG 1.4.0 u24.aarch64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg24.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~noble_arm64.deb PIGSTY · 1.4.0 · 9.3KiB
u26.x86_64	PGDG 1.4.0 u26.x86_64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg26.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~resolute_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u26.x86_64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg26.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~resolute_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u26.x86_64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg26.04+1_amd64.deb PGDG · 1.4.0 · 10.0KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~resolute_amd64.deb PIGSTY · 1.4.0 · 9.2KiB	PGDG 1.4.0 u26.x86_64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg26.04+1_amd64.deb PGDG · 1.4.0 · 10.1KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~resolute_amd64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u26.x86_64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg26.04+1_amd64.deb PGDG · 1.4.0 · 10.1KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~resolute_amd64.deb PIGSTY · 1.4.0 · 9.3KiB
u26.aarch64	PGDG 1.4.0 u26.aarch64.pg18 : postgresql-18-timestamp9 postgresql-18-timestamp9_1.4.0-2.pgdg26.04+1_arm64.deb PGDG · 1.4.0 · 10.0KiB postgresql-18-timestamp9_1.4.0-2PIGSTY~resolute_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u26.aarch64.pg17 : postgresql-17-timestamp9 postgresql-17-timestamp9_1.4.0-2.pgdg26.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-17-timestamp9_1.4.0-2PIGSTY~resolute_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u26.aarch64.pg16 : postgresql-16-timestamp9 postgresql-16-timestamp9_1.4.0-2.pgdg26.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-16-timestamp9_1.4.0-2PIGSTY~resolute_arm64.deb PIGSTY · 1.4.0 · 9.3KiB	PGDG 1.4.0 u26.aarch64.pg15 : postgresql-15-timestamp9 postgresql-15-timestamp9_1.4.0-2.pgdg26.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-15-timestamp9_1.4.0-2PIGSTY~resolute_arm64.deb PIGSTY · 1.4.0 · 9.4KiB	PGDG 1.4.0 u26.aarch64.pg14 : postgresql-14-timestamp9 postgresql-14-timestamp9_1.4.0-2.pgdg26.04+1_arm64.deb PGDG · 1.4.0 · 10.1KiB postgresql-14-timestamp9_1.4.0-2PIGSTY~resolute_arm64.deb PIGSTY · 1.4.0 · 9.4KiB

构建

您可以使用 pig build 命令构建 timestamp9 扩展的 DEB 包：

BASH

pig build pkg timestamp9         # 构建 DEB 包

安装

您可以直接安装 timestamp9 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH

pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install timestamp9;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y timestamp9 -v 18  # PG 18
pig ext install -y timestamp9 -v 17  # PG 17
pig ext install -y timestamp9 -v 16  # PG 16
pig ext install -y timestamp9 -v 15  # PG 15
pig ext install -y timestamp9 -v 14  # PG 14

dnf

BASH

dnf install -y timestamp9_18       # PG 18
dnf install -y timestamp9_17       # PG 17
dnf install -y timestamp9_16       # PG 16
dnf install -y timestamp9_15       # PG 15
dnf install -y timestamp9_14       # PG 14

apt

BASH

apt install -y postgresql-18-timestamp9   # PG 18
apt install -y postgresql-17-timestamp9   # PG 17
apt install -y postgresql-16-timestamp9   # PG 16
apt install -y postgresql-15-timestamp9   # PG 15
apt install -y postgresql-14-timestamp9   # PG 14

创建扩展：

SQL

CREATE EXTENSION timestamp9;

用法

timestamp9: PostgreSQL 的纳秒精度时间戳类型

timestamp9 扩展提供纳秒精度的时间戳类型，底层以 64 位整数存储，即自 UNIX 纪元以来的纳秒数。

SQL

CREATE EXTENSION timestamp9;

数据类型

timestamp9 支持从 1970-01-01 到 2262-04-12 的时间戳，精度为纳秒。

输入格式

SQL

-- 标准 PostgreSQL 格式
SELECT '2019-09-19 08:30:05'::timestamp9;

-- 带时区的完整纳秒精度
SELECT '2019-09-19 08:30:05.123456789 +0200'::timestamp9;

-- 从 bigint 转换，自纪元以来的纳秒数
SELECT 1568878205123456789::bigint::timestamp9;

类型转换

与 timestamp 和 timestamptz 之间的相互转换
与 date 之间的相互转换

转换过程中会保留纳秒精度。

运算符

SQL

-- 比较
SELECT '2019-09-19'::timestamp9 > '2019-09-18'::timestamp9;  -- true

-- 与 interval 的算术运算
SELECT '2019-09-19 23:00:00.123456789'::timestamp9 + interval '1 day';

-- 减法
SELECT '2019-09-20'::timestamp9 - '2019-09-19'::timestamp9;

函数

SQL

SELECT greatest('2019-09-19'::timestamp9, '2019-09-20'::timestamp9);

索引支持

支持 Btree 和 Hash 索引。

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。