常用的PostgreSQL命令匯總

1. 連接到數(shù)據(jù)庫(kù):

psql -U username -d dbname

2. 查看數(shù)據(jù)庫(kù)列表:

\l

3. 查看表格列表:

\dt

4. 查看表格結(jié)構(gòu):

\d table_name

5. 創(chuàng)建數(shù)據(jù)庫(kù):

CREATE DATABASE dbname;

6. 刪除數(shù)據(jù)庫(kù):

DROP DATABASE dbname;

7. 創(chuàng)建表格:

CREATE TABLE table_name (
   column1 datatype,
   column2 datatype,
   ...
);

8. 刪除表格:

DROP TABLE table_name;

9. 插入數(shù)據(jù):

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

10. 查詢(xún)數(shù)據(jù):

SELECT * FROM table_name;

11. 更新數(shù)據(jù):

UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

12. 刪除數(shù)據(jù):

DELETE FROM table_name WHERE condition;

13. 導(dǎo)出數(shù)據(jù):

COPY table_name TO 'file_path' DELIMITER ',' CSV HEADER;

14. 導(dǎo)入數(shù)據(jù):

COPY table_name FROM 'file_path' DELIMITER ',' CSV HEADER;

15. 備份數(shù)據(jù)庫(kù):

pg_dump dbname > backup.sql

16. 恢復(fù)數(shù)據(jù)庫(kù):

psql -d dbname -f backup.sql

17. 停止數(shù)據(jù)庫(kù):

pg_ctl stop -D /path/to/data/directory

18. 啟動(dòng)數(shù)據(jù)庫(kù):

pg_ctl start -D /path/to/data/directory