https://www.sqlines.com/ 2026-04-09T06:55:44+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2011-12-11T09:06:39+00:00 https://www.sqlines.com/postgresql/datatypes/int?rev=1323594399&do=diff INT data type stores 32-bit integer data. Syntax INT or INTEGER Quick Example CREATE TABLE t (c INT); Range -231 to 231-1 (2 Gb) Storage Size 4 bytes Synonyms INT, INTEGER and INT4 Versions: PostgreSQL 9.x and 8.x Related Data Types in PostgreSQL Related data types for INT/INTEGER in PostgreSQL: text/html 2022-10-22T05:59:17+00:00 https://www.sqlines.com/postgresql/datatypes/serial?rev=1666418357&do=diff SERIAL data type allows you to automatically generate unique integer numbers (IDs, identity, auto-increment, sequence) for a column. Quick Example: -- Define a table with SERIAL column (id starts at 1) CREATE TABLE teams ( id SERIAL UNIQUE, name VARCHAR(90) ); -- Insert a row, ID will be automatically generated INSERT INTO teams (name) VALUES ('Tottenham Hotspur'); -- Retrieve generated ID (just one of the possible options) SELECT LASTVAL(); -- R… text/html 2011-12-14T09:01:21+00:00 https://www.sqlines.com/postgresql/datatypes/text?rev=1323853281&do=diff TEXT data type stores variable-length character data. Syntax TEXT Quick Example CREATE TABLE t (c TEXT); Range up to 1 Gb Trailing Spaces Stored and retrieved if data contains them. Significant in comparison Versions: PostgreSQL 9.x and 8.x