SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
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
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
Discussion