Re: Data Import

On Tue, 23 Jan 2001 16:07:17 keith wrote:
>Can anyone tell me where to find out information about going from 6.3 to
>6.5?  I have used the "\copy name to name" command to save all of the data
>to a file.  I now want to import this data in 6.5.  Any suggestions?

Export old database:

  pg_dump -d dabasename -D database.sql

This will output the SQL commands to recreate all your tables and data. Then
import it into the new database:

  psql < database.sql

Tony
--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>