PostgreSQL Data Types - TEXT

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - TEXT
Syntax	TEXT
Data	Variable-length character data
Range	1G
Trailing Spaces	Not removed when the value is stored and retrieved. Trailing spaces are significant in comparison.
Character Set	Database default
Storage Size	actual entry length
Standards	PostgreSQL Extension

PostgreSQL TEXT - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	CLOB, 4G; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server	VARCHAR(n \| max), 1 ⇐ n ⇐ 8000, 2G if max is specified
MySQL	LONGTEXT, 4G
Sybase ASE	TEXT, 2G
Informix	TEXT, 2G, CLOB, 4T
HP Neoview	VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres	LONG VARCHAR, 2G; LONG NVARCHAR, 2G, Unicode - UTF-8

Related Data Types in PostgreSQL

Data Types
Fixed-length character data	CHAR(n)
Variable-length character data	VARCHAR(n)

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

Ingres