Dump all databases
pg_dumpall --clean > databases.sqlDump a database with compression (-Fc)
pg_dump -Fc --file=database.sql --clean databaseDump a table
pg_dump [-d database] [--schema schema] -t tableDump a table definition (no data)
pg_dump -s [-d database] [--schema schema] -t tableRestore a database from a dump file
pg_restore -Fc database.sql
No comments:
Post a Comment