Ispirer Ispirer
 


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

PostgreSQL Data Types - SERIAL

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - SERIAL
Syntax SERIAL
Data 32-bit auto-increment integer data, NOT NULL constraint is applied, UNIQUE and PRIMARY KEY constraints are not automatically assigned
Range -231 to 231-1
Storage Size 4 bytes
Internals Implemented as INTEGER with DEFAULT nextval for a sequence
Synonyms SERIAL4
Version Differences PostgreSQL 7.3 - SERIAL is automatically defined as UNIQUE
Standards PostgreSQL Extension

The following definition

CREATE TABLE tab (
  col SERIAL
);

is equivalent to specifying

CREATE SEQUENCE tab_col_seq;
CREATE TABLE tab (
  col INTEGER NOT NULL DEFAULT nextval('tab_col_seq')
);
ALTER SEQUENCE tab_col_seq OWNED BY tab.col;

PostgreSQL SERIAL - Equivalents in Other Databases

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

Related Data Types in PostgreSQL

Data Types
Integers BIGINT INT SMALLINT
Auto-increment integers BIGSERIAL
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/serial.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement