postgresql数据库基本操作

创建数据库：CREATE DATABASE dbname;
删除数据库：DROP DATABASE dbname;
连接数据库：\c dbname;
创建表：CREATE TABLE table_name (column1 datatype, column2 datatype, ...);
删除表：DROP TABLE table_name;
插入数据：INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
更新数据：UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
删除数据：DELETE FROM table_name WHERE condition;
查询数据：SELECT column1, column2, ... FROM table_name WHERE condition;
数据排序：SELECT column1, column2, ... FROM table_name ORDER BY column3 DESC;
数据分组：SELECT column1, sum(column2) FROM table_name GROUP BY column1;
连接表：SELECT column1, column2, ... FROM table1 INNER JOIN table2 ON table1.column3 = table2.column4;
建立索引：CREATE INDEX index_name ON table_name (column1);
删除索引：DROP INDEX index_name;
事务处理：BEGIN; UPDATE table_name SET column1 = value1 WHERE condition; COMMIT