Pg_restore can operate in two modes. If a databases title is specified, pg_restore connects to that database and restores archive contents specifically in to the databases. If not, a script that contains the SQL instructions essential to rebuild the database is produced and published into a file or typical output. http://remingtonqxbgj.thezenweb.com/The-smart-Trick-of-PG-That-Nobody-is-Discussing-39924505