Name(
姓名
)
Aliases(
别名
)
bigint
int8
bigserial
serial8
bit [ (
n
)]
bit varying [ (
n
) ]
varbit [ (
n
)]
boolean
bool
box
bytea
character [ (
n
) ]
char [ (
n
)]
character varying [ (
n
) ]
varchar [ (
n
)]
cidr
circle
date
double precision
float8
inet
integer
int
,
int4
interval [
fields
] [ (
p
) ]
json
jsonb
line
lseg
macaddr
money
numeric [ (
p
,
s
) ]
decimal [ (
p
,
s
) ]
path
pg_lsn
point
polygon
real
float4
smallint
int2
smallserial
serial2
serial
serial4
text
time [ (
p
) ] [without time zone ]
time [ (
p
) ]with time zone
timetz
timestamp [ (
p
) ] [ without time zone ]
timestamp [ (
p
) ] with time zone
timestamptz
tsquery
tsvector
txid_snapshot
uuid
xml
使用pg数据库的时候,需要将一个字段由varchar类型修改成nu
alter table prplscheduleitems alter column registLossId type numeric(50,0)
语法是alter table 表明 alter column 列名 type 字段类型。