pgsql
逆风而已
这个作者很懒,什么都没留下…
展开
-
pg操作array,json
CREATE TABLE glj ( sip jsonb ) insert into glj(sip) values ('[{"content":"1.1.1.1","type":"ip"},{"content":"1.1.1.2","type":"ip"},{"content":"www.baidu.com&原创 2018-05-31 14:26:19 · 1994 阅读 · 0 评论 -
pgsql upsert语法
INSERT INTO distributors (did, dname) VALUES (5, 'Gizmo Transglobal'), (6, 'Associated Computing, Inc') ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname; INSERT INTO distributors (did,...原创 2018-08-22 09:09:16 · 4382 阅读 · 0 评论 -
psql update高级语法
update test set age=age-1 where name='zhangsan'原创 2019-01-16 16:11:55 · 959 阅读 · 0 评论