526互联

PostgrepSQL常用操作小记

发布时间 2023-04-06 11:13:49作者: DeepInThought
  • pg_dump导入导出
## 导出
# pg_dump -h <hostname> -p <port> -U <username> -s <database_name> > <file_name>
pg_dump -h localhost -p 5432 -U postgres -s mydatabase > mydatabase_schema.sql

## 导入
# psql -h <hostname> -p <port> -U <username> <database_name> < <file_name>
psql -h localhost -p 5432 -U postgres mydatabase_new < mydatabase_schema.sql