Psql PgDump

Psql 和 PgDump 的使用

在新库中创建相同的角色(用户)

create user some_user with password 'password';

create database some_db owner some_user;

grant all privileges on database some_db to some_user;

pg_dump -U some_user -d some_db > some_db.sql

psql -U some_user -d some_db < some_db.sql

1	`\c some_db`

\dt