Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/bigserial.txt · Last modified: March 20, 2013, 04:07:32 AM (external edit)
 
Ispirer Ispirer © 1999-2014, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement