how to import dump file in postgresql

first, the use of Pg_dump:Import and export of databases is one of the most commonly used features, each of which provides tools for this, such as Oracle's Exp/imp,informix Dbexp/dbimp,mysql mysqldump, and PostgreSQL provides a corresponding tool

PostgreSQL tutorial (18): client commands (2), postgresql tutorial VII. pg_dump: Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking

first, the use of Pg_dump:Import and export of databases is one of the most commonly used features, each of which provides tools for this, such as Oracle's Exp/imp,informix Dbexp/dbimp,mysql mysqldump, and PostgreSQL provides a corresponding tool

http://www.cnblogs.com/chenmh/p/5300370.html IntroductionIn daily maintenance work often need to export the data, and mysqldump is to export the data process is a very frequent use of a tool, it comes with a lot of function parameters, the article

PostgreSQL quickly writes/reads large amounts of data http://www.cnblogs.com/podolski/p/7152144.htmlEnvironment and testingUse. NET driver Npgsql to connect to the post database. Configuration: Win10 x64, i5-4590, 16G DDR3, SSD 850EVO.PostgreSQL 9.6.

Usage of the mysqldump command1. Export all librariesSystem command LineMysqldump-uusername-ppassword--all-databases > All.sql2. Import all librariesMySQL command lineMysql>source All.sql;3. Export some librariesSystem command

Use of the mysqldump command 1. Export all libraries System command Line Mysqldump-uusername-ppassword--all-databases > All.sql 2. Import all libraries MySQL command line Mysql>source All.sql; 3. Export some libraries System command Line

This article mainly introduces the mysqldump command for importing and exporting database methods and instance summary. if you need it, refer to the usage of mysqldump command. 1. export all databases System command

Seven, Pg_dump: Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by

1. Install phpPgAdminDecompress the downloaded package Run the following command for tar.gz: Copy codeThe Code is as follows: gunzip phpPgAdmin-* .tar.gzTar-xvf phpPgAdmin-*. tar Run the following command for tar.bz2: Copy codeThe Code is as follows: