[260121] PostgreSQL 데이터 타입 종류

PostgreSQL 데이터 타입(data types) 종류 (postgresql 공식 튜토리얼) 

https://www.postgresql.org/docs/current/datatype.html

Chapter 8. Data Types

 

 

1. 공식 문서에 명시된 data type 종류 

Name	Aliases	Description
bigint	int8	signed eight-byte integer
bigserial	serial8	autoincrementing eight-byte integer
bit [ (n) ]		fixed-length bit string
bit varying [ (n) ]	varbit [ (n) ]	variable-length bit string
boolean	bool	logical Boolean (true/false)
box		rectangular box on a plane
bytea		binary data (“byte array”)
character [ (n) ]	char [ (n) ]	fixed-length character string
character varying [ (n) ]	varchar [ (n) ]	variable-length character string
cidr		IPv4 or IPv6 network address
circle		circle on a plane
date		calendar date (year, month, day)
double precision	float, float8	double precision floating-point number (8 bytes)
inet		IPv4 or IPv6 host address
integer	int, int4	signed four-byte integer
interval [ fields ] [ (p) ]		time span
json		textual JSON data
jsonb		binary JSON data, decomposed
line		infinite line on a plane
lseg		line segment on a plane
macaddr		MAC (Media Access Control) address
macaddr8		MAC (Media Access Control) address (EUI-64 format)
money		currency amount
numeric [ (p, s) ]	decimal [ (p, s) ]	exact numeric of selectable precision
path		geometric path on a plane
pg_lsn		PostgreSQL Log Sequence Number
pg_snapshot		user-level transaction ID snapshot
point		geometric point on a plane
polygon		closed geometric path on a plane
real	float4	single precision floating-point number (4 bytes)
smallint	int2	signed two-byte integer
smallserial	serial2	autoincrementing two-byte integer
serial	serial4	autoincrementing four-byte integer
text		variable-length character string
time [ (p) ] [ without time zone ]		time of day (no time zone)
time [ (p) ] with time zone	timetz	time of day, including time zone
timestamp [ (p) ] [ without time zone ]		date and time (no time zone)
timestamp [ (p) ] with time zone	timestamptz	date and time, including time zone
tsquery		text search query
tsvector		text search document
txid_snapshot		user-level transaction ID snapshot (deprecated; see pg_snapshot)
uuid		universally unique identifier
xml		XML data

 

2. 자주 사용되는 데이터 타입 (Data Type) 

분류	타입 이름	설명
숫자	integer / bigint	일반 정수와 큰 정수 (사용자님의 id가 bigint)
문자	varchar(n) / text	가변 길이 문자열. text는 길이 제한이 사실상 없음
날짜/시간	timestamp / timestamptz	날짜와 시간. tz가 붙으면 타임존 정보 포함
불리언	boolean	true, false, null 저장
네트워크	uuid	고유 식별자용 (사용자님의 uuid 컬럼)
기타	json / jsonb	JSON 데이터 저장. jsonb가 검색 속도가 더 빠름
배열	type[]	모든 기본 타입에 []를 붙여 배열로 사용 가능