Skip to content
Pinter Computing

Knowledge Base for IT Professionals, Teachers, and Astronauts

Pinter Computing

Knowledge Base for IT Professionals, Teachers, and Astronauts

  • Home
  • Programming
  • DevOps
  • Project Management
  • Software and Hardware
  • Miscellaneous
  • Egyebek
  • About
  • Experience
  • Education
  • Contact
  • Home
  • Programming
  • DevOps
  • Project Management
  • Software and Hardware
  • Miscellaneous
  • Egyebek
  • About
  • Experience
  • Education
  • Contact
Close

Search

Home/Knowledge Base/Creating tables with PostgreSQL
Knowledge Base

Creating tables with PostgreSQL

By Laszlo Pinter
June 5, 2023 1 Min Read
0

Identity columns

There are three auto incremented identity columns types in PostgreSQL

NameStorageRange
SMALLSERIAL2 bytes1 to 32,767
SERIAL4 bytes1 to 2,147,483,647
BIGSERIAL8 bytes1 to 9,223,372,036,854,775,807

To create a new identity column use the following syntax

CREATE TABLE vehicle(
   id SERIAL PRIMARY KEY,
   name VARCHAR NOT NULL
);
Author

Laszlo Pinter

Follow Me
Other Articles
Previous

… you might have mixed up default and named imports

Next

Horizontal scrolling cards

No Comment! Be the first one.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Last Changes

  • How to convert STL file to solid in FreeCAD November 16, 2026
  • FreeCAD installation issue November 15, 2026
  • Happy, the AI hardware robot - understanding - speech to text November 15, 2026
  • Building Happy, the AI hardware robot November 14, 2026
  • Happy, the AI hardware robot – Configuration November 14, 2026

Tags

.NET .NETcore 3Dprinting AI AutodeskInventor AWS C# Chef cloud DevOps Docker EntityFramework Games Git Go iOS iPad iPhone iPod Java Kubernetes Linux MacOSX MSSQL MVC MySql Node.js Packer Python RDS RightScale Ruby security Splunk TeamCity Terraform TestKitchen Tomcat Ubuntu Vagrant VirtualBox VisualStudio Windows WordPress Xcode

Recent Comments

  • Laszlo Pinter on Turn off the built in touchpad when a mouse is attached
  • Kenneth Bush on Turn off the built in touchpad when a mouse is attached
  • Zengei László on MyHeritage családfa exportálása és küldése emailben
  • Raúl Castillo on DynDns update error
  • MICHAEL on Windows Media Player 12 cannot find the album information

–

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright 2026 — Pinter Computing. All rights reserved.