Re: [HACKERS] How to...?

On Mon, 9 Mar 1998, Maarten Boekhold wrote:

> On Mon, 9 Mar 1998, The Hermit Hacker wrote:
> 
> > On Mon, 9 Mar 1998, Andrew Martin wrote:
> > 
> > > > 	Then, using what was left, I did:
> > > > 
> > > > psql -e < db.dump 
> > > > 
> > > > 	Again.  Failed misearbly, with the following coming from the 'copy
> > > > to <relname> from stdin;' section:
> > > > 
> > > > 344984  johnb   xgSldZdYEgIWo           clio.trends.ca  n       \N
> > > 
> > > I got something kind-of similar with a core dump... This was 'cos of a 
> > > column name which is now a reserved word.
> > 
> > 	Ack, I fear you are correct...the third field above is 'password',
> > which became a reserved word in v6.3...oh man, is this upgrade ever going
> > to hurt...my 'db.dump' file is 84Meg...vi just loves it :)
> 
> How about starting up your old pgsql, then psql, the 'alter table rename 
> column.....'

	Cause I keep forgetting that I can do that :(  Point taken and
will try that out, thanks...