我试图向日志表中插入一行数据,但出现了错误信息。><
log
表的结构如下:
no integer NOT NULL nextval('log_no_seq'::regclass)
ip character varying(50)
country character varying(10)
region character varying(10)
city character varying(50)
postalCode character varying(10)
taken numeric
date date
我的查询如下:
INSERT INTO log (ip,country,region,city,postalCode,taken,date) VALUES
("24.24.24.24","US","NY","Binghamton","11111",1,"2011-11-09")
=> 错误:关系“log”的列“postalcode”不存在
第二次尝试查询:(不包含postalcode)
INSERT INTO log (ip,country,region,city,taken,date) VALUES
("24.24.24.24","US","NY","11111",1,"2011-11-09")
=> 错误:列“24.24.24.24”不存在
我不知道我做错了什么...
PostgreSQL没有日期时间类型吗?(2011-11-09 11:00:10)