Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - BIGSERIAL

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - BIGSERIAL
Syntax BIGSERIAL
Data 64-bit auto-increment integer data, NOT NULL constraint is applied, UNIQUE and PRIMARY KEY constraints are not automatically assigned
Range -263 to 263-1
Storage Size 8 bytes
Internals Implemented as BIGINT with DEFAULT nextval for a sequence
Synonyms SERIAL8
Standards PostgreSQL Extension

PostgreSQL BIGSERIAL - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(19,0) with SEQUENCE object
SQL Server BIGINT with IDENTITY property
MySQL BIGINT with AUTO_INCREMENT property
Sybase ASE NUMERIC(10,0) with IDENTITY property
Informix BIGSERIAL

Related Data Types in PostgreSQL

Data Types
Integers BIGINT INT SMALLINT
Auto-increment integers SERIAL
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.