Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Dump and Restore

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>, pgsql-admin(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Dump and Restore
Date: 2004-08-24 17:12:12
Message-ID: 1093367532.15248.8.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-general
On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti wrote:
> I am using pg_dump.
> It means that I can't restore to a different name
> database??

If you use pg_dump[all] without other options it will dump to a text
file.  Just edit the database name.

Oliver Elphick                                          olly(at)lfix(dot)co(dot)uk
Isle of Wight                    
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
     "I saw in the night visions, and, behold, one like the 
      Son of man came with the clouds of heaven, and came to
      the Ancient of days, and they brought him near before 
      him. And there was given him dominion, and glory, and 
      a kingdom, that all people, nations, and languages, 
      should serve him; his dominion is an everlasting 
      dominion, which shall not pass away, and his kingdom 
      that which shall not be destroyed."     
                                    Daniel 7:13,14

In response to


pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2004-08-24 17:42:08
Subject: Re: PostgreSQL Migration of databases 7.2 to 7.4
Previous:From: Christopher BrowneDate: 2004-08-24 17:04:38
Subject: Re: PostgreSQL Migration of databases 7.2 to 7.4

pgsql-general by date

Next:From: Devrim GUNDUZDate: 2004-08-24 17:12:39
Subject: Re: SELECT to an external file
Previous:From: Mário GamitoDate: 2004-08-24 17:08:26
Subject: SELECT to an external file

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group