postgresql 모든 데이터 타입 활용하여 테이블 만들기

PostgreSQL 의 모든 데이터 타입을 알아볼겸, 테스트할 때 종종 사용할 일이 있을 것 같아 남깁니다.

create table sample01
(
	  col_serial    serial         not null
	, col_bigserial bigserial      not null
	, col_char      char(20)       not null
, col_character character(20)
, col_nchar     nchar(20)
	, col_varchar   varchar(20)    default 'empty'
, col_bytea     bytea
, col_text  	text
	, col_json      json
	, col_jsonb      jsonb
, col_smallint  smallint
, col_int       int
	, col_bigint    bigint
, col_decimal   decimal
	, col_decimal_ps decimal(10,5)
, col_numeric   numeric
	, col_numeric_ps numeric(5,3)
, col_double_precesion  double precision
, col_float     float
, col_real      real
, col_date      date
	, col_time      time
	, col_time_tz   time with time zone
, col_timestamp timestamp
	, col_timestamp_tz timestamp with time zone
	, col_interval_ytm interval year to month
	, col_interval_dts interval day to second
	, col_boolean   boolean
	, col_money     money
	, col_name      name
	, col_point     point
	, col_line      line
	, col_lseg      lseg
	, col_box       box
	, col_path      path
	, col_polygon   polygon
	, col_circle    circle
	, col_cidr      cidr
	, col_inet      inet
	, col_macaddr   macaddr
	, col_bit       bit(20)
	, col_varbit    varbit(20)
	, col_tsvector  tsvector
	, col_tsquery   tsquery
	, col_oid       oid
	, col_uuid      uuid
	, col_xml       xml
);