mitshan的博客

安装 apt install postgresql 就可以了, 如果没有权限, 在前面加上sudo. Ubuntu 18.04 默认安装的是10版本. 配置 安装完成后, 有提示 Success. You can now start the database server using: /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/main -l logfile start Ver Cluster Port Status

备份某表的数据到SQL文件(Insert形式) pg_dump -U postgres --table=export_table --data-only --column-inserts my_database > data.sql

Data Definition Language (DDL)Data definite statements are used to define the structures of databases or tables. Statements involved are: CREATE, ALTER, DROP, RENAME, TRUNCATE.Data Manipulation Languag