POSTGRESQL Database Import and Export

1. Import the entire database

   Psql-u postgres (user name) database name (default is the same as user name) </data/dum.sql

2. Export the entire database

   Pg_dump-h localhost-u postgres (user name) database name (default is the same as user name) >/data/dum.sql

3. Export a table

   Pg_dump-h localhost-u postgres (user name) database name (default is the same as user name)-T table (table name) >/data/dum.sql

4. Compression method

   Generally using dump to export data will be larger, we recommend using XZ compression

   Compression method XZ Dum.sql generates DUM.SQL.XZ files

5. XZ Compression Data Countdown database method

   Xzcat/data/dum.sql.xz | Psql-h localhost-u postgres (user name) database name (default is the same as user name)

POSTGRESQL Database Import and Export