1、自增id:id SERIAL PRIMARY KEY
2、注释需另外加
comment on column user.userid is 'xxxxx';
comment on table user is 'xxxxx';
3、int(*)-> integer,double ->real
4、日期:datetime->date
5、时间戳:timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP -> timestamp without time zone DEFAULT now(),
6、类似于com_list_all表中的corent,不标准的json,无法导入
7、分页:mysql是limit startIndex,pageSize pg是 limit pageSize offset startIndex
8、索引:CREATE INDEX index_name ON com_list_all (ent_name);
9、unsigned,pg暂时没找到解决办法
10、关键字,类似于user,需要加双引号
11、视图:
CREATE OR REPLACE VIEW public.view1 AS
SELECT * FROM table1 where ***
12、创建自增序列
CREATE SEQUENCE tbName_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
</