I have an empty database that we recreated from scratch in order to make some column changes. I would like to restore the data that was in the original database. Will it work given that their are some new fields that did not exist before? Am I correct in that I cannot do this from pg_restore since it is a plain text file?
The data dump was created using the following syntax:
pg_dump genex -u -a > ./genex_data.backup (I have to use the -u switch since I have implemented forced sign on through the pg_passwd utility)
How can I get this data back in? pg_restore? psql command? and if so what is the appropriate syntax becasue I have tried this and its not working.
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
pgsql-admin by date
|Next:||From: Stephan Szabo||Date: 2002-03-27 17:43:08|
|Subject: Re: timestamp in 7.2|
|Previous:||From: Joe Conway||Date: 2002-03-27 16:36:15|
|Subject: Re: join vs. IN statement|