PostgreSQL增删改查

增

建表后右键表名-脚本-insert脚本

填写需要插入的数据即可

批量插入

INSERT INTO EMPLOYEES( ID, NAME, AGE, ADDRESS, SALARY)
VALUES (1, 'Maxsu', 25, '海口市人民大道2880号', 109990.00 ), 
        (2, 'minsu', 25, '广州中山大道 ', 125000.00 ), 
        (3, '李洋', 21, '北京市朝阳区', 185000.00), 
        (4, 'Manisha', 24, 'Mumbai', 65000.00), 
        (5, 'Larry', 21, 'Paris', 85000.00); 

查

SELECT "column1", "column2".."column" FROM "table_name";
查全部
SELECT * FROM "table_name"; 

例子

SELECT*FROM myschema."EMPLOYEES";效果相同  

更新

语法
UPDATE table_name 
SET column1 = value1, column2 = value2...., columnN = valueN 
WHERE [condition];

例

UPDATE myschema."EMPLOYEES"
SET age=29, salary=100
WHERE id=1;
    

删除

DELETE FROM table_name 
WHERE [condition];

例
不加WHERE条件就是删除表中所有行
DELETE FROM myschema."EMPLOYEES"
WHERE id=1;