PostgreSQL 如何实现 insert or update 的操作?报错

                    <p>INSERT INTO table1 (id, count) VALUES (1,1) ON CONFLICT (id) DO UPDATE SET count = <strong>table1.</strong>count + 1</p>

                

                    <p>改成 </p>

INSERT INTO table1 (id, count) VALUES (1,1) ON CONFLICT (id) DO UPDATE SET count = table1.count + 1

就可以了，哈哈

                    PostgreSQL on duplicate update https://my.oschina.net/beetlerx/blog/1554475 
                

                        谢谢：）