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/>